In the introduction of the vba page , there is an example stated:  fetching live stock data from an external website -> populate the data to a cell range -> format the data in an aesthetic way -> and, repeat these tasks daily in a scheduled manner).

 

I wonder how to do this.

 

As I want to fetch about 100 stock price from yahoo. I can get the stock price by the add query in Excel then I can also delete the connection to make the spreadsheet faster. However, in zoho doc, there is no such add query or refresh query function. How to "fetch live stock data" like what the introduction said?