Learning Goal: I’m working on a excel spreadsheet and need guidance to help me learn.
The Fed (a.k.a. the monetary authority) has two primary tools: the interest rate on reserves and purchases of securities. Using data from Fred, chart both since 2008.
F or the purchases, use “Assets: Securities Held Outright”. For rates, use “Interest Rate on Required Reserves” up to 2021 and then “Interest Rate on Reserve Balances” after that.
Finally, note that interest rates are in percent and purchases are in dollars, so you will need assign them to different axes.
