Most Helpful

Some of the others have touched on government templates and proprietary data sources, so I'll try to elaborate. The models themselves are pretty straightforward in that they are supply sources minus demand sources with the balance flowing into inventories. Given data is not uniform will generally organize supply and demand into "buckets" that are easier to track and can be forecast. Similarly the inventories data will be checked against available sources with various "adjustment factors." Knowing where to find data sources with some predictive power, where to track realized outturns, and how one should treat "adjustment factors" is the hard part, with the even harder part being translating that to price forecasts. If excel/accounting are the tools for fundamental analysts then r/python/excel/econometrics/statistics/data analytics are the tools for commodity analysts to answer those questions I referenced (of course supplemented with some commodity specific knowledge).

I’ll add some examples for context- imagine trying to project the recovery in miles driven from the height of the pandemic as a proxy for oil demand for autos and thus your demand bucket. Similarly imagine trying to figure out maximum sustainable production capacity for Saudi Arabia to get a sense for how much oil could be supplied, and thus impact your balances/price forecasts, in a price war. Or on the inventory side trying to determine how much China is importing in excess of needs (perhaps for strategic reasons) and whether that will continue.

 

For reasons noted above best I can offer is to go to the EIA/OPEC/BP statistical review of energy and looks at various ways they put together oil supply/demand balances. iirc EIA has an excel based one with global coverage.

If you are interested in how they get the numbers to put in cells then google “how to forecast x” and peruse the papers that come up

 

Iusto quas necessitatibus voluptatibus ab rerum. Voluptatem natus est quas accusantium quae enim. Ipsam odit quia esse iste neque sit a.

Aut aut rerum delectus. Iure est ipsam eveniet commodi mollitia cumque laboriosam. Pariatur in voluptatibus ipsum et aliquam id id. Quo dolorem molestiae qui voluptatem fuga quibusdam. Quod enim voluptas ipsam est quis. Illo cum voluptas accusamus dolores.

Career Advancement Opportunities

May 2024 Hedge Fund

  • Point72 98.9%
  • D.E. Shaw 97.9%
  • Citadel Investment Group 96.8%
  • Magnetar Capital 95.8%
  • AQR Capital Management 94.7%

Overall Employee Satisfaction

May 2024 Hedge Fund

  • Magnetar Capital 98.9%
  • D.E. Shaw 97.8%
  • Blackstone Group 96.8%
  • Two Sigma Investments 95.7%
  • Citadel Investment Group 94.6%

Professional Growth Opportunities

May 2024 Hedge Fund

  • AQR Capital Management 99.0%
  • Point72 97.9%
  • D.E. Shaw 96.9%
  • Magnetar Capital 95.8%
  • Citadel Investment Group 94.8%

Total Avg Compensation

May 2024 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (23) $474
  • Director/MD (12) $423
  • NA (6) $322
  • 3rd+ Year Associate (24) $287
  • Manager (4) $282
  • Engineer/Quant (71) $274
  • 2nd Year Associate (30) $251
  • 1st Year Associate (73) $190
  • Analysts (225) $179
  • Intern/Summer Associate (23) $131
  • Junior Trader (5) $102
  • Intern/Summer Analyst (251) $85
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
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
numi's picture
numi
98.8
10
bolo up's picture
bolo up
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...”