Frequency


The frequency code appears on row 3 directly under the manipulation code and two cells under the series id in column 1 for that particular data series.

By default, frequency data is downloaded "as reported" by the source.

However, you can aggregate the data as reported in several predefined ways:
  • D = daily
  • W = weekly
  • BW = biweekly
  • M = monthly
  • Q = quarterly
  • S = semi-annual
  • A = annual
Note:  You cannot disaggregate data (i.e., you cannot disaggregate monthly data at a daily frequency.

The easiest way to apply frequency aggregation is to first download a series' default data (as reported) then replace the frequency code in the cell on row 3 with the desired frequency, then update the data by selecting the following from the Google Sheets menu:

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

Note:  Data will be aggregated on an average basis unless a different frequency aggregation method is selected.

Update Select Series

Another way to change the frequency aggregation 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 frequency from the drop down list as shown below.  All series selected will update with the option selected.

Update Frequency screen