Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

ChrisMBarber
Advocate I
‎06-06-2020 05:16 AM

Gathering Stock Market Information Using APIs

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

 

Capture.PNG

 

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
Labels: