The macro within the very first remark under enables you to import all varieties of market info for any cryptocurrency/token into Excel, e.g. present worth, quantity, highest and lowest worth within the final 24 hours, change in % within the final 24 hours or market capitalization.
A extra highly effective model of this macro might be discovered within the reply to Has01989’s remark under.
Thanks to Cryptocompare for his or her API and everybody concerned within the growth of the JSON converter.
Link to Tim Hall’s JSON converter: https://github.com/VBA-tools/VBA-JSON/blob/master/JsonConverter.bas
Excel desk within the video might be downloaded right here: https://drive.google.com/file/d/0B1an737Mc_15eHZrN0JJMThHdHM/view?usp=sharing
Get ticker symbols on your cryptos on https://www.cryptocompare.com/, https://www.worldcoinindex.com or many different web sites.
Values, that may be downloaded to Excel: FROMSYMBOL, TOSYMBOL, MARKET, PRICE, LASTUPDATE, LASTVOLUME, LASTVOLUMETO, LASTTRADEID, VOLUME24HOUR, VOLUME24HOURTO, OPEN24HOUR, HIGH24HOUR, LOW24HOUR, LASTMARKET, CHANGE24HOUR, CHANGEPCT24HOUR, SUPPLY, MKTCAP
Also test my open-source net app to handle your portfolio: http://my-cryptoportfolio.renek.cc
If you just like the code and wish to donate me some Satoshis, I’d be grateful: 13kGpAVk87XGRDm6ZscUFvGaTFyjPuKLTY
Comments