Author: nostrotrading
-
Gold/Silver Ratio in Google Sheets with Live Futures Data
Want to calculate the Gold/Silver ratio in Google Sheets using live Futures data? 📊✨ In this guide, I’ll show you how to make your ratio calculation more robust and dynamic by pulling real-time price data from the web! 1. Fetch Live Gold and Silver Prices Google Sheets provides the IMPORTXML function, which allows us to…
-
How to Use Google Sheets to Track Gold Price Automatically (IMPORTXML)
If you’re looking to track the gold price in real-time using Google Sheets, you can easily do this by pulling the data from a website using the IMPORTXML function. In this blog post, I’ll show you how to get the price of gold using the continuous future contract from Google Finance, specifically from this URL:…
-
Building a VIX Term Structure in Google Sheets
Volatility indices provide a crucial insight into market expectations of future volatility. The VIX term structure, which includes multiple time horizons of volatility expectations, is particularly useful for traders and investors looking to analyze market sentiment. In this guide, we will walk through how to build a VIX term structure in Google Sheets using the…
-
How to Calculate Year-to-Date (YTD) Performance in Google Sheets
If you’re tracking the performance of stocks or ETFs in Google Sheets, calculating Year-to-Date (YTD) performance can give you a clear picture of how your investments are performing. Instead of manually calculating the change in price, you can use a custom formula that automates this process, using data from Google Finance. In this guide, we’ll…
-
VIX Futures Prices in Google Sheets
How to Scrape VIX Futures Prices and Import Them into Google Sheets In today’s fast-paced world, tracking market data in real-time is essential for making informed investment decisions. The VIX futures index, often referred to as the “fear gauge,” is a crucial indicator of market volatility, and staying updated with its movements can help you…
-
Simplified Analysis of Intraday Returns by Weekday for Gold Futures
The charts below illustrate intraday returns by weekday, presenting the mode, median, and average values. Data covers the period from August 1, 2022, to June 5, 2024. Futures contract: Gold (GC)
-
Overnight Returns of SPY Index
This research examines the overnight returns of the SPY index, focusing on the performance comparison between overnight and intraday returns. Using a dataset spanning from 2000 to 2024, we analyzed the statistical overnight returns and investigated the potential factors contributing to the observed performance. Our findings indicate that SPY demonstrates significantly higher returns during overnight…
-
Friday Gold Rush Analysis
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!