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

For the best usability, download the excel file here: EIA_Petroleum_Master_File10-21-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.


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

For the best usability, download the excel file here: EIA_Petroleum_Master_File (10-14-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.


Data Download: Social Security Analysis September-2016

Every month, the Social Security Administration releases their monthly beneficiary data. Basically it tells us how many people are collecting from Social Security, and how much they are getting. Any one month of data is fairly useless, but we can dump the data going back to 1967 into a pivot chart and get something interesting like this:

social-security-september-2016

This charts the annual change in beneficiaries from 2005 to 2016. Notice anything at the end of 2008? That is the doubling of the annual enrollment rate as people opted to retire when they couldn’t find jobs in the great recession. It has come down a bit since then, but boomer retirement is keeping it high. I’m not convinced this chart will give us any warning of the next recession, but you never know, and in any case it should lend some confirmation even if it is lagging a bit.

The other reason I follow this is that Social Security is that I have been following the US deficit at my other site USDailyDeficit.com for about 4 years now, and not surprisingly Social Security is a huge % of that problem…but I digress.

To follow along, download the file here: Social_Security_Report

As stated above, there is data going back to 1967 for the retirement program, the disability program, and the survivors program, as well as the total program. There are 9 series for each including absolute changes, % changes, and YOY changes. Enjoy!!

My thoughts are…this data is as good as it has looked since 2008. That’s not exactly great, by the yearly adds are trending down with retirement more or less flat being offset by reductions in disability and survivors.

Data Download: EIA Monthly Natural Gas Data Through July 2016

Just wanted to roll this new/updated file. We spend a lot of time each week looking at weekly data, but just for fun, take a step back and check out some of the EIA’s Monthly data. Supposedly, the monthly data is of better quality, but is generally a few months behind, making it not so useful for day trading, but still an interesting historical record.

The file has 103 series with data going back to the 70’s for a few of them. In all you have over 50,000 chartable data points including production by state in BCF, BCF/D, and Trailing 12 month BCF/Y. Also interesting is consumption by use, storage, prices, and of course my favorite, a reconciliation!! The great thing about dumping all of these series into a single pivot chart is that you can chart whatever you want, over whatever time period you want, compared to whatever other series you feel like. It is literally thousands of charts in one. That way you can pretty much ignore whatever I think is important and do your own unique research.

For the best usability, download the excel file here: EIA_Natural_Gas_Master_File. and open in your desktop version of Excel 2010 or better. I’m not going to post the excel web app version today…it’s a lot of extra steps that I’m not sure anyone actually uses. If you do…ping me and let me know so I can get a count of how many people prefer the Excel web app. Instead, here is a screenshot of just one of thousands (technically…it’s a lot more than that, but you get the idea) of possible charts you can create. Enjoy!!

eia_gas-july-2016

 

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!!