Have seen a few listings for commodities analysts reference "commodies supply/demand models." Does anyone know where I can access one of these? Commodities aren't touched on in the usual training programs (TTS, BIWS, etc). Thanks!
Any idea what commodity interested in?
Using energy as an example; we have bank research models, government models (eia, iea), large firms like BP putting out a world energy review etc…
It’s everyone’s secret sauce. You ain’t getting nothing. Plus you need alot of vendors to rebuild. Pipeline flow data, crude storage data etc. eia930, cems, weather, prices.
(Not a commodity expert) but can you explain how pipeline flows help with the supply/demand picture. I never really understood how knowing how much product flows from one place to another helps build models. Do people look at aggregate flow as a proxy for demand? Or specific pipelines are more indicative of demand etc.
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.
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)
Sorry, you need to login or sign up in order to vote. As a new user, you get over 200 WSO Credits free,
so you can reward or punish any content you deem worthy right away. See you on the other side!
Any idea what commodity interested in?
Using energy as an example; we have bank research models, government models (eia, iea), large firms like BP putting out a world energy review etc…
2nd the need for a template, any recs here/examples we can find?
Again, open ended question. Need to be really more specific here. The government has tons of templates.
It’s everyone’s secret sauce. You ain’t getting nothing. Plus you need alot of vendors to rebuild. Pipeline flow data, crude storage data etc. eia930, cems, weather, prices.
Lol I get MS for telling the truth.
How dare you provide an accurate comment to someone who wants you to do all the work for them...
(Not a commodity expert) but can you explain how pipeline flows help with the supply/demand picture. I never really understood how knowing how much product flows from one place to another helps build models. Do people look at aggregate flow as a proxy for demand? Or specific pipelines are more indicative of demand etc.
bump
Remember Econ 101? Think that.
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.
Do you have any sample models you can share?
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.
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...