Historical Precious Metal Prices and Technical Trading Charts - All in Excel

Welcome to the Precious Metals Bug Forums

Welcome to the PMBug forums - a watering hole for folks interested in gold, silver, precious metals, sound money, investing, market and economic news, central bank monetary policies, politics and more. You can visit the forum page to see the list of forum nodes (categories/rooms) for topics.

Please have a look around and if you like what you see, please consider registering an account and joining the discussions. When you register an account and log in, you may enjoy additional benefits including no ads, market data/charts, access to trade/barter with the community and much more. Registering an account is free - you have nothing to lose!


Fly on the Wall
Reaction score

I'm a new member, but I've been a PM trader for some time. I'm also a spreadsheet fanatic and tend to think in VBA.

Here's one of my spreadsheets: http://investexcel.net/4354/precious-metals-historical-prices-technical-trading-charts/

This spreadsheet downloads precious metal prices from the web and plots the relative strength index, MACD, 12- and 26-day EMA, historical volatility and the closing price.

I use (a variant of) this spreadsheet to make some trading decisions

Hope to contribute more

Top Bottom