top of page
Writer's pictureFahad H

Market knowledge of any cryptocurrency (Bitcoin, Ether, …) into Excel (Macro included)


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.

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

0 views0 comments

Comments


bottom of page