macro_indicators_toolkit.py

from fredapi import Fred
fred = Fred(api_key='YOUR API')

def treasury_ten_year():
    """
    Returns: 10-Year Treasury Constant Maturity Rate; Unit: percent per annum
    """
    treasury_lt = fred.get_series('DGS10')
    return treasury_lt

def treasury_one_year():
    """
    Returns: 1-Year Treasury Constant Maturity Rate; Unit: percent per annum
    """
    treasury_st = fred.get_series('DGS1')
    return treasury_st

def treasury_three_month():
    """
    Returns: 3-Month Treasury Constant Maturity Rate; Unit: percent per annum
    """
    treasury_stm = fred.get_series('DGS3MO')
    return treasury_stm

def unemployment_rate_us():
    """
    Return: Unemployment Rate
    """
    unempl = fred.get_series('UNRATE')
    return unempl

def unemployment_rate_by_state(start_date = '2020-01-01'):
    """
    Input: start date of the observations
    Returns: Unemployment Rate by State
    """
    states = ["AL", "AK", "AZ", "AR", "CA", "CO", "CT", "DC", "DE", "FL", "GA", "HI", "ID", "IL", "IN", "IA", "KS", "KY", "LA", "ME", "MD", "MA", "MI", "MN", "MS", "MO", "MT", "NE", "NV", "NH", "NJ", "NM", "NY", "NC", "ND", "OH", "OK", "OR", "PA", "RI", "SC", "SD", "TN", "TX", "UT", "VT", "VA", "WA", "WV", "WI", "WY"]
    by_state = []
    for st in states:
        data = fred.get_series(f'{st}UR', observation_start=start_date)
        by_state.append(data)
    df_ur = pd.concat(by_state, axis=1)
    df_ur.columns = states
    return df_ur

def sp_500():
    """
    Returns: S&P 500 for last 10 years, Index
    """
    sp = fred.get_series('SP500')
    return sp

def gdp_us():
    """
    Returns: Real US GDP, Billions of Dollars
    """
    gdp = fred.get_series('GDPC1')
    gdp.dropna(inplace=True)
    return gdp

def inflation_breakeven_10yrs():
    """
    Returns: 10-Year Breakeven Inflation Rate
    Note: forward looking rate (10 years)
    """
    infl = fred.get_series('T10YIE')
    return infl

def inflation_breakeven_5yrs():
    """
    Returns: 5-Year Breakeven Inflation Rate
    Note: forward looking rate (5 years)
    """
    infl = fred.get_series('T5YIE')
    return infl

def consumption():
    """
    Returns: Real Personal Consumption Expenditures, Billions of Dollars
    """
    consmp = fred.get_series('PCEC96')
    consmp.dropna(inplace=True)
    return consmp

def consumer_price_index():
    """
    Returns: Consumer Price Index for All Urban Consumers: All Items in U.S. City Average
    """
    cpi = fred.get_series('CPIAUCSL')
    cpi.dropna(inplace=True)
    return cpi

def recession_nber():
    """
    Returns: NBER based Recession Indicators for the United States from the Period following the Peak through the Trough
    """
    nber = fred.get_series('USREC')
    nber.dropna(inplace=True)
    return nber

def plot_spread_recession():
    """
    Returns: plot of Term Spread (10-year minus 3-month) and NBER recessions from 1981
    """
    ten = treasury_ten_year()
    ten = ten['1981-09-01':]
    thr = treasury_three_month()
    thr = thr['1981-09-01':]
    spr = ten - thr
    rec = recession_nber()
    ax = spr.plot(figsize=(12,6))
    (rec['1981':]*5).plot(ax=ax, style="--", linewidth=3)

def tenyear_cm_minus_fedfunds():
    """
    10-Year Treasury Constant Maturity Minus Federal Funds Rate, Monthly
    """
    ttenyffm = fred.get_series('T10YFFM')
    ttenyffm.dropna(inplace=True)
    return ttenyffm

def three_month_tbill_minus_fedfunds():
    """
    3-Month Treasury Bill Minus Federal Funds Rate, Monthly
    """
    tbthreemffm = fred.get_series('TB3SMFFM')
    tbthreemffm.dropna(inplace=True)
    return tbthreemffm

def all_employee():
    """
    All Employees, Total Nonfarm
    """
    nonfpayems = fred.get_series('PAYEMS')
    nonfpayems.dropna(inplace=True)
    return nonfpayems

def job_open():
    """
    Job Openings: Total Nonfarm, Monthly
    """
    jobopen = fred.get_series('JTSJOL')
    jobopen.dropna(inplace=True)
    return jobopen

def five_year_cm_minus_fedfund():
    """
    5-Year Treasury Constant Maturity Minus Federal Funds Rate, Monthly
    """
    fiveyffm = fred.get_series('T5YFFM')
    fiveyffm.dropna(inplace=True)
    return fiveyffm

def one_year_cm_minus_fedfund():
    """
    1-Year Treasury Constant Maturity Minus Federal Funds Rate, Monthly
    """
    oneyffm = fred.get_series('T1YFFM')
    oneyffm.dropna(inplace=True)
    return oneyffm

def us_uk_fx():
    """
    U.S. / U.K. Foreign Exchange Rate, U.S. Dollars to One British Pound, Monthly
    """
    usukexch = fred.get_series('EXUSUK')
    usukexch.dropna(inplace=True)
    return usukexch

def housing_stats_west_census():
    """
    Housing Starts in West Census Region, Thousands of Units, Monthly
    """
    house = fred.get_series('HOUSTW')
    house.dropna(inplace=True)
    return house

def three_month_trs_secondary():
    """
    3-Month Treasury Bill: Secondary Market Rate, Monthly
    """
    threems = fred.get_series('TB3MS')
    threems.dropna(inplace=True)
    return threems

def employee_constr():
    """
    All Employees, Construction, Monthly
    """
    usconstr = fred.get_series('USCONS')
    usconstr.dropna(inplace=True)
    return usconstr

def overtime_manuf():
    """
    Average Weekly Overtime Hours of Production and Nonsupervisory Employees, Manufacturing, Monthly
    """
    overtime = fred.get_series('AWOTMAN')
    overtime.dropna(inplace=True)
    return overtime

def housing_owened():
    """
    Housing Starts: Total: New Privately Owned Housing Units Started, Monthly
    """
    housest = fred.get_series('HOUST')
    housest.dropna(inplace=True)
    return housest

def employee_durable():
    """
    All Employees, Durable Goods, Monthly
    """
    durgood = fred.get_series('DMANEMP')
    durgood.dropna(inplace=True)
    return durgood

def employee_service():
    """
    All Employees, Service-Providing, Monthly
    """
    survp = fred.get_series('SRVPRD')
    survp.dropna(inplace=True)
    return survp

def initial_claims():
    """
    Initial Claims, Monthly
    """
    claim = fred.get_series('ICSA')
    claim.dropna(inplace=True)
    return claim