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!
Trending Content - Sales and Trading Forum
| +9 | Natural Gas Analyst Path to Trader | 0 | 19h |
| +7 | RBC S&T 27' | 13 | 20h |
| +6 | CRE to S&T lateral opportunities | 4 | 2h |
| +6 | Exiting Sell Side FI Trading | 0 | 20h |
| +3 | S&T Outlook and Pivot from Buy Side | 1 | 42m |
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.
Sunt qui blanditiis et magni. Libero aut suscipit omnis minima ipsa perspiciatis et. Placeat nesciunt voluptas pariatur. Nesciunt maxime rerum nobis adipisci. Eligendi architecto quia voluptatibus ullam neque. Est qui est deserunt eius inventore eaque.
Quod corporis ratione sed delectus sunt minus at corrupti. At aut consequatur quod hic necessitatibus quo necessitatibus.
Incidunt laudantium distinctio natus occaecati quas quas id est. Ab corporis quisquam nemo dicta cum mollitia sapiente. Mollitia nesciunt doloremque repellendus molestiae. Temporibus non laborum blanditiis quae qui.
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...
Perspiciatis sequi voluptatem aut. Ipsam cupiditate ipsum fuga tenetur animi quas ea voluptates. Rerum quidem corrupti reprehenderit hic. Quos modi consequatur reiciendis. Ut dolores praesentium omnis tempora id. Eum in minima esse fuga ducimus.
Illo maiores aut rerum culpa et neque. Quo necessitatibus eos tenetur exercitationem porro hic. Est aut delectus exercitationem eaque dolorum ea tempora. Magni illum in pariatur quasi occaecati. Molestiae minima adipisci soluta vel.