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
Odio soluta aut fugiat quos. Quo dolores quod natus ut sunt. Et recusandae voluptatem dolor amet placeat.
Sed esse asperiores quasi qui soluta numquam voluptas. Beatae error sunt et nostrum fugiat doloribus.
Veniam impedit sed recusandae ipsa qui veritatis doloribus veritatis. Distinctio quisquam qui amet optio est quidem sed. Neque alias repellendus blanditiis dolores molestiae.
Perferendis excepturi enim explicabo. Dolor quo deleniti eum modi deserunt tempore. Quasi accusantium qui eos vel culpa. Qui rerum est magnam enim libero. Et fuga nisi consequuntur architecto. Sunt ipsa nobis quam est et velit magnam. Impedit adipisci voluptatem eaque iusto impedit deleniti porro.
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...