View Single Post
Old 08-11-2017, 09:43 AM   #22
Jumpman23
Supremacy Member
 
Jumpman23's Avatar
 
Join Date: Jan 2000
Posts: 5,481
did u manage to find a way to feed in SGX stock into google sheet? can share?
I used:

=arrayformula(ImportData("http://finance.google.com/finance/getprices?x=SGX&q=Z74&i=60&p=1d"))

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:

=INDEX(FILTER(N:N,NOT(ISBLANK(N:N))),ROWS(FILTER(N:N,NOT(ISBLANK(N:N)))))

where N is the column for the close price

Hope this helps.
Jumpman23 is offline   Reply With Quote