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

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

Click to expand...

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

Excel Formula:

="api_key=abcdefghijklmnopqrstuvwxyz123456"

The formulas for B1:B3 are as...

Click to expand...