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 extract live price data from Google Finance. Use the following formulas to retrieve the latest Gold and Silver Futures prices:
Gold Price (COMEX Gold Futures)
=IMPORTXML("https://www.google.com/finance/quote/GCW00:COMEX?hl=en", "//div[contains(@class,'YMlKec fxKbKc')]")
Silver Price (COMEX Silver Futures)
=IMPORTXML("https://www.google.com/finance/quote/SIW00:COMEX?hl=en", "//div[contains(@class,'YMlKec fxKbKc')]")
2. Calculate the Gold/Silver Ratio
Once you have the Gold price in A1 and the Silver price in A2, use this simple formula to compute the ratio:
=A1/A2
This formula dynamically updates as live prices change, giving you real-time insights.