doctorj
Hatchet Moderator
- Joined
- 3 January 2005
- Posts
- 3,271
- Reactions
- 8
Could you not quickly add something to automatically retrieve prices from yahoo?time consuming to update prices,
Could you not quickly add something to automatically retrieve prices from yahoo?time consuming to update prices,
No idea. Never Yahoo.Could you not quickly add something to automatically retrieve prices from yahoo?
So after reviewing the data who are the top ranking three candidates?
Yes!!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.
This is a way of updating the data:
http://www.microsoft.com/downloads/details...;displaylang=en
Company:Emergent Resources EMG
Shares on Issue: 42mill ord 21mill options
SP: 60c
MC (m) ~ 20 million (varies daily)
Cash (m) $1.1m this quarter, $1.7m previous
DSO (m/t) in exploration
Mag (m/t) in exploration
Prod tgt. This is what I'm waiting for. Have been some estimates on anns from memory but nothing concrete.
Comments: Main project is the Beyondie Magnetite Project.
(EMG earning 80%). Got on this a few months ago due to the low MC and the length of strike.Thinking of taking some profit now though. One to keep on the watchlist.
OK, here's the 25 June version of the spreadsheet, with column D amended to the web import formula, and with the downloaded stock quotes add-on in the toolbar - see attached screenprint. The screenprint was made with the cursor on cell D6, showing the formula to be copied down that column - the row number will go up by 1 with each successively lower row of course - ie formula in cell D7 will be =MSNStockQuote($A7,"last price","AU") etc...
Edit: The spreadsheet I have posted seems to be updating OK - the SP column needs to be increased to 3 decimal places to pick up the smallest tick size.
Left it out because of the Coal. Just going for pure IO plays.Great work and thanks
Did you leave AQA or just forgotten it
Thank you Wrong'un. Great stuff.Thanks Kennas
This version of the spreadsheet updates the share prices, if you have installed the stock quotes tab on the Excel toolbar.
Hello and welcome to Aussie Stock Forums!
To gain full access you must register. Registration is free and takes only a few seconds to complete.
Already a member? Log in here.