facebookIs there a way to send in live/delayed sgx stock prices to Google sheets? - Seedly
Seedly logo
Seedly logo
 

Anonymous

Asked on 21 Jul 2020

Is there a way to send in live/delayed sgx stock prices to Google sheets?

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!

0 comments

4 answers

Answer Now

Answers (4)

Ck Thong

Ck Thong

Level 3. Wonderkid

Answered on 03 Oct 2020

=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

3

1 more comments

Weng Chew

Weng Chew

28 Oct 2020

Thank You!

Amelia Phung

Amelia Phung

24 Jan 2021

This is so helpful 👍

Thank You!
Can you clarify
I wonder if
This is so helpful 👍
What about

Post

C

Ci2fi

Level 2. Rookie

Answered on 18 Jan 2021

Hi

can try the below code in Google Sheets.

=REGEXREPLACE(index(IMPORTHTML("http://www.shareinvestor.com/fundamental/factsheet.html?counter=D8DU.SI","table",5),1,1),"^d","")/1000

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)

=REGEXREPLACE(index(IMPORTHTML("http://www.shareinvestor.com/fundamental/factsheet.html?counter=Z74.SI","table",5),1,1),"^d","")/1000​​​

0

Thank You!
Can you clarify
I wonder if
This is so helpful 👍
What about

Post

Sogon Leong

Sogon Leong

Level 3. Wonderkid

Updated on 17 Jan 2021

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.

Continue with Facebook
Sign in with Apple

Sign up or login with an email here