Posted 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)
The workarounds listed in this thread didn't seem to work for me. Thanks to the other posters, I reg...
Read 3 other discussions 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
Write your thoughts
POEMS by PhillipCapital
0.08% to 0.12%
STOCK HOLDING TYPE