Gathering Stock Market Information Using APIs

[ChrisMBarber]

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...

Stock Prices - Worked Example.pbix