Follow the Gold:Silver Ratio

In the last post, I briefly explained the importance of the gold:silver ratio. But let’s revisit that subject with a 5 minute video by David Morgan and Mike Maloney, in which they discuss the gold:silver ratio, its trends and importance.

I have an app on my phone that was made by JM Bullion, a reputable precious metals dealer. It is neatly formatted, and shows you the current precious metals pricing, including Gold, Silver, Platinum, and Palladium, as well as the current gold:silver ratio. I’ve also configured it to email me the spot price each morning.

While I have no affiliation with JM Bullion, I have bought silver from them before, and it was a positive experience. As a function of that purchase, I set up a free account, which also enabled me to configure the app to text/email me with price alerts.

Unfortunately, what it will not do is alert me to changes in the gold:silver ratio. After doing a fairly extensive search, I was not able to find such an app. So I collaborated once again with Google Gemini to build a spreadsheet and a script that tracks the gold price, the silver price, and the gold:silver ratio.

The Gold price and Silver price are each pulled every six hours from Google finance. The spreadsheet calculates the gold:silver ratio, and displays it in a table & graph form.

It’s a very simple chart.

The “CurrentPrice” tab shows what you see here, and the “History” tab shows the price/ratio history, going back to 05 Feb 2026 when I set it up.

As with all things, let me know if you have any questions, suggestions, or snide comments.

Ron Jones
Connect at:
Latest posts by Ron Jones (see all)

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.