Kraken-API-VBA

Kraken.com API using Visual Basic for Applications (VBA, in Excel)

The following files (modules) are more or less linked together and should be imported into an Excel file together to be able to work.

The utility modules:

• WebUtils.bas -- for parsing/printing JSON, HTTP GET/POST requests
• CryptoUtils.bas -- for Hashing, Signing, Byte conversion etc.
• ExcelUtils.bas -- with some helper functions for Excel
• FileUtils.bas -- loading of kraken.key file from local computer (Windows only?) to use for storing Kraken key & secret

The public interface (to be used from other modules etc.):

• API.bas -- public interface for Kraken.com API

Test code (not required):

• Test.bas -- with some test routines

Example Use-Case(s):

• example/ folder (with example Excel file)
• see examples README.md, Public-API.md, Private-API.md

Usage

• Your Excel file should have the extension *.xslm (Excel with Macro support enabled).

• Import *Utils.bas modules and API.bas module into your Excel file.

• Import references (as developer?, Tools-menu) for:

  • Microsoft XML, v6.0 (use your latest MS XML version, required because of early binding, used for HTTP requests)
  • Microsoft Scripting Runtime (this may not be required as modules are loading dynamically?, used for JSON parsing and Dictionary structures)

• Code away ...

• Well, ... look at the example Excel file on how to use the API. :-)

Thoughts ?

• subsitute own code with more official implementations,

  • VBA-JSON
  • VBA-Web

• only for google sheets: cryptofinance.ai

Copyright and License Information

Copyright (c) 2020 Querela. All rights reserved.

See the file "LICENSE" for information on the history of this software, terms & conditions for usage, and a DISCLAIMER OF ALL WARRANTIES.

All trademarks referenced herein are property of their respective holders.

NOTE: Some code has been used (as is or adapted) from online sources, like StackOverflow or blogs. I tried to include the link to the original code on top of the file or in the function itself but I may have not been consistent with this, so all links (and some more) have been listed in the API.bas file at the end.
Credits also to krakenex and the Kraken.com API Docs.

Please contact me if there are license conflicts or something related... and I will try to correct as much as I can.