An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
.gitignore Updated readme Jun 15, 2017
ImmediateReporter.cls
JsonConverter.bas Updating test settings Sep 18, 2018
LICENSE Initial commit May 15, 2017
ModExchBinance.bas Implement POST in ModWeb Sep 24, 2018
ModExchBitfinex.bas Implement POST in ModWeb Sep 24, 2018
ModExchBittrex.bas Updated tests Kucoin and Cryptocompare Oct 1, 2018
ModExchCoinigy.bas Added coinigy Dec 30, 2017
ModExchCoinone.bas
ModExchCoinspot.bas Implement POST in ModWeb Sep 24, 2018
ModExchCryptopia.bas Implement POST in ModWeb Sep 24, 2018
ModExchGDAX.bas Implement POST in ModWeb Sep 24, 2018
ModExchHitBTC.bas Implement POST in ModWeb Sep 24, 2018
ModExchKraken.bas Implement POST in ModWeb Sep 24, 2018
ModExchKucoin.bas Updated tests Kucoin and Cryptocompare Oct 1, 2018
ModExchLiqui.bas Implement POST in ModWeb Sep 24, 2018
ModExchPoloniex.bas Implement POST in ModWeb Sep 24, 2018
ModExchWEXnz.bas Implement POST in ModWeb Sep 24, 2018
ModFunctions.bas Implemented testing Sep 19, 2018
ModHash.bas Implemented testing Sep 19, 2018
ModJSON.bas Implemented testing Sep 19, 2018
ModSrcCryptocompare.bas Updated tests Kucoin and Cryptocompare Oct 1, 2018
ModWeb.bas Updated tests Kucoin and Cryptocompare Oct 1, 2018
TestCase.cls Implemented testing Sep 19, 2018
TestSuite.cls
WorkbookReporter.cls Implemented testing Sep 19, 2018
crypto_vba_example.xlsm
readme.md Added spreadsheet functions and examples Feb 1, 2018

readme.md

crypto_vba

An Excel/VBA project to communicate with various cryptocurrency exchanges APIs. Tested on Windows 10 & Excel 2016, but should work for Excel 2007+.

Exchanges:

Get information from/send information to:

The API response is pure JSON, for which I included https://github.com/VBA-tools/VBA-JSON to process and a function to build on that. As this is my first Git experiment and Excel/VBA and git don't work that well together, my pushes/forks/updates might be clunky...

How to use?

Import the .bas files you need or simply take the sample Excel file. In the modules you'll find some examples how to use the code. Feel free to create an issue if things don't work for you.

ToDo

  • Expand the XLSM file with working examples
  • Better testing
  • Better error handling
  • Later: place/cancel orders

Done

  • For historical prices, include https://www.cryptocompare.com/api/
  • Build excel functions to get the information directly to a sheet - TEST PHASE
  • Working examples of several exchanges in the example file
  • Created a basic XLSM sample file
  • ArrayToTable improvement to handle various data types (e.g. Trade and Margin trade) in one JSON response
  • Post-process the Array to a more usable format (flat table)
  • Process the response to something you can use in Excel: an array/Range etc.
  • Build a function to transform the JSON to an Array
  • Build tests for all modules/functions
  • Integrate VBA-JSON into the project
  • Build the Bittrex API connector
  • Build the WEXnz API connector (used to be BTCe)
  • Build the Poloniex API connector
  • Build the Kraken API connector
  • Build the Liqui API connector
  • Build the Coinone API connector
  • Build the Cryptopia API connector
  • Build the Binance API connector
  • Build the Coinigy API connector
  • Build the Kucoin API connector
  • Build the HitBTC API connector
  • Build the Coinspot API connector - not finished
  • Build the GDAX API connector - not finished
  • Build the Bitfinex API connector - not finished
  • Build a working and tested VBA hash function
  • Added the UrlEncode function for Cryptopia (and Excel versions before 2016)

Donate

If this project/the Excel saves you a lot of programming time, consider sending me a coffee or a beer:
BTC: 1DNFF9y3dDMLNURpgdT3wXmFpmGBsQRyPa
ETH (or ERC-20 tokens): 0x9070C5D93ADb58B8cc0b281051710CB67a40C72B
DOGE: DHSN2ZEaLqoSW6v9Mg39pwNktHBD7ESSsi
Cheers!