Sort


The sort code appears on row 1 in the second column directly to the right of the Series ID for that particular data series. Please note this option is not available with the Microsoft Excel add-in.

By default, data is downloaded on an ascending basis by date (oldest date first).  However you may choose to presort the data in descending order.
  • Ascending (asc)
  • Descending (desc)
The easiest way to specify a sort order is to first download a series' default data then replace asc in the cell on row 2 with the desired sort code (i.e., desc) then update the data by selecting the following from the Google Sheets menu:

Add-ons>>Federal Reserve Economic Data>>Download All Series

You can also enter the desired sort code directly in the spreadsheet before you download the data.

Update Select Series

Another way to change the sort code is to use the Update Select Series feature.

Add-ons>>Federal Reserve Economic Data>>Update Select Series

When you first open the Update Select Series screen, click the box next to the series you want to update. Clicking the Modify download options button at the bottom will take you to the options screen.  

Update Select Series screen

Choose the desired sort code from the drop down list as shown below.  All series selected will update with the code selected
Sort options screen