Completely agree as well. You can't learn to code by reading a book (in my opinion)
I think it's most important to come up with some incredibly interesting question that you need to know the answer to and that you can only get that answer by using VBA. Learning programming can be really tough, so you need to have a desire and motivation which outpaces the suck.
I will be starting as an SA in S&T in about two weeks and was just wondering if there are any things in terms of VBA that would be helpful to have covered.
I have been going through Jwalks Power Programming one over the past two weeks and doing all the examples and I am semi comfortable reading code and constructing macros but still need to reference back for specific 'grammar' type things.
I took a look at Option Pricing Models and Volatility by Vainberg and a lot of the stuff was a bit over my head.
Just wondering if there are any tasks that are used often in S&T in terms of VBA that I should have a look at before. If it helps I will be doing rotations on the equities side and prob nothing to quant heavy as I only have an econ and fin background.
That will likely be more than enough. VBA wasn't my native programming language either (C++) so if I was unsure about syntax I usually just googled it. Furthermore, out of our entire SA class, only myself and one other intern ever did any programming in VBA, from my experience its generally based on how willing you are to lend help in that area.
Jack: They’re all former investment bankers who were laid off from that economic crisis that Nancy Pelosi caused. They have zero real world skills, but God they work hard.
-30 Rock
Ut tempore non similique dignissimos eaque veniam ipsam nemo. Et cumque ipsa consectetur rerum.
Laborum unde sit sit et voluptatem saepe. Voluptas eum ut dolorum nobis aut minima maiores. Reprehenderit aspernatur sapiente ipsa ipsam consequatur.
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)
Sorry, you need to login or sign up in order to vote. As a new user, you get over 200 WSO Credits free,
so you can reward or punish any content you deem worthy right away. See you on the other side!
Programming with VBA by John Walkenbach has helped me.
Thx.
PM me. I have a book for you.
Have PMed you.
I would be interested in hearing suggestions as well!!
Best way for me to learn it was:
Record a macro, go into the code and see how its done
Ya, I totally agree with this.
x3.
For functionality you get stuck with, there's plenty of material easily found via google.
Completely agree as well. You can't learn to code by reading a book (in my opinion)
I think it's most important to come up with some incredibly interesting question that you need to know the answer to and that you can only get that answer by using VBA. Learning programming can be really tough, so you need to have a desire and motivation which outpaces the suck.
Feel free to PM me if you have any questions.
S&T Intern VBA (Originally Posted: 06/08/2010)
I will be starting as an SA in S&T in about two weeks and was just wondering if there are any things in terms of VBA that would be helpful to have covered.
I have been going through Jwalks Power Programming one over the past two weeks and doing all the examples and I am semi comfortable reading code and constructing macros but still need to reference back for specific 'grammar' type things.
I took a look at Option Pricing Models and Volatility by Vainberg and a lot of the stuff was a bit over my head.
Just wondering if there are any tasks that are used often in S&T in terms of VBA that I should have a look at before. If it helps I will be doing rotations on the equities side and prob nothing to quant heavy as I only have an econ and fin background.
Thanks.
I'm interested too
That will likely be more than enough. VBA wasn't my native programming language either (C++) so if I was unsure about syntax I usually just googled it. Furthermore, out of our entire SA class, only myself and one other intern ever did any programming in VBA, from my experience its generally based on how willing you are to lend help in that area.
Ut tempore non similique dignissimos eaque veniam ipsam nemo. Et cumque ipsa consectetur rerum.
Laborum unde sit sit et voluptatem saepe. Voluptas eum ut dolorum nobis aut minima maiores. Reprehenderit aspernatur sapiente ipsa ipsam consequatur.
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...