Practical overview
When it fits
Use it when you want to adapt VBA code for exchange API communication inside an Excel workbook and can review or maintain the connector code yourself.
Who it is for
- Excel users with some VBA knowledge who want to build exchange API integrations.
- Developers adapting exchange data retrieval or request-sending code for spreadsheet-based tools.
Documented uses
- Retrieve information from supported cryptocurrency exchange APIs into Excel.
- Send supported API requests from VBA code.
- Convert JSON responses into arrays, ranges or flatter tables for spreadsheet use.
- Use exchange connector examples as building blocks for a custom workbook.
Requirements & limits
The project is a public GitHub repository released under the MIT license.
- The README lists connectors for multiple exchanges, but says they are not actively checked for updates.
- The maintainer describes the project as on hold.
- The documented environment is Windows and Excel; the README reports testing with Windows 10 and Excel 365 and says Excel 2007 or later should work.
- The VBA editor needs specified references, and .NET 3.5 or greater is required for hashing algorithms.
- The README reports virus warnings for the example .xlsm file and suggests importing modules and setting references manually as an alternative.
Check current requirements in the official documentation. Source-based guidance does not mean OpenViST has run or independently tested this project.
Import VBA modules or open the sample workbook
Prepare the project code in Excel for reviewing its usage examples.
Before you start
- Excel with the VBA editor
- Some VBA knowledge
- The repository's .bas modules or sample Excel file
- Required VBA editor references listed in the README
- .NET 3.5 or greater for the hashing algorithms
Steps
Import the .bas files you need into a VBA project, or use the sample Excel file.
Check the VBA editor references listed in the README; the example file already has them set up.
Review the examples in the modules to see how the code is used.
Expected outcome
The selected code or sample workbook is available in Excel for inspection and adaptation.
Guide limitations
- This covers project setup and example review, not a verified live exchange request.
- The maintainer says the project is on hold and exchange connectors are not being checked for updates.
- The sample .xlsm file has reportedly triggered virus warnings; the README suggests importing .bas modules and setting references manually as an alternative.
Sources & review
Source record details
- Source availability
- Active
- Sources checked
- 15 October 2026
- Original website title
- krijnsent/crypto_vba · Official homepage title · retained in its source language

