Solution to Getting Free Stock Data with Excel VBA (No Yahoo API)

Click to download workbook: IEX WB

Or visit my GitHub page: https://github.com/fdupuis659/IEX-Data-VBA

This post will touch on retrieving stock price data in Excel VBA with the IEX API. The full subroutine and link for the workbook are featured below. All dependencies are included in the workbook.

Here is a snippet of the output of the workbook.

For help with the IEX API and what data you can pull, see the documentation here: https://iextrading.com/developer/docs/#ssl

Note this workbook uses the VBA-JSON module for Visual Basic. It can be found here: https://github.com/VBA-tools/VBA-JSON

Note the Scripting library runtime needs to be included for this to work also.

 

Below is the subroutine that parses the JSON and outputs the data to a worksheet.

About the author

programmingforfinance

Hi, I'm Frank. I have a passion for coding and extend it primarily within the realm of Finance.

View all posts

Leave a Reply

Your email address will not be published. Required fields are marked *