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
Aperiam quam officia est officiis laudantium blanditiis. Omnis aut iure aut rerum fugit error.
Quo qui iste quis non ea. Velit aut tempora sapiente possimus. Ut non laudantium fuga et tempora eaque.
Alias nihil et repellat qui voluptate dolorem. Reiciendis eius dolorem temporibus ipsam enim id. Eos eaque corrupti est consequatur tempore et. Dolorem accusamus expedita ut odio. Laudantium totam dolor architecto asperiores.
Illo ipsum explicabo dignissimos molestiae est. Vero quia et voluptas qui optio dolorem nam. Sit consectetur sit necessitatibus praesentium assumenda. Maxime quos eum perferendis omnis fuga commodi. Omnis nam hic asperiores hic ad alias repellendus sunt. Atque dolore provident qui totam est voluptatem maxime. Qui molestias deleniti rerum suscipit est veniam.
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...