Template to create a URL for Power Query to make a API Call for Federal Reserve Economic Data (FRED)

[jdellasala]

jdellasala submitted a new Excel article:

Template to create a URL for Power Query to make a API Call for Federal Reserve Economic Data (FRED) - Using the FRED Database API rather than using the Add-In makes life much easier!

There is an Excel Add-in that makes retrieving Economic Data from the Federal Reserve (simply called FRED Data) easy. However, there are inherent problems it presents. You put the CODE of the data series you want in row 1, and optionally add Data Manipulations (such as retrieving the change from a year ago) and frequency (Daily, Weekly, etc.), and the starting date you want in rows 2-4. You then click the Add-in's Get Data button and two columns of data are retrieved - the date and...

Read more about this Excel article...

 

[jdellasala]

jdellasala updated Template to create a URL for Power Query to make a API Call for Federal Reserve Economic Data (FRED) with a new update entry:

Update on top 3 rows of Template

I've been able to create formulas for the top 3 rows in the original post. The field names have also changed. Here's a snapshot:
View attachment 93996
I had to post a snapshot because the formulas require a key which I didn't want to post. Here are the formulas. Be aware that FAKEKEY is a named range for the required API key. In the formulas below it is set to

="api_key=abcdefghijklmnopqrstuvwxyz123456"

The formulas for B1:B3 are as...

Read the rest of this update entry...