Today we have updated our Excel/VBA example for Fundamentals data feed with JSON output. The first time we had published the version of this Excel file around a year ago, but the latest versions of Excel 2019 does not work correctly with VBA-JSON library we use and now we updated the file with a new library to support latest Windows Excel and Excel for Mac versions.
As we already mentioned. If you are not familiar with any programming languages, we have several Excel examples to help you download data with our JSON API and this VBA Fundamentals example is one of them. You can download it here: Excel/VBA example for Fundamentals.
For Fundamentals JSON API we use VBA-JSON open library from GitHub (https://github.com/VBA-tools/VBA-JSON). JSON conversion and parsing for VBA (Windows and Mac Excel, Access, and other Office applications).
The file tested in Windows Excel 2013, Excel 2017, Excel 2019 and Excel for Mac 2011, but should apply to 2007+.
- For Windows-only support, include a reference to “Microsoft Scripting Runtime”
- For Mac and Windows support, include VBA-Dictionary