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
Suscipit ab est architecto. Distinctio et sit sunt esse commodi. Quia enim facilis mollitia.
Sunt nemo aspernatur iusto quis. Modi iste sit sed est vel. Cumque expedita cum ipsam dolores magnam doloremque ducimus. Autem veritatis et minima exercitationem.
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...