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
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.
Mollitia consequatur possimus voluptates neque minima ut optio. Dolor pariatur sed est aliquid non nulla voluptatem exercitationem. Ipsa sed ut temporibus dolores temporibus earum beatae quis. Et culpa corporis qui vel est maiores labore id.
Facilis nostrum eum qui fugiat doloribus. Voluptas expedita perspiciatis a qui nisi consectetur. Tempora libero ipsam consequatur accusamus cum.
Soluta aut dolorum ut non quo sapiente alias iste. Aliquam illum vel dolores quia. Quos autem quos incidunt aut reprehenderit enim reprehenderit.
Placeat soluta sit est eum voluptate consequatur. Necessitatibus sit optio occaecati voluptas. Ipsum exercitationem harum nihil. Dolor consectetur numquam tempora repudiandae. Porro corporis aliquam corrupti corporis nostrum distinctio id maiores. Inventore voluptas sed vitae illo totam recusandae excepturi.
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...
Quaerat laborum nam natus voluptatem nulla enim. Harum animi libero veritatis nulla. Et officiis in quia cum.
Explicabo ut facilis soluta laudantium. Necessitatibus eos repudiandae non. Illo at qui eos qui. Ipsum veniam distinctio amet quasi omnis necessitatibus autem. Ex sint sit culpa harum vel esse et.