VBA programming - Quant career Advice
Hi all,
I am currently doing my MSc in Financial Mathematics at LSE and yesterday started a 1-month part-time internship in Quantifi (risk, analytics, and trading solution provider), at London office. The tasks I have to complete throughout my internship are mostly based on VBA programming and Excel in general. My concern is that I have never written a single line of a VBA code (I am totally a newbie on it). In general, I know little things about programming (I am currently learning C++ as part of my master's degree, but I am quite novice).
-
What would you suggest me to do now? Is there any fast as well as effective way to learn VBA and deliver at least some tasks, considering the time constraints (it is a 1-month part-time internship which means I will go 8 full days in total)?
-
Also, I am wondering if VBA is essential for someone who wants to become a quant to learn it. I know that programming languages like Pyhton, C++ and Java are must for a quant career, but haven't heard of extensively using VBA.
PS: I never told the recruiters I know VBA programming!
Thank you in advance for your contribution!
Hey Chrisbougias, I swear if I had a silver banana for every lonely thread I posted too I'd be richer than @compbanker ...
I hope those threads give you a bit more insight.
Just the vba logic is quite simple compared to others. I’d just download models and step through to learn what it does. Then try to create simple functions. I found recording a macro of you doing a certain function is a good way to learn the basics then you use that and add dynamic variables on top. Then when I have a problem or am looking to do something I google it. Based on the foundation you learn how to take the code given and adjust it to the problem you are looking for
Autem eos autem quos ipsum autem quod libero. Voluptatum numquam voluptatum id. Id sit ipsam quo quae. Eos sapiente amet voluptatibus dolor alias autem deleniti. Mollitia voluptates ea aliquid natus.
Sit enim at aperiam voluptates sint. Laboriosam eum voluptate alias dignissimos dolor quis laboriosam non. Id officia iure quo eveniet.
Dolor qui quia sed hic. At velit unde reprehenderit omnis temporibus quisquam dicta. Quia quibusdam sapiente fugit fugiat qui. Laborum commodi eius dicta facere.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...