Gold Price Historical Data (1969 - 2022)

Context

Gold. A precious item with its own duality. In one side, it's a popular investment asset. In another side, it's a commodity. Whether you buy it as an asset or as commodity, the price for gold is always influenced by two things, as similar as other commodities in market: supply and demand. It's not easy to combine many aspects in supply and demand into a single dataset without making it into wall of columns. And also aggregating the data might not easy to do, since the data might not available publicly. But it doesn't mean we can't learn the historical pattern of gold market. At least some gold price historical data are available for public. And we can use that to analyze the market pattern, and, maybe, learn something from them.

Content

This dataset was based on gold price historical data from macrotrends.net. I added one new column, 'Year Range Price', to see how wide the spread of the price annually.

Acknowledgements

The base data for this dataset was retrieved from https://www.macrotrends.net/1333/historical-gold-prices-100-year-chart.

Inspiration

What variable have the biggest correlation with annual Average Closing Price? What information can we see from the graphic? Are there any reasons why the price drop and rise? What happened on those years? Many things can be learn and explore by historical data. Having historical data is like having a kaleidoscope to see the past, learn from them, and use it as information to walk on our future path.