網頁

2019年3月14日 星期四

[投資] 如何使用Google 試算表抓取股票資料 How to use the Google Spreadsheet to GET the stock DATA

For example:
symbol: BND

We can use one of the following methods to get the price by using the Google Spreadsheet.

1. =GOOGLEFINANCE(BND, "price") 

2. =importxml("http://etfs.morningstar.com/quote-banner?t="&BND,"//div[@id='lastPrice'] ") 

3. =VALUE(Substitute(Index(ImportHtml("http://bigcharts.marketwatch.com/advchart/frames/frames.asp?symb="&$BND, "table"),3,1),"Last:","")) 

4. =Index(ImportHtml("http://bigcharts.marketwatch.com/advchart/frames/frames.asp?symb="&$BND, "table"),3,1)

沒有留言:

張貼留言