#] #] ********************* #] "$d_webRawe"'economics, markets/Federal Reserve/0_Fed balance sheet data - notes.txt' www.BillHowell.ca 25Mar2021 initial # "$d_bin""gnuplot.sh" runs this gnuplot script Fed Total Assets : https://www.federalreserve.gov/monetarypolicy/bst_recenttrends_accessible.htm Federal Reserve Total Assets (T$) - dates intended as turning point indicators, or recent trend Federal Reserve Liabilities (T$ FRED:WLFN via TradingView platform, approximate timing) liab - mostly currency in circulation? depot - deposits of depository institutions date asset liab depot 01Aug2007 0.87 0.78 05Nov2008 2.07 0.83 17Mar2010 2.31 0.88 14Dec2011 2.90 1.02 18Dec2013 4.00 1.19 23Mar2016 4.49 1.39 29Aug2019 3.76 1.71 26Feb2020 4.16 1.75 10Jun2020 7.17 1.91 16Feb2022 8.91 2.19 23Mar2022 8.96 2.21 11.17 06Jul2022 8.89 2.22 05Oct2022 8.76 2.23 (approx) 05Oct2022 8.759 2.283 12Oct2022 8.758 2.287 19Oct2022 8.743 2.284 26Oct2022 8.723 2.284 02Nov2022 8.676 2.286 09Nov2022 8.678 2.292 10.97 16Nov2022 8.625 2.293 3.177 (8.625 - 2.293 - 3.177) = 3.155 ??? looks like [WRESBAL, WRBWFRBL] ?? date asset liability 24Aug2022 8.85 2.225 31Aug2022 8.82 2.227 07Sep2022 8.82 2.234 14Sep2022 8.83 2.280 21Sep2022 8.81 2.227 28Sep2022 8.79 2.228 05Oct2022 8.75 2.233 12Oct2022 8.758 2.287 19Oct2022 8.743 2.284 26Oct2022 8.723 2.284 02Nov2022 8.676 2.286 09Nov2022 8.678 2.292 geany clean up Federal Reserve table copy-paste search : ^(.*)\n\t\n\n(.*)\n\t\n\n(.*)\n\t\n\n(.*)\n\t\n\n(.*)\n\n replace: \1\t\2\t\3\t\4\t\5\t\n 24************************24 24************************24 # Table of Contents, generated by : # $ grep "^#]" "$d_webRawe"'economics, markets/Federal Reserve/0_Fed balance sheet data - notes.txt' | sed 's/^#\]/ /' ********************* "$d_webRawe"'Software programming & code/PineScript for TradingView market charts/0_PineScript notes.txt' 13Jun2022 Federal Reserve - debt held, liabilities, capital 19Jan2022 update of Fed balance sheet data 25Mar2021 Fed balance sheet - 2008 support for certain specific institutions 25Mar2021 Fed balance sheet - liabilities 25Mar2021 Fed balance sheet - liquidity facilities 25Mar2021 Fed balance sheet [total, securities, liquidity, support specific institutions] 24************************24 08******08 #] ??Nov2022 08******08 #] ??Nov2022 08******08 #] ??Nov2022 08******08 #] ??Nov2022 08******08 #] ??Nov2022 08******08 #] 22Nov2022 FedReserve [WRBWFRBL, WRESBAL, FDHBFRBN] (TV sysmbols) WRBWFRBL FedReserve Liab&CapOther WRESBAL FedReserve Liab&CapOther FDHBFRBN FedDebt in FedReserve 3.177 + 3.128 + 2.243 = 8.548 versus 16Nov2022 8.625 total assets, but I am doubling liabilities?!?! 08******08 #] 06Oct2022 blog on MktWatch Howell - Thanks J Clark. I'm not familiar with the Fed Discount Window - does this refer to a kind of "variable rate" setup for Treasury liabilities with respect to T-bonds? In any case, I just updated my tables relate to the Fed balance sheet : https://www.federalreserve.gov/monetarypolicy/bst_recenttrends_accessible.htm Federal Reserve Total Assets (T$) Federal Reserve Liabilities (T$ FRED:WLFN via TradingView platform, approximate timing) date asset liability 01Aug2007 0.87 0.78 05Nov2008 2.07 0.83 17Mar2010 2.31 0.88 14Dec2011 2.90 1.02 18Dec2013 4.00 1.19 23Mar2016 4.49 1.39 29Aug2019 3.76 1.71 26Feb2020 4.16 1.75 10Jun2020 7.17 1.91 16Feb2022 8.91 2.19 23Mar2022 8.96 2.21 06Jul2022 8.89 2.22 05Oct2022 8.76 2.23 (approx) I don't understand the the exact relationship of the [total assets, liabilities] and [legal, policy, judgmenet] restrictions on their use. In any case, with the [amplitude, speed] of manipulations of the 10 year bond rates and the bond purchases, perhaps THE core measure at the heart of the markets is a socially engineered variable. Is it possible that this [has, may] lead to blinding of the markets, massive mis-allocation of society's resources, direct political manipulation and punishment, and Orwellian truthSpeak (OK - that's overboard but fun)? Does it give justification for the investment community's screaming about the policies and to be protected? 08******08 #] ??Nov2022 Fed - Factors Affecting Reserve Balances - H.4.1 Total Assets of the Federal Reserve In millions of dollars 16-Mar-2022 8,954,306 23-Mar-2022 8,962,474 30-Mar-2022 8,937,142 6-Apr-2022 8,937,592 13-Apr-2022 8,965,487 20-Apr-2022 8,955,851 27-Apr-2022 8,939,199 4-May-2022 8,939,972 11-May-2022 8,942,008 18-May-2022 8,945,898 25-May-2022 8,914,281 1-Jun-2022 8,915,050 8-Jun-2022 8,918,254 15-Jun-2022 8,932,420 (I didn't use FRED: FDHBFRBN Federal Debt held by Fed here) (multiply by factor of 20 for market impact?) 08******08 #] 13Jun2022 Federal Reserve - debt held, liabilities, capital FRED: WLFN - Federal Reserve: Liabilities and Capital, Fed notes net of Fed holdings, Wednesday level FRED: FDHBFRBN Federal Debt helby Federal Reserve Banks geany clean up Federal Reserve table copy-paste search : ^(.*)\n\t\n\n(.*)\n\t\n\n(.*)\n\t\n\n(.*)\n\t\n\n(.*)\n\n replace: \1\t\2\t\3\t\4\t\5\t\n https://www.federalreserve.gov/releases/h41/current/h41.htm FEDERAL RESERVE statistical release H.4.1 Factors Affecting Reserve Balances of Depository Institutions and Condition Statement of Federal Reserve Banks June 9, 2022 https://www.federalreserve.gov/releases/h41/current/h41.htm 1. Factors Affecting Reserve Balances of Depository Institutions (Millions of dollars) credit, depInst bal (1) | Averages of daily figures | Wednesday | Week ended | Change from week ended | Jun 8, 2022 | | Jun 1, 2022 | Jun 9, 2021 | Reserve Bank credit | 8,880,563 | + 1,522 | + 975,178 | 8,882,034 Securities held outright1 | 8,480,960 | + 775 | +1,109,794 | 8,481,186 U.S. Treasury securities | 5,771,167 | + 776 | + 646,618 | 5,771,393 Bills2 | 326,044 | 0 | 0 | 326,044 Notes and bonds, nominal2 | 4,973,358 | - 1,504 | + 570,905 | 4,973,358 Notes and bonds, inflation-indexed2 | 382,966 | + 1,503 | + 38,623 | 382,966 Inflation compensation3 | 88,798 | + 776 | + 37,088 | 89,024 Federal agency debt securities2 | 2,347 | 0 | 0 | 2,347 Mortgage-backed securities4 | 2,707,446 | 0 | + 463,176 | 2,707,446 (1) Reserve Bank credit, related items, and reserve balances of depository institutions at Federal Reserve Banks TradingView blog to @quantguy What's going on? Fed still buying, not selling T-bonds, or am I reading the table portion below wrong? Also, TradingView "FRED: FDHBFRBN Federal Debt held by Fed" didn't decline, but data might have a lag. (to read : copy-paste to text editor with constant width font like courier or something) : What's going on? Fed still buying (tiny amounts), not selling T-bonds, or am I reading the table portion below wrong? Also, TradingView "FRED: FDHBFRBN Federal Debt held by Fed" didn't decline, but data might have a lag. If markets are choking now, what will a 50 G$ Fed balance sheet do given how reluctant markets were to consider the interest rate thing? https://www.federalreserve.gov/releases/h41/current/h41.htm 1. Factors Affecting Reserve Balances of Depository Institutions (Millions of dollars) credit, depInst bal (1) | Averages of daily figures | Wednesday | Week ended | Change from week ended | Jun 8, 2022 | | Jun 1, 2022 | Jun 9, 2021 | Reserve Bank credit | 8,880,563 | + 1,522 | + 975,178 | 8,882,034 Securities held outright1 | 8,480,960 | + 775 | +1,109,794 | 8,481,186 U.S. Treasury securities | 5,771,167 | + 776 | + 646,618 | 5,771,393 Bills2 | 326,044 | 0 | 0 | 326,044 Notes and bonds, nominal2 | 4,973,358 | - 1,504 | + 570,905 | 4,973,358 Notes and bonds, inflation-indexed2 | 382,966 | + 1,503 | + 38,623 | 382,966 Inflation compensation3 | 88,798 | + 776 | + 37,088 | 89,024 Federal agency debt securities2 | 2,347 | 0 | 0 | 2,347 Mortgage-backed securities4 | 2,707,446 | 0 | + 463,176 | 2,707,446 (1) Reserve Bank credit, related items, and reserve balances of depository institutions at Federal Reserve Banks 08********08 #] 19Jan2022 update of Fed balance sheet data https://www.federalreserve.gov/monetarypolicy/bst_recenttrends_accessible.htm Menu list on left hand side -> Recent balance sheet trends -> choose one of 5 charts -> Total Assets of ter Federal Reserve -> leads to : Factors Affecting Reserve Balances - H.4.1 Balance Sheet Trends - Accessible Total Assets of the Federal Reserve In millions of dollars >> YIKES!! this gives a SERIES of TABLES!?!? >> First table simply gives [date, total assets] which is all I need! >> remove extras text [above, below] table >> save results to : "$d_webRawe"'economics, markets/Federal Reserve/1_Fed balance sheet, multiple tables.dat' >> NOTE: the URL is still : https://www.federalreserve.gov/monetarypolicy/bst_recenttrends_accessible.htm >> copy-past first data table to spreadsheet : "$d_webRawe"'economics, markets/Federal Reserve/1_Fed balance sheet data.ods' >> ignore extra columns - only need [data, total assets] >> only need to add new dates (but check consistency of old) copy formula for [yearfrac, G$] copy [yearFrac, ttoal assets (G$)] to : "$d_webRawe"'economics, markets/Federal Reserve/1_Fed balance sheet [date, total assets].dat' select all, search '\t' replace ', ' 08********08 #] 25Mar2021 Fed balance sheet - 2008 support for certain specific institutions 210325 Fed balance sheet - 2008 support for certain specific institutions, repaid full by 2012.txt "$d_PROJECTS""Investments/References/Federal Reserve/210325 Fed balance sheet - 2008 support for certain specific institutions, repaid full by 2012.txt" https://www.federalreserve.gov/monetarypolicy/bst_recenttrends_accessible.htm The Federal Reserve provided support for certain specific institutions over the course of 2008. Since 2012, all outstanding amount of support has been repaid in full. Selected Liabilities of the Federal Reserve In millions of dollars spreadsheet /media/bill/Dell2/Website - raw/economics, markets/Federal Reserve/1_Fed balance sheet data.ods /media/bill/Dell2/Website - raw/economics, markets/Federal Reserve/1_Fed balance sheet.dat $ gnuplot '/media/bill/Dell2/Website - raw/economics, markets/Federal Reserve/Federal Reserve balance sheet gnuplot.plt' +-----+ #] 25Mar2021 Fed balance sheet - liabilities 210325 Fed balance sheet - liabilities.txt On the liabilities side of the Federal Reserve's balance sheet, the amount of currency outstanding has continued to rise gradually, but reserve balances (deposits of depository institutions) have increased dramatically relative to prior to the financial crisis. +-----+ #] 25Mar2021 Fed balance sheet - liquidity facilities 210325 Fed balance sheet - liquidity facilities.txt Among the liquidity facilities, the Term Auction Facility, the Commercial Paper Funding Facility, and the central bank liquidity swap lines had provided the most reserve balances. Most of the liquidity facilities wound down significantly over the course of 2009. Support for Specific Institutions In millions of dollars +-----+ #] 25Mar2021 Fed balance sheet [total, securities, liquidity, support specific institutions] 210325 Fed balance sheet [total, securities, liquidity, support specific institutions].txt The size and composition of assets held by the Federal Reserve has evolved noticeably over the past decade. At the onset of the financial crisis, the level of securities held outright declined as the Federal Reserve sold Treasury securities to accommodate the increase in credit extended through liquidity facilities. Though the various liquidity facilities wound down significantly over the course of 2009, the level of securities held outright expanded significantly between 2009 and late 2014 as the FOMC conducted a series of large-scale asset purchase programs to support the U.S. economy. Then, securities held outright declined as a result of the FOMC's balance sheet normalization program that took place between October 2017 and August 2019. Credit Extended through Federal Reserve Liquidity Facilities In millions of dollars # enddoc