PowerShell script to calculate Net Liquidity.
Net Liquidity = Federal Reserve Balance sheet - Treasury General Account - Reverse Repo
When you run this script, the change table will appear on the console:
The SPX FV column is the SPX Fair Value.
Green indicates an increase in Net Liquidity.
Red indicates a decrease in Net Liquidity.
A chart for Net Liquidity will open in a browser:
A chart for SPX, SPX fair value, and the SPX fair value bands will open in a browser:
The script has been tested on Windows and Ubuntu.
Let me know if you test it on macOS.
- WALCL is updated Thursday at 4:30 PM Eastern.
- Reverse Repo is updated daily at 1:15 PM Eastern.
- TGA is updated daily at 4:00 PM Eastern. Value is for the previous day.
So it's usually best to run the script once a day after 4:00 PM Eastern.
TGA is reported for the previous day. So in general, only the previous day's Net Liquidity will be fully known. The script will still display the current day's preliminary Net Liquidity value which will include RRP and WALCL if updates for them are available.
Go to this page:
https://github.com/dharmatech/net-liquidity.ps1/blob/master/net-liquidity-walcl.ps1
Right-click Raw and select Save link as...:
If you're on Windows, you may have to unblock the file from a PowerShell console:
Unblock-File .\net-liquidity-walcl.ps1
Run the file at a PowerShell prompt:
.\net-liquidity-walcl.ps1