Guest User | Sign In

Knowledge Base

Using the US Federal Reserve Economic Data - FRED Database

Overview

With the FRED database enabled on your account it's possible to chart over 800,000 global datasets compiled by the US Federal Reserve Bank of St Louis, such as employment rates, GDP, and government bond yields. (If you have the data enabled, save the sample workbook from the link at the bottom of this article).

With so much data at your fingertips it can be a challenge to find exactly what you need, so the best option is to visit the FRED website first and search the database, or click on the links on their homepage for popular charts (eg DGS10 for US 10 year yields, or UNRATE for US unemployment).




Once you have found the data series required, open the chart on the FRED website and locate the code (usually near the name, or in the page URL). In this example, I searched for the 10 year UK Government yield, which has the code IRLTLT01GBM156N:



Highlight and copy the code, and then in Optuma open the Security Selection window and paste it in the search box:



Once highlighted, double-click to open the chart, and then apply tools and indicators.



Note: because of the size of the database the data is set to download on demand, ie the chart will only update when it is opened. Right-click on the link below and Save Link As (or Save Target As) to save a sample workbook containing FRED charts.

FRED Exchange - Loading

From Optuma 2.0 or later, the FRED exchange (when enabled) will load the index automatically each time Optuma is logged in. This process can slow down the login as it is a very large exchange. If data from the FRED exchange is not accessed for more than 2 weeks, the exchange is not loaded automatically during start up.

The data does remain available, so if a workbook containing FRED codes is opened, or you select the FRED exchange in the data selector the exchange will be loaded, but, it will take 5 + 20 seconds while it is initialised.


Attachments:

Please Wait!

Please wait... it will take a second!