spreadsheet test

CL104

CY303

D6100

DX100

E6100

E7200

ES101

ET302

GC103

GR302

HG100

J6105

J7205

NM302

NQ101

QC201

QI202

QL303

QM204

QO101

QU105

RB101

S6100

SI101

SO302

YM101

YR304

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Letter-of-direction Schaer

Federal debt in 2008 8.95 trillion, 2023 33.48 trillion +274.07%
Federal revenue in 2008 2.567 trillion 2023 4.359 trillion +69.80%
US debt is now rated below Taiwan, Finland & Hong Kong
Over the next 12 months the U.S. has 4+ Trillion in debt maturing and 2.5+ trillion in new debt for a total 6.5 trillion to finance.
1981 annual revenue as a percent of total Federal debt 60.24%
1970-2007 Avg Treasury rate 8.70%, CPI 4,71% rate above inflation +3.99% rating AAA
2023 annual revenue as a percent total Federal debt  12.94%
2023 Avg Treasury Rate 4.69%, Avg CPI 6.30%, rate paid below inflation -1.61% AA+ Negative
If rates normalized to the 37 year pre-QE average 8.70%, 67.21% of total Federal revenue will be consumed by debt service cost alone.
In 2023 there is 4 times the money in circulation (M1) as 2020, 13 times 2008
3 major bank failures SVB, Signature, 1st Republic, 200 potential bank insolvencies on deck
The Federal Reserves resources are exhausted they’re still holding 8+ trillion in in debt they bought with created money during the last 2 crises, if they create more Federal debt will be downgraded again to AA, potentially AA- eliminating buyers who are not aloud to by AA.
All money has been borrowed out of all Agency and Trust accounts
Non U.S. Investors have gone from buyers to sellers of Treasuries, there are no other buyers.
Previous Reports on inflation
Inflation perception versus reality
The demise of the dollar and monetization of Federal debt
What Magical Monetary Fairy is going to replace the Fed?

 

Non U.S, Net Gain or Loss

Unrealized Gain or Loss

 

 

Fed Funds Versus Tresuries

 

 

Balance-of-trade-230711

 

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

 Australia AAA S  Austria AA+ S  U.K AA S
 Canada AAA S  Finland AA+ S  Estonia AA- S
 Denmark AAA S  Hong Kong AA+ S  Czech Rep. AA- S
 Germany AAA S  New Zealand AA+ S  Guernsey AA- S
 Liechtenstein AAA S  Taiwan AA+ S  Israel AA- S
 Luxembourg AAA S  United States AA+ N  Jersey AA- S
 Netherlands AAA S  Abu Dhabi, AA S  Qatar AA- S
 Norway AAA S  Belgium AA S  Slovenia AA- S
 Singapore AAA S  E.U. AA S  Ireland AA S
 Sweden AAA S  France AA S  Kuwait AA- N
 Switzerland AAA S  South Korea AA S  Saudi Arabia A+ P

zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

Gold Range Spreadsheet & Chart 1980-2023

CL104

CY303

D6100

DX100

E6100

E7200

ES101

ET302

GC103

GR302

HG100

J6105

J7205

NM302

NQ101

QC201

QI202

QL303

QM204

QO101

QU105

RB101

S6100

SI101

SO302

YM101

YR304

 

cccccccccccccccccccccccccccccccccc

ccccccccccccccccccccccccccccccccccccccc

ccccccccccccccccccccccccccccccccccccccc

xx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

 

!EXDAYPO

 

 

 

S&P 60 221231 Micro

S&P 60 221231

S&P 180 221231 Micro

S&P 180 221231

S&P 300 221231 Micro

S&P 300 221231

NASDAQ 60 221230 Micro

NASDAQ 60 221230

NASDAQ 180 221230 Micro

NASDAQ 180 221230

NASDAQ 300 221230 Micro

NASDAQ 300 221230

Gold 60 221231 Micro

Gold 60 221231 Mini

Gold 60 221231

Gold 180 221231 Micro

Gold 180 221231 Mini

Gold 180 221231

Gold 300 221231 Micro

Gold 300 221231 Mini

Gold 300 221231

Silver 60 221231 Micro

Silver 60 221231 Mini

