- 金币:
-
- 奖励:
-
- 热心:
-
- 注册时间:
- 2005-3-1
|
|
回复 #24 我要生存 的帖子
我要生存, 你好, 帮你转贴一个英文版的问答,可达到释疑的效果。
Since Excel VBA is beloved by so many pros in the QF world. So, matering your Excel VBA skill will be a BIG help? Say, if you don't know other languages (Java, C++, etc) at all...but you're real good at Excel VBA plus some mathematical finance background, can you get jobs like Financial Modeler (just in VBA), or Risk Analyst (use VBA only)?
Reply:
VBA is good for certain things, but personally, i think that it can be a bit slot sometimes on the excel (perhaps its just that i never find shortcuts around) compared to lets say C++, but then there aren't really direct comparisons in terms of use imo. But otherwise, VBA + excel can be a superbly powerful tool, as others mentioned, its links with Datastream, Bloomberg, etc can save you a good few hours or manual plugging into another program.
I think that having VBA as one of several languages you know is highly useful, but i personally believe that although it can suffice to most/many of the functions needed within risk modelling, having knowledge of a complete set of languages including C/C++, matlab is essential as many organisations within risk mgt have a strong emphasis on these others.
For IB/Trading, i would say that having VBA + Excel would suffice, and to me, i would say that 'excel is like windows as C++/java/etc is like the variants of Unix, in that windows is easier to use and everyone understands it as opposed to unix'. Although perhaps a misleading analogy, excel as a base is seen across the finance industry as being a standard (imo).
And honestly, although there may be positions within risk mgt out there which does all its modelling within excel + vba, but i have rarely seen job descriptions within quants/modelling which look for that kind of emphasis, vs other languages. |
|
|