Sorry for the double post, I just needed to add one more bit of info.
For ASX shares Yahoo does indeed round the values. They sometimes flash back to proper 3 decimal values but when you add the table from Yahoo it shows up rounded in your spreadsheet.
It would be best to use the Trading Room website for tables.
www.tradingroom.com.au
Get a quote and add the table provided in the summary.
Now, I realize this may interfere with peoples spreadsheets where they only want a quoted price on their jeornal and not the entire table.
What you can do is create another sheet on your spreadsheet. You can call it "data table" or something along those lines, but that is the purpose.
Put the table in your extra sheet, and then go back to your jeornal to the column where your input for last traded price is, then link that cell to the data table sheet specifically on the last traded price.
So, your Data sheet has a table for XYZ stock, which features highs, lows, last traded etc etc. On your trading jeornal wher you want the last price put in, run the following formula;
=sum(
cell with last traded price)
This way when you refresh your data it will reflect the last traded price on your jeornal without having a whole table intrude on your sheet.
I hope this helps everyone who tries to do this with live data - it certainly is a fantastic tool.