Skip to content

Instantly share code, notes, and snippets.

@neofob
Last active December 2, 2025 02:41
Show Gist options
  • Select an option

  • Save neofob/dbeb96fe42db8d3a0234afe16afb8609 to your computer and use it in GitHub Desktop.

Select an option

Save neofob/dbeb96fe42db8d3a0234afe16afb8609 to your computer and use it in GitHub Desktop.
Macro Economics Snapshot Query

Stat query

Get the current stats.

* Gold price
* Oil price
* FED rate
* Inflation rate
* Unemployment rate
* S&P 500
* Down 30
* NASDAQ
* Russell 2000
* VIX
  
U.S. Treasury bond yields for these maturities: 3 month,  6 month, 9 month, 1 year, 2 year, 3 year, 5 year, 10 year, 20 year, 30 year.

Output them in table format.

Test query

As of October 16, 2025, these are the snapshot of economic stats. What is your assessment of the situation? How would this effect the gold price and long term bonds? The U.S. Government shutdown still persists.

  • Gold price: 4309 usd per ounce
  • Oil: 57.59 USD
  • 3 month treasury rate: 3.94%
  • 6 month treasure rate: 3.79%
  • 1 year bond: 3.60%
  • 2 year bond: 3.43%
  • 3 year bond: 3.43%
  • 5 year bond: 3.56%
  • 10 year bond: 3.97%
  • 20 year bond: 4.60%
  • 30 year bond: 4.58%
  • FED rate: 4.0-4.25%
  • Inflation rate: 2.9%
  • NASDAQ: 22454
  • S&P 500: 6604
  • Down 30: 45843
  • Russell 2000: 2469
  • VIX: 24.12
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment