Asked on 21 Jul 2020
I'm using Google sheets to track my portfolio. As I'm buying the Nikko am sti etf for DCA, it is not practical to use bloomberg/sgx to track my P&L. I've tried =googlefinance but it doesn't work for sgx stocks. Would appreciate your assistance. Thanks!
=IMPORTXML("https://sg.finance.yahoo.com/quote/ME8U.SI","//span[@class='Trsdu(0.3s) Fw(b) Fz(36px) Mb(-4px) D(ib)']")
Since bloomberg block google sheet, I had changed to yahoo finance
can try the below code in Google Sheets.
Just replace D8DU.SI with the ticker u want.
E.g. Singtel ticker is Z74.SI, so u change to this ticker name in the code. (counter=Z74.SI)
As mentioned by others earlier you can use Shareinvestor as an alternative but the table has index 5...
Read 2 other answers with a Seedly account
You will also enjoy exclusive benefits and get access to members only features.
Sign up or login with an email here