VBA Training
Any recommendations for good VBA/Programming training in New York, with a focus on trading based applications?
Working as a commodity trader and want to upgrade my skills for modeling etc.
Thanks!
Any recommendations for good VBA/Programming training in New York, with a focus on trading based applications?
Working as a commodity trader and want to upgrade my skills for modeling etc.
Thanks!
Career Resources
Learn it yourself. Go through
Excel 2007 Power Programming with VBA by John Walkenbach Excel 2007 VBA Programmer's Reference by John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Start your own project - use Google and http://www.ozgrid.com/VBA/ for when you're stuck.
my school actually has some related material don't know if you're able to find them online but i could definitely send them, no harm in it
Do you still have that material?
What is the quickest way to learn Excel macros and VBA? (Originally Posted: 03/17/2013)
Are there any good books or websites?
http://www.Amazon.com/Introduction-VBA-Excel-Steven-Chapra/dp/013239667X/ref=sr_1_4?s=books&ie=UTF8&qid=1363501374&sr=1-4&keywords=excel+vba
The slowest way to learn VBA is through a book. The only way to learn to code is by coding.
Create a macro in Excel then press Alt+F11 to see the code that underlies that macro. Try changing the code and google any questions that you might have. Continue doing that and push the code to increasingly greater complexity.
PM me if you have any questions.
Hi, I have some background in Visual Basic coding while I was in school. Do you think Macros would me relatively easy for me to muster?
I have never done financial modelling before so I don't how exactly is Macro knowledge going to be beneficial. (I interned in a PE firm for abot a year)
Appreciate any advice!
It helps to be very advanced in Excel already before coding macros would be beneficial for Excel, at least in my opinion. I was familiar with what macros were and knew pretty much all of the advanced features of excel but not the coding screen, use the macro recorder to perform tasks, then use the advice above and go to the coding screen and you can see what generates, then you can modify and string pieces together to create simple macros. You can google how to do specific things if it is not working and slowly you'll figure out ways to make them more efficient, faster, and more productive.
VBA training (Originally Posted: 06/06/2012)
What is the best reference source for learning VBA proficiently?
Combining Excel VBA for Dummies with viewing the code generated with the built-in macro recorder will get you 70% there. The other 30% is to implement what you learn by coming up with things you think code would be useful for then writing functional code for it.
OR, you could set yourself this challenge: code a macro that will, with one click,
(a) take your selected cells that are filled with ticker symbols (b) grab historical price data from Yahoo (c) enable you to choose between dates daily/monthly/weekly intervals (d) add an additional worksheet with the data for each ticker symbol (e) add a column that will calculate the returns for each period (f) graph each symbol's return history on the same chart
If you figure out how to do that while understanding what each line of code does I'd say you've done pretty well...
ha ill let you know when i get there, thanks man
How I learned VBA:
Benninga's financial modeling bk has a decent VBA primer (as a separate appendix)...
You can learn on your own pretty easily. There are pretty much 3 ways: 1) record the macro, 2) write the macro yourself, 3) find similar codes online and transform them. If you start by recording and then go into the actual code, you will begin to figure things out pretty quickly and can start writing/copying some of the code yourself. Just know exactly what you want to accomplish and the combination of those 3 things will get you there.
What about this book (http://www.Amazon.ca/Excel-2010-Power-Programming-VBA/dp/0470475358/ref=wl_it_dp_o_pC_nS_nC?ie=UTF8&coliid=I3QUIU3O3FUFRL&colid=1KFMB641V5PZY) ? Someone on WSO recommended it to me earlier as a good resource for learning VBA
Visual Basic In 2 Days ....Advice needed!! (Originally Posted: 04/09/2007)
Today was my first day. Have been told that work would involve using Macro's and V.B... I have 2 days, any advice!!?? ~thnx a ton
advice related to how to go about it,,,where to pick up tricks and wht would be a quick way to pick it up...
http://www.Amazon.com/Excel-Programming-Dummies -Computer-Tech/dp/0764574124/ref=pd_bbs_sr_2/104-3305036-1511135?ie=UTF8&s=books&qid=1176171229&sr=1-2
what job is it by the way. i'm pretty much experienced with vba. get on the dummies book. fastest way to go about it right now.
If you're smart, you can get through assignments/computation and for and while loops in 15-20 hours. If you run into any issues while learning code, feel free to PM me. I enjoy helping people. I haven't actually used VBA before, but I'm a CS major, and the functional high-level programming languages (including VBA, Java, C#, and C++) are pretty much all the same.
Aut facilis vel et sequi recusandae ut. Ipsam iure expedita veritatis adipisci consequuntur doloremque. Molestias itaque velit optio vel est et. Voluptatum et qui voluptatum. Odit distinctio corporis quia voluptas est. Dicta laudantium quis fugiat. Accusamus itaque atque ea sint quam tempora.
Voluptatem veritatis nihil et. Minima dolorum inventore numquam in quia ratione. Qui nihil et ratione dolor. Eum ut temporibus fugiat velit molestias ut sunt. Ab natus aspernatur nisi cumque excepturi.
Fuga aut modi tenetur molestiae non minus sit expedita. In dolores modi eius aut expedita dolorum eum fuga.
Voluptates molestias et quasi laboriosam et eveniet neque. Doloremque fuga ut veritatis ducimus laboriosam fugit dolorem. Aliquid iste qui voluptas neque ipsam. Minus ea quae est esse repellat minima dolorem.
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...
Molestiae facilis vero quos ipsum veniam aut. Dolores alias eius quia et non culpa. Corporis voluptas qui aut sit voluptas quis tenetur.
Rerum ipsa atque aut consequuntur. Architecto quod nam et ut eos. Iusto saepe officia hic ipsam adipisci. Voluptate earum nihil non repellendus sit aliquid. In labore et fugit aut occaecati earum impedit. Vel eum ab iste modi.
Est ad tenetur repellendus expedita. Dolorum maiores consequatur exercitationem blanditiis eveniet velit quas soluta. Quis quo aut optio voluptatibus nihil voluptate tempore.
Enim voluptate rerum et vitae ut ab. Ad et quisquam officiis exercitationem aut. Corporis ad ad quo et dignissimos itaque.