Advertisement

Anonymous

14 Jun 2024

∙

Pull SGX data to Google Sheets

Hi guys! I'm guessing this qns might have been asked before, but any idea how I can pull stock info for eg. stock price (realtime or delayed) for Singapore stocks listed on SGX, to be reflected into Google Sheets?

I’ve tried =GOOGLEFINANCE(“SGX:D05”,”price”) but it didn’t work. :(

Thank you guys!! 🙏🏻😊

6

Discussion (6)

What are your thoughts?

Learn how to style your text

Nigel

08 Jul 2024

Use yahoo finance

Reply

Save

Cedric Koh

20 Jun 2024

You can use formulas such as IMPORTXML() to extract the data. This link explains how you can do that: https://anonoz.github.io/finance/2022/02/28/goo...

Reply

Save

View 1 replies

Ivan Ling

20 Jun 2024

Im using yahoo instead...

Write your thoughts

Related Posts

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

(Stocks Discussion) SGX: Powermatic Data Systems Ltd (SGX: BCY)?

(Stocks Discussion) SGX: Powermatic Data Systems Limited [SXG: BCY.SI]?

Is there an alternative method to update 3067.HK's price (iShares Hang Seng TECH ETF) in Google Sheet, other than GOOGLEFINANCE()?

Dividend investing personalized Google Spread sheet tracker

Related Posts

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

(Stocks Discussion) SGX: Powermatic Data Systems Ltd (SGX: BCY)?

(Stocks Discussion) SGX: Powermatic Data Systems Limited [SXG: BCY.SI]?

Is there an alternative method to update 3067.HK's price (iShares Hang Seng TECH ETF) in Google Sheet, other than GOOGLEFINANCE()?

Dividend investing personalized Google Spread sheet tracker

Advertisement