Category Archives: Uncategorized

Data Download: 10-07-2016 Weekly Petroleum Status Report

For the best usability, download the excel file here: Eia_Petroleum_Master_File10-07-2016  and open in your desktop version of Excel 2010 or better.

If you don’t have Excel or are running an older version, you can view the dashboard using the Excel Web App with the embedded copy below. You will likely want to click the icon in the bottom right corner for full screen, then adjust your browser zoom to fit.

Some notes for this week:I received a lot of emails saying they liked the file…but could you add XYZ…. What I decided to do was rename the Dashboard tab “Scott’s Picks”. It has all of the series I keep a close eye on, and is often a weekly number rather than a daily number. To accomodate everyone, I added a second dashboard to the end, with series from EIA’s table 01-Balance Sheet, 04-Stocks, and 08-Crude Imports. It’s still not everything, and I have not edited any of the EIA’s ridiculously long series titles, but it was a simple way to add a lot of data to the file without junking up my own personal masterpiece 🙂 Enjoy!!


Data Dump: 9-23-2016 Weekly Petroleum Status Report

For the best usability, download the excel file here: eia_petroleum_master_file09-23-2016 and open in your desktop version of Excel 2010 or better.

If you don’t have Excel or are running an older version, you can view the dashboard using the Excel Web App with the embedded copy below. You will likely want to click the icon in the bottom right corner for full screen, then adjust your browser zoom to fit.

Chesapeake Energy Financial Model (5-3-2016)

Download the interactive Chesapeake Financial Model here: CHK_FINANCIAL_Model(5-3-2016) This is recommended for those with Excel 2010+. A quick instructional video on the dashboard section can be found on YouTube HERE.

If you do not have Excel 2010 or newer you can use the Excel Web App with the embedded copy below. You will likely want to click the icon in the bottom right corner for full screen, then adjust your browser zoom to fit.

US Petroleum Flows For The Week Ending 4/15/2016

Petroleum Stocks:

20160415_Petroleum_Stocks

For the week ending Friday 4/15/2016 US Petroleum inventories decreased 0.4 million barrels coming down a bit off of last weeks record high 2.059 billion barrels.

Prices averaged $41.23 for the week, up 12% over last week’s average of $36.72.

Trailing 52 Week Average Inflows/Outflows:

20160415_Trailing52W_FLOWS

We continue to see the gap between inflows slowly shrink as consumption slowly increases and production slowly increases. The current daily gap between inflows and outflows using the trailing 52 week averages is 363 thousand barrels a day. If production continues to decline at about 20 thousand barrels a day (each week) and consumption increases at 20 thousand barrels a day (each week), all else equal we could see convergence by the end of June.

Production:

20160415_Production

Domestic production fell 24 thousand bbls/d vs the prior week continuing a short term trend going back to January and a longer trend that goes back to the middle of last year.

 

Weekly Inflows:

20160415_WEEKLY_INFLOWS

Weekly Inflows totaled 141 Million BBLS vs 147 Million BBLS in the prior week in the “processing gains/other” category. For the year through 15 weeks, Imports are up 61M bbls over 2015. “Renewables”, primarily ethanol, looks to be trending down in what could be a seasonal shift.

Weekly Outflows:

20160415_Weekly_Outflows

Weekly Outflows were up about 1.7 million barrels for the week with a big jump in distillates and propane offsetting declines in gasoline and jet fuel. Although it’s just one week, the increase 423 thousand barrels per day increase in distillate provides a break in a curious downward trend.

20160415_Distillate

On the other hand, the 52 week trend for gasoline continues to head upward, dragging the entire consumption curve with it.

20160415_Gasoline

Summary:

For just the 4th time through 16 weeks of 2016 we see a draw in total petroleum inventories. It will take more than one week to break the oversupply that started at least 18 months ago, but string 4 of these together and I could see a solid enough foundation to push oil back into the $50 ballpark. However, a few more 7 million bbl builds like we saw just last week could send us crashing back through $40. At the end of the day, crude in the low $40’s feel about right for me. Production is declining and consumption is creeping up just like everyone seems to think. If pressed, I would guess the bulls are being a little bit optimistic about Doha and the underlying decline rates, but stay tuned..what do I know 🙂

Excel dashboard used to generate the charts is embedded below using the excel web app. You will probably want to click in the icon in the bottom right to launch full screen, then adjust your browser zoom to fit your screen (Shortcut is CTRL+MouseScroll). Or…download it using this link: EIA_PETROLEUM_MASTER_FILE . Instructional video on YouTube HERE