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

Click to download workbook: IEX WB

Or visit my GitHub page:

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:

Note this workbook uses the VBA-JSON module for Visual Basic. It can be found here:

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


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 *