Anonymous
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!
26
Discussion (26)
Learn how to style your text
Reply
Save
The workarounds listed in this thread didn't seem to work for me. Thanks to the other posters, I regineered it to make their formula to make it work for me. Hope this helps anyone else who had issues.
=REGEXEXTRACT(index(IMPORTHTML("http://www.shareinvestor.com/fundamental/factsh...",5),1,1),"0-9*.0-9+0-9+"))
Reply
Save
Read 4 other comments 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
Related Articles
Related Posts
Related Products
Moomoo Singapore
4.7
476 Reviews
From $0
MINIMUM FEE
0.03%
TRADING FEES
Custodian
STOCK HOLDING TYPE
Saxo Markets
4.5
956 Reviews
Syfe Trade
4.9
124 Reviews
Related Posts
You can pull in data from Yahoo Finance quite easily using Google Apps Script. In the Apps script, you can define a function to retrieve data from any web page and then parse the HTML output.
I explained about how to do this in-depth in an article on Medium.