Silver 60 221231

Silver 180 221231 Micro

Silver 180 221231 Mini

Silver 180 221231

Silver 300 221231 Micro

Silver 300 221231 Mini

Silver 180 221231

HG 60 221231 Micro

HG 60 221231 Mini

HG 60 221231

HG 180 221231 Micro

HG 180 221231 Mini

HG 180 221231.1

HG 300 221231 Micro

HG 300 221231 Mini

HG 300 221231

AUD 60 221231

AUD 180 221231

AUD 300 221231

CAD 60 221231

CAD 180 221231

CAD 300 221231

CHF 60 221231

CHF 180 221231

CHF 300 221231 micro

CHF 300 221231

EUR 60 221231 Mini

EUR 60 221231

EUR 180 221231 Mini

EUR 180 221231

EUR 300 221231 Mini

EUR 300 221231

GBP 60 221231

GBP 180 221231

GBP 300 221231

J6 60 221231

J6 180 221231 Mini

J6 300 221231

J7 60 221231 Mini

J7 180 221231 Mini

J7 300 221231 Mini

DX 60 221231

DX 180 221231

DX 300 221231

Crude 60 221231 Micro

Crude 60 221231 Mini

Crude 60 221231

Crude 180 221231 Micro

Crude 180 221231 Mini

Crude 180 221231

Crude 300 221231 Micro

Crude 300 221231 Mini

Crude 300 221231

 

 

 

 

 

 

 

 

 

 

 

SP-60-221031 Using end of period no filters 1

SP-60-221031 Using end of period no filters 2

SP-60-221031 Using end of period no filters 3

 

 

Inflation 1980 Fixed & Reported

 

 

 

1 & 5 H ET, GR, QL, E7, J7, CY

1H ET, GR, QL, E7, J7, CY

 

1 & 5 H Micro Indices, Metals, Energy

1 & 3 H Micro Indices, Metals, Energy

5 H Micro Indices, Metals, Energy

3 H Micro Indices, Metals, Energy

1 H Micro Indices, Metals, Energy

1,3 & 5 H Micro Indices, Metals, Energy, Mini FX

1 & 5 H Micro Indices, Metals, Energy, Mini FX

1 & 3 H Micro Indices, Metals, Energy, Mini FX

5 H Micros Indices, Metals, Energy, Mini FX

5 H Full size Metals, Currencies, Energy, Mini Indices

3 H Full size Metals, Currencies, Energy, Mini Indices

1 H Full size Metals, Currencies, Energy, Mini Indices

1 & 3 Hour Full Size Currencies, Mini Indices

1 & 5 Hour Full Size Currencies, Mini Indices

1 & 5 H Full Size  Metals, Energy, Mini Indices

1 & 3 H Full Size  Metals, Energy, Mini Indices

1 & 5 H Full Size  Metals, Energy, Mini Indices

1 & 3 H Full Size  Metals, Energy, Mini Indices

1 & 3 H Full Size Metals, Currencies, Energy

1 & 5 H Full Size Metals, Currencies, Energy

1 & 5 H Full Size Metals, Currencies, Energy

1 & 3 H Full Size Metals, Currencies, Energy

5 H Full Size  Metals, Currencies, , Energy

1 H Full Size  Metals, Currencies, , Energy

3 H Full Size  Metals, Currencies, Energy

3 H Full Size  Metals, Currencies, Energy

1 H Full Size  Metals, Currencies,  Energy

1 & 3 H Full Size Metals Currencies Energy

1-H Full Size Metals, Currencies, Energy

5 Hour Full Size Currencies, Mini Indices

3 Hour Full Size Currencies, Mini Indices

1 Hour Full Size Currencies, Mini Indices

3 H Full Size Metals, Currencies, Energy

1-H Full Size Metals, Currencies, Energy

1 H Full Size  Metals, Currencies, , Energy

3 H Full Size  Metals, Currencies, , Energy

5 H Full Size  Metals, Currencies, , Energy

1 H Full Size  Metals, Energy, Mini Indices

3 H Full Size  Metals, Energy, Mini Indices

5 H Full Size  Metals, Energy, Mini Indices

 

 

 

Published by

Asset Investment Management

Family Office, Advisors