Python, VBA, SQL for junior commodity trader?

Hey, I will start as a physical oil trader in Europe and was wondering how I should best prep myself for the role. I understand that there's a lot of data analysis and supply/demand modeling in the day-to-day tasks and was wondering which tools should i spend the most time learning. 

I have zero prior coding experience.

6 Comments
 

For a junior commodity trader role, especially in physical oil trading, here's how you can prioritize your preparation:

  1. VBA: Based on the most helpful WSO content, VBA is highly relevant for Excel-based programming and analysis. Many trading desks rely on Excel for real-time position tracking, risk management, and quick calculations. Learning VBA will allow you to automate repetitive tasks and troubleshoot issues efficiently, which is crucial when working with dynamic data.

  2. Python: Python is a versatile and increasingly popular tool in finance. It can be used for supply/demand modeling, data analysis, and even building trading algorithms. Python's libraries (like Pandas, NumPy, and Matplotlib) make it ideal for handling large datasets and performing complex analyses. If you have no prior coding experience, Python's intuitive syntax makes it a great starting point.

  3. SQL: SQL is essential for retrieving and organizing data from databases. If your role involves accessing large datasets or maintaining historical data for analysis, SQL will be invaluable. It complements Python well, as Python can import SQL queries for further analysis.

Recommendation: Start with VBA since it directly ties to Excel, which is a staple tool in trading. Once you're comfortable, move on to Python for more advanced modeling and analysis. Finally, learn SQL to handle database-related tasks. Building a small project, like a basic supply/demand model or a position tracker, can help solidify your skills.

For additional resources, you can explore tutorials or courses tailored to finance professionals. If your firm offers internal training or reimburses for external courses, take advantage of those opportunities.

Sources: Programming/Technical Skills for Finance: SQL and Python, Programming/Technical Skills for Finance: SQL and Python, Learning coding on your own for finance?, Technical Skills to Prep for SA S&T, Using VBA as a Fixed Income Sell Side Trader

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 

Vitae qui ut voluptas autem. Voluptatem sed voluptatum non officiis. Quis esse eos laudantium labore necessitatibus aut. Iusto et dolorem maxime. Recusandae soluta modi velit rerum vel non delectus.

Ipsum qui nihil est velit ex rerum itaque. Quisquam ad quas debitis similique fugit numquam. Alias ipsum quasi quia quis tempora culpa. Sint quisquam atque alias eum distinctio deserunt itaque dignissimos. Quos aliquid ipsum animi sed non laboriosam voluptatum. Similique a autem quos sed aliquam ab. Autem id sit voluptatem nobis aliquam hic aut.

Placeat ab aspernatur iure at debitis totam voluptatem explicabo. Illum fugit et rerum et omnis. Sed voluptatem ex suscipit cumque. Exercitationem soluta dignissimos rem ipsam. Quam excepturi eius ut aut et.

Voluptatibus ab voluptas repellendus accusamus. Nobis omnis sed magni suscipit. Consectetur deserunt consequatur ea quia doloribus autem id debitis. Ea neque in in. Error officia quam voluptas consequatur vero distinctio omnis. Libero non numquam quo necessitatibus possimus commodi.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $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

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
GameTheory's picture
GameTheory
98.9
7
DrApeman's picture
DrApeman
98.9
8
dosk17's picture
dosk17
98.9
9
CompBanker's picture
CompBanker
98.9
10
Mimbs's picture
Mimbs
98.8
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...”