U.S. Energy Information Administration (EIA and FRED) Excel Data Add-In’s

The EIA has released an Excel add-in that will let you pull data from the U.S. Energy Information Administration (EIA) and St. Louis Federal Reserve’s Economic Data (FRED) that are publicly available and typically in weekly or monthly increments directly into your Excel workbook. It expands on the functionality from the Federal Reserve Excel add-in called FRED.

You can pull things like 30 year fixed mortgage rates, Case Shiller Housing, WTI Oil Prices, GDP Deflator, M1/M2 Money Supply and dozens of other metrics. The 30 year fixed mortgage data goes back 30 years.

Excel view of the plugin

EIA_Snippit1

 

WTI Crude Example

DCOILWTICO
lin Dollars per Barrel
D Daily
1900-01-01 1986-01-02 to 2015-03-16
Crude Oil Prices: West Texas Intermediate (WTI) – Cushing, Oklahoma
US. Energy Information Administration
date value
2015-03-16 43.93
2015-03-13 44.88
2015-03-12 47.12

30 Year Morgage Rates Example

MORTGAGE30US
lin Percent
W Weekly, Ending Thursday
1900-01-01 1971-04-02 to 2015-03-19
Freddie Mac
date value
2015-03-19 3.78
2015-03-12 3.86

You can read more or download the Excel Add-in from the EIA website below

http://www.eia.gov/beta/api/excel/

Federal Reserve (FRED) Excel Add-in

http://research.stlouisfed.org/fred-addin/?utm_source=research&utm_medium=website&utm_campaign=data-tools