Sean K
Moderator
- Joined
- 21 April 2006
- Posts
- 22,126
- Reactions
- 11,225
OK, to add in the msn auto thingy, follow Wrong'un's comments provided in the IO comparison thread.
KGL added.
Note:
When I started putting this together lots of gold stocks were below what was considered an 'average' for junior explorers, developers and producers. For example, the average EV to oz au for a West African explorer was supposed to be about 30 bucks. At that time we had the likes of AZM, PRU, ADU, GRY all trading lower than that. AZM was at $5 an ounce at one point...However, now, they are all practically DOUBLE that! Yeah sure, POG has exploded, but what happens when the spec money comes out, USD corrects back up in the short term (probable). I think we'll see the valuation here come down quite a bit. Of course, USD could just go straight down couldn't it?
Adding RMS, but but can't find their total JORC? The DIO thing is ongoing by the look.This is a way of updating the data:
You need to close Excel, then download an Excel add-on from the Microsoft website - it uses the MSN Money website to get prices.
http://www.microsoft.com/downloads/details...;displaylang=en
When the download has been done, open Excel and note the floating toolbar that appears - drag this into the Excel toolbar.
Clicking on "Insert Stock Quotes" will open a window from where you can type in the stock code and enter the Exchange -
But in the specific case of the Iron Ore Juniors' spreadsheet, just go the the "SP" column and type =MSNStockQuote($A6,"Last price","AU") in cell D6 - then copy this formula down to the bottom of the table. (Cell $A6 contains the code of the company in question). Double click on "Update Quotes" in the new toolbar to update the quotes. (the "Update Quotes" tag will go grey for 5 minutes, after which you can update again.)
Hope this helps.
KGL added.
Note:
When I started putting this together lots of gold stocks were below what was considered an 'average' for junior explorers, developers and producers. For example, the average EV to oz au for a West African explorer was supposed to be about 30 bucks. At that time we had the likes of AZM, PRU, ADU, GRY all trading lower than that. AZM was at $5 an ounce at one point...However, now, they are all practically DOUBLE that! Yeah sure, POG has exploded, but what happens when the spec money comes out, USD corrects back up in the short term (probable). I think we'll see the valuation here come down quite a bit. Of course, USD could just go straight down couldn't it?