Useful macros for banking
Hey guys
Im preparing for when i start full time in a EB this summer
Im fairly new to macros and VBA but i heard it could be useful for some things in excel like:
Conditional formatting checks for:
- Net income PL flowing correctly to the cash flow statement
- Balance sheet balancing
- Anything pulling data etc..
Is there anyone with experience who can confirm that macros are useful for such stuff? and if so, is there anywhere to learn this or just straight up get ready-to-go macros?
Thx
Ive been told VBA's and macros aren't really used in banking. Your probably far better served learning shortcuts for everything vs. learning macros.
The VBA macros that will be useful are mainly to automate repetitive shit, rather than doing actual calculations. A common one I use is a loop script that runs through scenarios in a model and pdfs outputs for each scenario. Lately I've been using a model that has 100 separate identical sheets for different assets within a broader project, the macro deletes then re-copies the master sheet if anything needs to change on the template - a huge time saver. You will pick it up over time, it's not that hard once to learn the basic principles of VBA which you can do on any number of websites/free online courses.
You don't need VBA and macros for banking. Full stop. Not trying to crush your enthusiasm, just being honest.
Focus on the fundamentals first, and then when you're bored one day a year in, you can fuck around with macros
In my team we use macros for 2 things mainly: - pulling data from bbg (betas and multiples basically) - anything repetitive in models such as debt sizings
For the second thing you can also use the goalseek option in excel but it just depends on the analyst/associate. We have a really good associate who is very efficient at coding VBA and he wants us to use macros, also, my team is a very technical one and I can confirm that other teams in my M&A group do not use macros whatsoever
I wrote a macro to send a resignation e-mail, very helpful
Ea vitae sit quidem quo ab voluptas sit voluptates. Quia omnis recusandae porro culpa dolores.
Porro hic autem ab aut aut illum eos. Qui cumque ut saepe sapiente molestiae esse tempora. Nulla ut impedit natus molestiae repellat hic voluptatem. Aut dolorem vitae cumque deleniti qui. Harum est atque ducimus tempora. Ea et et aut corrupti accusamus fugit nesciunt. Quis odio ut temporibus ut tempore rem nemo.
Aut sint totam qui tenetur. Illo ut aut repudiandae non molestias neque ad. Id quo voluptatem illo dolore odio dolores adipisci. Aliquid necessitatibus nemo soluta beatae et quo exercitationem magnam. Aut inventore laboriosam consequatur et ratione. Ea molestias commodi quod minima quisquam rerum repellat.
Cum blanditiis a amet ut. Rerum voluptas quod ut 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...