8 graphs on gold price movements (86 years data)

Today I want to show you some patterns of gold prices from last few decades. There is no interpretation or conclusion but some findings and observations on gold price fluctuations in India. From last 10 yrs gold has been on a bull run and prices have multiplied many folds. In the last couple of weeks, gold prices have been extremely volatile and some analysts also predict that gold price upside movement is in threat. So I found gold prices for last 86 yrs (1925 – 2011) and did some number crunching and some graphs from which we get some interesting findings.

Gold Historical Prices

4 yrs Gold Price difference (absolute returns

I found out the price difference for every 4 yrs period i.e. from 1928 to 1925 (yrs) and saw what exactly was the difference in the prices, then 1929 – 1926 and so on… till 2007-2011. Just to give you an idea, gold price in 2008 was 12,500 and in 2011 it was 26,400; so the price difference was 111.20%. I used these data to plot a running 4 yrs price difference so at any point of time you can see how much was the return in those 4 yrs prior to that point. Note that this change in absolute in difference.  The major point to note is that majority people think that gold has performed outstanding post 2000 in a time frame of 4 yrs. But from the graph you can see that in 70’s time the 4 yrs period return was much more than what investors saw in recent time.

 

Gold Historical Prices

8 yrs Absolute Price difference runnin

This one is just like above chart, but this time its 8 yrs price difference. We are trying to catch that was the price change in an 8 yrs period. So for example, price in year 1980 was Rs 1330, then after 8 yrs – in 1987, the price was Rs 2570, which is a 93.23%… So like this I calculated the price difference for all the 8 yrs period and graphed it. There are very less 8 yr holding period when the returns from gold was negative, that happened 50’s and 60’s and just 90’s end.

Gold Historical Prices

4 yrs CAGR running

The next chart is the CAGR return chart for 4 yrs time frame and the graph is for running periods… that means 1925-1928, 1926-1929… 2008-2011. CAGR return is the main indicator of the performance of any instrument. If you look at the chart below you can see the ups and downs in gold performance and you can see how gold has performed in short run (4 yrs period) for a long time line. You can see that gold returns touched 20%-25% in 70’s and even in recent time it has performed wonderfully… which we all are aware of :).

Gold Historical Prices

8 yrs CAGR running

Then you can see the graph below which shows CAGR return on 8 yr running period. The interesting a little obvious fact is that it hardly gave any negative return in any 8 yrs time frame, only during 50’s and late 90’s it has performed badly.

Gold Historical Prices

20 yrs CAGR running

The real test of gold comes from a very long term performance and if we see a 20 yrs CAGR return on rolling basis (1925 – 1944, 1926-1945… 1992-2011), then you can see that most of the times the returns has been in the range of 5-10% and only in the 80’s people got best return if they had bought it in 60’s.

Gold Historical Prices

CAGR from 1926 (base year)

This chart is interesting; it calculates the CAGR return of GOLD from 1926 to all the years. I mean CAGR return from 1925- 1926, 1925-1927, 1925-1928 and then 1925-2011… So the base year is always 1925. This shows you what was the very long term CAGR return of gold considering it was bought in 1925. In a way this does not give us very strong conclusion, but still shows us some perspective.

Gold Historical Prices

CAGR from 1960 (base year)

This graph is same as above just that the base year taken was 1960 so considering gold was bought in 1960, the graph shows the CAGR return for different holding periods. You can see that apart from those who sold the gold in 80’s realised the best CAGR return, but those who held it for long, still have the returns in range of below 10%.

Gold Historical Prices

CAGR from 1980 (base year)

The last chart I want to show is with base year of 1980, you can see that over the long term the returns have converged to 10% & only in the last 10 yrs you can see the returns again going up.

Gold Historical Prices
What are your conclusions based on these charts ? What do you think about gold price movement from this point onwards ?

155 CommentsAdd Comment

  1. Shashank K S

    I am not emotional about Gold at all but now i know why people buy it- As hedge against inflation. Although they sell it if there is no other avenue. But i dont understand why is government trying to curb purchase of gold? wont it lead to smuggling? Cant governments push ETF in a big way so that they can curb smuggling??

  2. Sita

    Very informative graphs.
    May I ask where you got the raw data from? Am I right in assuming this is the nominal price of gold in INR?

    Thank You

  3. Excellent piece of information, I had come to know about your website from my friend kishore, pune,i have read atleast 8

    posts of yours by now, and let me tell you, your site gives the best and the most interesting information. This is just the

    kind of information that i had been looking for, i’m already your rss reader now and i would regularly watch out for the new

    posts, once again hats off to you! Thanx a lot once again

  4. Amrut

    Hi Manish,

    Need your advise-Thinking of selling Gold and buying property. Do you think it is a sensible thought or should I stick with Gold.

    Thanks in advance.

Leave a Comment