Excel/VB for Traders
(Chimp, 9
Points)
on 5/30/12 at 1:07pm
Hi all,
I'm beginning a rotation for the trading unit of a major oil company and was wondering what I could do to brush up my excel/visual basic skills. I'm fairly experienced with excel and have done some work with C++, however, I wanted to get opinions from people on this forum.
So bottom line, for myself and other traders, what would you recommend is best to be familiar with and do you know any good mediums (youtube, websites, etc) that are good learning tools?





Excel VBA for Dummies, no
Excel VBA for Dummies, no joke. Set yourself challenges for stuff to program. Start by making custom functions that calculate the BS price for an option given inputs; do the Greeks as well. Write a sub that will pull off price histories and graph the returns for any number of selected ticker symbols off Yahoo Finance and can be customized for period, date, etc. If you're working on Excel and think something can be automated, try to automate it. Actually trying to figure things out will teach you a lot.
Who are you going to believe, me or your lying eyes?
Not sure of your VB
Not sure of your VB competency since you did you C++ so not sure if this is too easy/hard.
Who are you going to believe, me or your lying eyes?