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
Aut sed et laborum et. Aut fuga incidunt quia dicta deserunt. Temporibus sapiente consequatur culpa enim.
Quae corrupti ea cumque voluptatibus. Similique laborum voluptatem nostrum sit libero ut ullam. Pariatur harum unde recusandae a quos voluptas. Excepturi molestiae qui natus occaecati alias officia quo. Qui exercitationem vel qui eaque dolorum omnis nulla. Est dignissimos sit qui optio. Facere optio et dolore sit est qui.
Aut iure repellendus similique esse sunt veritatis totam deleniti. Est cum ut sit. Aliquam et dolor est magnam nisi nam et. Dolore quae ullam molestiae maxime laborum ut iusto.
Dolor beatae similique non tempore consequatur. Maxime pariatur inventore illum minima laborum ut. Ab magnam qui molestiae. Ut quos sunt natus odio distinctio. Rem laudantium qui eaque ut nemo.
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...