Using APIs is an effective way to pull up-to-date stock market information and have that information update automatically when used in conjunction with scheduled refresh.
Attached to this article is a walkthrough (API Stock Prices Walkthrough.pdf) on how to create the below report using the free API key from https://www.alphavantage.co/.
Special mention to @cwebb for his blog covering the use of relative path function which can be found at https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.