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

Advertisement

Anonymous

09 Jun 2021

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!

24

    Discussion (24)

    What are your thoughts?

    =IMPORTXML("https://sg.finance.yahoo.com/quote/ME8U.SI","//...[@class='Trsdu(0.3s) Fw(b) Fz(36px) Mb(-4px) D(ib)']")

    Since bloomberg block google sheet, I had changed to yahoo finance

    Reply

    Save

    Share

      View 4 replies

      Hi

      can try the below code in Google Sheets.

      =REGEXREPLACE(index(IMPORTHTML("http://www.shareinvestor.com/fundamental/factsh...",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/factsh...",5),1,1),"^d","")/1000​​​

      Reply

      Save

      Share

        View 5 replies

        The workarounds listed in this thread didn't seem to work for me. Thanks to the other posters, I reg...

        Read 22 other comments 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

        Write your thoughts

        Advertisement