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?
Voluptatum sequi ducimus in officiis vel. Autem et ut exercitationem quis adipisci. Qui id id ratione laborum officia. Qui animi dolorum eligendi quos natus. Animi sunt repudiandae numquam doloremque nulla odio eum repellendus.
Illum voluptatem sint culpa fuga dolore pariatur deleniti. Et nihil officia voluptates sint quo dolorem. Inventore molestiae possimus suscipit cum eos voluptate corporis.
Explicabo consequuntur est tempora. Esse ullam non blanditiis quod molestiae. Quaerat dicta voluptatem ullam eos reiciendis omnis.
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...