What is VBA used for on Trading Desks?
I'm just trying to grasp what VBA is used for exactly on trading desks so I can build a few projects.
Trending Content - Sales and Trading Forum
Career Resources
In my experience as an intern on a credit trading desk we generally used it to automate data accumulation processes. For example pulling different figures from different workbooks daily to calculate some sort of metric we are tracking. I made several macros for the desk that were basically just pulling data from different sheets, cutting/sorting the data and displaying it in whatever form the desk wants it in. Also used VBA to cut down on simple manual tasks like maing buttons to send daily emails or uploading files to different paths daily etc...
Automation for what old analysts have already been doing on spreadsheets. Create button or quick visualization for data flowing in and out of multiple spreadsheets.
For more adhoc side of things: sometimes I will do some quick calculation myself on spreadsheets since the data is already there. And VBA makes some calculations a bit easier/more manipulatable. Plus you can do some more customizable scrapping and email sending.
Don’t waste your time with VBA.
If you have the time, learn basic python. Or go get in the gym and workout. Or a pub beer.
Thank me later in your career
Already know a bit of python and am striving to improve my skills. What makes you think VBA isn't that important? I've seen a few job descriptions that state VBA as a requirement.
Edit: Also wanted to add that I'm aiming for commodity derivative trading.
Porro nam necessitatibus minima odio non magni a. Molestiae aut qui et eum similique ipsam ab.
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...