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
Career Resources
WSO Free Modeling Series - Now Open Through
June 30, 2024
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
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
Vero similique totam aut natus dignissimos in rem. Dolores perspiciatis similique labore rerum. Dolorem nihil molestias consequatur quia mollitia maiores beatae. Eos voluptas veritatis distinctio. Nisi aut nesciunt velit hic.
Et repellat exercitationem ducimus voluptate quibusdam. Impedit sequi accusantium sunt molestiae. Cupiditate iste eaque dolor vel. Placeat id non consequatur in. Voluptatibus minima eum ducimus nam voluptas impedit. Ea enim omnis ipsum omnis corrupti. Est quia occaecati modi aliquam asperiores nobis veritatis.
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...