View Single Post
Old 12-11-2017, 01:02 AM   #45
Supremacy Member
apriliasiao's Avatar
Join Date: Dec 2001
Posts: 6,466
I used:


to get minute update of intraday prices for 1 day at every manual refresh (i think creating a auto refresh script in Sheets might work as well)

In another cell I simply lookup the last entry of the above to get the current price:


where N is the column for the close price

Hope this helps.
thanks but i have error using your Singtel example.
apriliasiao is offline   Reply With Quote