- 金币: 
 -  
 
 
- 奖励: 
 -  
 
 
- 热心: 
 -  
 
 
- 注册时间: 
 - 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. |   
 
 
 
 | 
         |