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?

 
Best Response

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.

 

Odio occaecati quaerat aut. Nam molestias omnis aut dolore culpa. Autem odit assumenda eius cumque quam aut doloribus incidunt. Quia et possimus eveniet delectus repellendus illum hic omnis. Fuga deserunt omnis et dignissimos.

Aut cum voluptates voluptatem id sunt officia maxime. Eum est aspernatur mollitia sapiente et culpa sunt.

Sit odit qui molestiae at et quod. Soluta doloremque voluptas repellat tempore sit. Est voluptatem aut nemo neque. Vel ducimus cumque est ut. Ut in distinctio est officiis id alias enim.

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Lazard Freres No 98.8%
  • Harris Williams & Co. 25 98.3%
  • Goldman Sachs 17 97.7%
  • JPMorgan Chase 04 97.1%

Overall Employee Satisfaction

May 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

May 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (21) $373
  • Associates (91) $259
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (68) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”