Wednesday, January 11, 2012

Recommended: FRED Add-In for Microsoft Excel

I use the Federal Reserve Economic Data (FRED) from the St. Louis Federal Reserve on almost a daily basis and for those of you that also access these data on a regular basis, you might be interested in the free "FRED Add-In for Microsoft Excel" available here.

 According to the St. Louis Fed, 

"This Add-In is free software that will significantly reduce the amount of time spent collecting and organizing macroeconomic data. The FRED add-in provides free access to over 30,000 data series from various sources (e.g., BEA, BLS, Census, and OECD) directly through Microsoft Excel.

Key Features:
  • One-click instant download of economic time series.
  • Browse the most popular data and search the FRED database.
  • Quick and easy data frequency conversion and growth rate calculations.
  • Instantly refresh and update spreadsheets with newly released data.
  • Create graphs with NBER recession shading and an auto update feature."
MP: I just downloaded the FRED Add-In and tried it out, and it works great. It does save time by accessing FRED data directly in Excel, compared to going to the FRED website, downloading datasets in Excel format and then opening those datasets in Excel.  To help get started you can review the 5-minute tutorial video on the Fed's website

7 Comments:

At 1/11/2012 3:11 PM, Blogger Ironman said...

Too cool!

 
At 1/11/2012 3:23 PM, Blogger morganovich said...

absolutely.

great tool.

thanks.

 
At 1/11/2012 8:03 PM, Blogger Itchy said...

My wife is going to hate this. It's bad enough that I nerd out over engineering stuff; now I can be better at pretending to be an economist too.

 
At 1/12/2012 8:15 AM, Blogger sykes.1 said...

Does it work on the Mac version?

 
At 1/12/2012 8:24 AM, Blogger Mark J. Perry said...

Yes, if you go the link provided, you'll seen an option for the Mac (OSX) Beta.

 
At 1/13/2012 2:15 PM, Blogger Common Sense Capitalism said...

Thanks so much for posting this. I follow tons of economic data on Common Sense Capitalism and am looking to expand it further. This will be extremely helpful in my economic analysis.

 
At 1/15/2012 7:39 PM, Blogger Chris said...

This will increase my productivity significantly. Thank you.

 

Post a Comment

<< Home