In this tutorial, we will kill two birds with one stone. We will start by learning how to interact with API's with Excel's Power Query feature. We will then pass in arguments to the URL string via a UserForm we will make. So we will essentially cover using Power Query and UserForms in conjunction to get the data we want. In this case, we are interacting with the Zacks Investment Research API for stock data. We want each query to update with a ticker and frequency for the data inputted by the user.
Link to Workbook:
http://programmingforfinance.com/2017/10/api-interaction-with-excel/
My Website: http://programmingforfinance.com/
