fbpx

Excel add ins from CoinMarketCap to Redis

(Last Updated On: January 17, 2018)

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!

Subscribe For Latest Updates

Sign up to best of business news, informed analysis and opinions on what matters to you.
Invalid email address
We promise not to spam you. You can unsubscribe at any time.

NOTE!

Check NEW site on stock forex and ETF analysis and automation

Scroll to Top