Advertisement
Anonymous
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
4.5
958 Reviews
US$1
MINIMUM FEE
0.03% to 0.08%
TRADING FEES
Custodian
STOCK HOLDING TYPE
4.7
484 Reviews
4.9
131 Reviews
Related Posts
Advertisement
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.