Tag Archives: add ins

Excel add ins from CoinMarketCap to Redis

Excel add ins from CoinMarketCap to Redis

If I do this XLQ (for Coin Market Cap data), I should be able to push the data into Redis using this Excel add in

https://www.cdata.com/kb/tech/redis-excel-trans.rst

In beta for now

https://www.cdata.com/drivers/redis/excel/

Will I be stuck on Windows? It seems CCXT does support CoinMarketCap but it MAY NOT give the data for % change as in XLQ

CoinMarketCap

CoinMarketCapvia xlqPlus you can work with data for cryptocurrencies from Coin Market Cap (currently over 1300).

Includes formulae for their Rank, MarketCap, Available Supply, and 1 hour, 24 hour and 7 day percent change.

Data is updated every 5 minutes. http://www.qmatix.com

Looking at this CoinMarketCap directly, it seems easiest just to work their end point as described here:

https://coinmarketcap.com/api/

You will not be able to get references from the exchanges so the next question is how to get a quick reference in which exchanges supports which coin.

You could use this example to list out all the coins (symbols) to react to:

https://github.com/ccxt/ccxt/blob/master/examples/py/symbols.py

New  XLQ for Bitcoin and Cyrptocurrency with Coinmarketcap access 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!