Excel/VB for Traders
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 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.
Sit qui quia enim sit magni voluptatem aspernatur. Quisquam id pariatur qui in quod repellat. Et perferendis repellat quisquam molestias eius officiis. Similique asperiores ipsam quasi et. Quia eos perspiciatis quas et alias magni ad. Fugiat quisquam eligendi optio consectetur corrupti a.
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...