FRED¶

FRED is one of the richest source of economic data containing 816,000 US and international time series from 107 sources. All the categories of data that can be obtained from FRED can be found here

Note

Refer to FRED Jupyter Notebook for more details.

Table of Content¶

Usage
Historical Price for 1 Stock
Many Stocks
Currencies
Cryptocurrencies
Mutual Funds
Treasury Rates
Sentiment

Usage¶

Below are examples of how to get and plot data from datasets found in the Federal Reserve Economic Data database found here.

To obtain the code needed for the API call, search the database, then locate the unique ID code next to the title. From there, the process follows the examples below.

Import all necessary libraries:

import pandas_datareader as web
import pandas as pd
from matplotlib import pyplot as plt
import seaborn as sns
from datetime import datetime

Historical Price for 1 Stock¶

Gets the S&P price data from the start to the end dates specified, and plots them.

# Specify time periods
start = datetime(2010,1,1)
end = datetime(2020,1,1)

# create your DataReader object for the S&P
SP500 = web.DataReader('SP500','fred',start,end)

sns.set() #run this to overide matplotlib
SP500['SP500'].plot(title='S&P 500 Price',figsize=(20, 6))

# Use the below to save the chart as an image file
plt.savefig('s&p500.png')

Many Stocks¶

Plots multiple market cap indices against each other.

mkt_cap = web.DataReader(['WILLLRGCAPGR', 'WILLSMLCAP'], 'fred',start,end)
mkt_cap.plot(title = 'Wilshire Large-Cap compared to Small-Cap', secondary_y = "DGS10", figsize=(20, 6))
plt.tight_layout()

Currencies¶

Plots the exchange rate between the Yuan and the Dollar.

er = web.DataReader('AEXCHUS', 'fred',start,end)
er.plot(title = 'Chinese Yuan Renminbi to U.S. Dollar Spot Exchange Rate', secondary_y = "DGS10", figsize=(20, 6))
plt.tight_layout()

Cryptocurrencies¶

Plots the price of bitcoin.

btc = web.DataReader('CBBTCUSD', 'fred',start,end)
btc.plot(title = 'Bitcoin Price', secondary_y = "DGS10", figsize=(20, 6))
plt.tight_layout()

Mutual Funds¶

Plots the mutual fund assets.

mf = web.DataReader('BOGZ1LM193064005Q', 'fred',start,end)
mf.plot(title = 'Households; Corporate Equities and Mutual Fund Shares; Asset, Market Value Levels', secondary_y = "DGS10", figsize=(20, 6))
plt.tight_layout()

Treasury Rates¶

Plots the treasury rate.

treasury = web.DataReader('TB3MS', 'fred',start,end)
treasury.plot(title = '3-Month Treasury Bill Secondary Market Rate', secondary_y = "DGS10", figsize=(20, 6))
plt.tight_layout()

Sentiment¶

Plots the U Michigan consumer sentiment.

sentiment = web.DataReader('UMCSENT', 'fred',start,end)
sentiment.plot(title = 'U Michigan Consumer Sentiment', secondary_y = "DGS10", figsize=(20, 6))
plt.tight_layout()