VBA programming - Quant career Advice

Chrisbougias's picture
Rank: Monkey | banana points 37

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!

Find Your Mentor

  • Increase your chance of landing a job by matching with one of our 200+ mentors.
  • Our mentors are top employees at the most selective firms.
  • Proven process with over 1,100 clients over 10 years.

Comments (3)

Feb 9, 2019

Hey Chrisbougias, I swear if I had a silver banana for every lonely thread I posted too I'd be richer than @compbanker ...

  • Quant Investment Career. quant career ...
  • Best Way To Start Learning Quant Finance? R career track Quantopian * Access to multiple datasets which you can use immediately with Python along ... Machine Learning for Forex trading Codecademy * Intro course to learn the basics of Python Codeschool ... practice quant finance- and I found tons of material. In fact, it's so much material that I was hoping ...
  • List of Core Books for Quant Engineer/Analyst. the Scientific Betting System That Beat the Casinos and Wall Street Career as a quant My Life as ... Quantitative Professionals Starting Your Career as a Wall Street Quant: A Practical, No-BS Guide to Getting ... a Job in Quantitative Finance and Launching a Lucrative Career Free quant career guide downloads What do ...
  • Learning some basic coding on your own? have any programming background other than one Python class I took during my freshman year, which ... I have entirely forgotten. programming Coding coding language Excel VBA ... I have been quite interested in learning some coding on my own, specifically thinking about VBA to ...
  • Learning Excel VBA on my own to prepare for Trading career... currently have a wealth management internship, but have never used VBA in the office. Excel VBA is clearly ... essential to working as a trader so I wanted to try and learn it on my own so I can put it as a proficiency ... of VBA. Please let me know if you know of any specific videos I could follow along with to learn ...
  • How do I know if I have the math skills necessary to become a quant? quant now when they won math Olympiads during high school, I thought my math skills were up there when ... at math and I'm cut out to become a quant? I feel like I have great social skills so going into ... work out when I have so many other career options that I know I can handle. ...
  • Is there a future for non-quant hedge funds? in my career than post-MBA PE. From what I've read on VIC I also slightly prefer the hedge fund ... much." So is there a future for non-quant hedge funds? I've seen people on here talking about how ... with HFT and quant market making at shops like Citadel, or the firm that Getco became traders can ...
  • More suggestions...

I hope those threads give you a bit more insight.

    • 1
Feb 14, 2019

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

Feb 14, 2019

just google it...you're welcome