Assets and consumables in ounces

I think it the comparison from last month ... green up and red down
thanks

 

Hi S1lv3r,

I would assume that you use gold price in A$ and the price of the assets/consumable such as house price, food cost also in A$, so the ratio is correct i.e numerator & denominator uses the same unit .
However, DOW index and price of crude oil is in US$, there fore you may need to use the denominator of the gold price in US$, instead of A$.

 

Thanks to augirl - I now convert DOW and WTI to AUD before pricing in metals.

And below a potential start of something interesting (The interesting bit is in red)

[imgz=http://forums.silverstackers.com/uploads/554_goldvs3150.jpg][/imgz]

silver line though stays flat - guess more action ahead...

 

Obviously since PMs are on sale, it affected the prices.

happy new year

 

This is fantastic mate.
I really do like this idea - I need to make my own spreadsheets.

 

Awesome and thanks. Can I ask why the house price box is green and the rental cost is red? Even though both have increased in gold terms?

 

The colors on all the assets mean their change in terms of AUD. The buying price has increased, while rent decreased.
There are movements within assets prices notwithstanding the gold/silver changes and they are independent of each other (as far as I'm aware).

 

My favourite thread update. Thanks for your work.

 

Info for the first 3 red cells was obtained from domain.com.au, against my usual habit of taking it from realestate.com.au (which is nuder maintenance at the moment).
In theory the info should be the same/similar.
The gaps between the current averages and the previous ones are not to be discounted,
but I'd suggest waiting with conclusions until the trend is established and shows for the few months (if this is a trend).

AUD has jumped up, together with PMs.

 

would be great to see a graph over time for all of these after so many months of data

 

Maybe you overlooked the small attachment 2 months ago (in post #63, but also some older ones) which contains a plot over time...?

 

[imgz=http://forums.silverstackers.com/uploads/554_assets_in_pms-feb2012.jpg][/imgz]

 

[imgz=http://forums.silverstackers.com/uploads/554_assets-pms-mar2012.jpg][/imgz]


An observation:

1st column (a house):

Dec-10: 503oz
Mar-12: 351oz

Could reverse or change - no one knows the future. But still a nice move

 

Your excellent spreadsheet inspired me to work out the value of my home in Au at the time of purchase and today.

Let's just say i would have had $120k profit if i had invested in gold instead of the house.........

 

Thanks.
I think you still have time to do it - although you'd have to account for the rent you'll pay..

 

[imgz=http://forums.silverstackers.com/uploads/554_assets-pms-apr2012.jpg][/imgz]

 

Back 3 years ago, if i had of dropped my deposit on silver instead of the house i built... id pretty much own my 550k vauled house outright 2day

 

Ouch!

Investment is a cinch with hindsight.

 

[imgz=http://forums.silverstackers.com/uploads/554_assets-pms-may2012.jpg][/imgz]