Advertisement
2
Discussion (2)
Learn how to style your text
Reply
Save
You can use web scraping functions instead, reading a webpage with a price for the fund. Here is what I use:
=IMPORTXML("https://www.cnbc.com/quotes/3067-HK", "//*@id='MainContentContainer'/div/div2/div1/div2/div3/div1/div2/span1")
β
The second parameter is XPath. If you use a different page, you can easily retrieve XPath using 'Inspect Element' in Safari (need to enable Developer mode first).
Reply
Save
Write your thoughts
Related Articles
Related Posts
Related Posts
Advertisement
You can pull the price data in from Yahoo Finance. That can be done 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.