Skip to content

Instantly share code, notes, and snippets.

@dharmatech
Last active May 4, 2023 04:32
Show Gist options
  • Select an option

  • Save dharmatech/061224a3119d9f78479d3393e60d3ac2 to your computer and use it in GitHub Desktop.

Select an option

Save dharmatech/061224a3119d9f78479d3393e60d3ac2 to your computer and use it in GitHub Desktop.

WALCL

Many folks are familiar with the Fed Balance Sheet 'Total Assets' chart:

image

https://fred.stlouisfed.org/series/WALCL

H.4.1 Release Table

Towards the bottom of that page is a link to the following 'release table':

image

https://fred.stlouisfed.org/release/tables?rid=20&eid=1194154#snid=1194156

This is a great page. It shows each component of the balance sheet, the current value, and a link to the chart.

Formulas

The basic equation of balance sheets which you'll find in economics and finance textbooks is:

assets = liabilities + capital        (1)

So for the Fed balance sheet we have:

WALCL = WLTLECL + WCTCL               (2)

The popular Net Liquidity formula is:

NL = WALCL - RRP - TGA                (3)

This is saying:

NL = assets - RRP - TGA

So, if we substitute (2) into (3) we get:

NL = WLTLECL + WCTCL - RRP - TGA

In other words:

NL = liabilities + capital - RRP - TGA

Visualization

Let's visualize this.

Here's a chart of the balance sheet components. Assets are above zero. Liabilities and Capital are below zero.

image

So the Net Liquidity formula, geometrically interpreted is

the top half of the chart - RRP - TGA

But that's awkward to imagine. So we can rewrite that as:

the bottom half of the chart - RRP - TGA

OK, so let's only display the bottom half by turning off the assets:

image

Now, let's subtract RRP and TGA by turning those off:

image

Let's also turn off the low amount items:

image

If you really want to push it, we can also turn off WLFN which isn't extremely volatile, though it has increased a lot over time.

image

WLODL is a relatively small amount, so let's remove that.

image

So we're left with just WLODLL : Other deposits held by depository institutions.

So in theory, that should correlate closely to the original Net Liquidity formula.

Let's compare them in TradingView.

image

While some fidelity is lost in the WLODLL chart, they are pretty close.

Summary

If things shift between RRP and TGA, nothing happens to Net Liquidity.

It's when things shift into or out of WLODLL that the fireworks happens.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment