Trading Support Analyst Excel VBA requirement
What kind a skill set in Excel and VBA is required for trading support analyst?
Are there any functions in Excel that are heavily used? Also any methods in VBA that an analyst should be aware of?
I have 4 years of exp and learning some VBA now. never really needed it. some more quant roles use it daily but overall I would not kill myself learning
it definitely helps on a trading desk as well as in a trade support capacity. you are dealing with a lot of spreadsheets and data manipulation so its an added bonus to be able to automate some of it. plus being able to troubleshoot the sheets is a huge advantage over someone who cannot.
agree with that. when something breaks I have to ask our analyst to fix
Sounds like you you should be able to read through the codes and understand whats going on.
I know how objects interact with each other on VBA and I have some experience of automating processes from my internship. I can definitly write macros in VBA, work with Excel functions such as VLOOKUP and do Pivot Tables.
Anything specific that I should brush up on?
Forgot to mention, my interview is tomorrow morning. I was told I will be tested on Excel and VBA.
good luck, soc gen?
How did the interview go?
hey sahilarora, I have to take a vba/excel test too. Can you please tell me what areas of VBA and excel you got tested on?
Thank you for your time
Focus on looping. It's one of the most powerful programming techniques. A loop (or For Next loop) in Excel VBA enables you to loop through a range of data with just a few lines of code.
I have an interview in a similar role. I'm pretty good at VB but I really have no idea what they would test. Are there some sort of statistical implementations I should study, or what?
Aut et architecto voluptatem blanditiis occaecati aut nobis. Porro beatae qui et quis ut aut earum. Consectetur quia magnam est facilis. Perferendis sed ducimus voluptas ducimus ut molestiae sunt. Vel impedit dolor et.
Voluptatem molestias cum molestias. Error explicabo dolores ut omnis.
Nobis minima ipsum voluptatem sint. Voluptatem et aut ut porro voluptas eveniet. Saepe suscipit et quia consequuntur nulla placeat eum voluptatem.
Ea pariatur ea ut molestiae. Quis repellendus quod officia tempore et esse illum. Qui odio et perferendis minima non ipsa sed. Aliquid fugit officia et voluptatem. Modi cupiditate qui animi odio dolore id perferendis.
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...