Australia's largest stock trading and investment forum Australia's #1 stock forum

Much appreciated. Solved 2 problems for me. Firstly the decimal...

First 125 Last

Share
Profile

Follow
croc49

111 Posts.

7

14/02/18

14:01

Post #: 31050268
Share

Originally posted by ColonialCousin ↑

Hi Mate,
In googlesheets, there is a workaround to get current (20 min delayed) price to 3 decimals via google finance. Use below formula in your google sheet:
=(INDEX(SORT(GOOGLEFINANCE("ASX:"&A2,"PRICE", TODAY()-7, TODAY()),1,FALSE),2,2)*(1+GOOGLEFINANCE("ASX:"&$A2,"CHANGEPCT")/100))

Change 'A2' to match your ticker cell.

Expand

Much appreciated.
Solved 2 problems for me.
Firstly the decimal point.
And I have been concatenating ASX: and A2 together for my main A2 list for Google to read ticker (if you know what I mean).
2 Upvote

0 Great analysis

Reply

There are more pages in this discussion • 116 more messages in this thread...

First 125 Last