Excel add ins from CoinMarketCap to Redis

(Last Updated On: January 17, 2018)
Learn the Secret

Get  our 2 Free Books

Get these now which land directly to their inbox.
Invalid email address

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!
This entry was posted in Bitcoin Crypto Currency and tagged , , , , on by .

About caustic

Hi i there My name is Bryan Downing. I am part of a company called QuantLabs.Net This is specifically a company with a high profile blog about technology, trading, financial, investment, quant, etc. It posts things on how to do job interviews with large companies like Morgan Stanley, Bloomberg, Citibank, and IBM. It also posts different unique tips and tricks on Java, C++, or C programming. It posts about different techniques in learning about Matlab and building models or strategies. There is a lot here if you are into venturing into the financial world like quant or technical analysis. It also discusses the future generation of trading and programming Specialties: C++, Java, C#, Matlab, quant, models, strategies, technical analysis, linux, windows P.S. I have been known to be the worst typist. Do not be offended by it as I like to bang stuff out and put priorty of what I do over typing. Maybe one day I can get a full time copy editor to help out. Do note I prefer videos as they are much easier to produce so check out my many video at youtube.com/quantlabs