Coinmetrics and Coindar now available in Cryptosheets

Published in

Cryptosheets

4 min readAug 21, 2018

Cryptosheets is now available on Microsoft’s official store, Appsource

Investors need access to detailed and robust data. We wanted to give our users the deepest, cleanest, and most extensive cryptocurrency data. We are excited to announce powerful new datasets aimed at making your cryptocurrency analysis easier than ever before.

Our newest update includes:

Coinmetrics Historical: Blockchain data of a given asset over a specified time range
Coindar Events: Returns cryptocurrency events
Coindar Social: Returns a massive list of all coins social data, including social links and user counts

Let’s take a deeper dive into each integration:

Coinmetrics

Coinmetrics Historical

Description: Blockchain data of a given asset over a specified time range

Data returned:

txcount
txvolume(usd)
adjustedtxvolume(usd)
paymentcount
activeaddresses
fees
medianfee
generatedcoins
averagedifficulty
mediantxvalue(usd)
blocksize
blockcount
price(usd)
marketcap(usd)
exchangevolume(usd)

Example: Return metrics for Bitcoin from August 1st, 2018 to August 21st, 2018.

How to pull

In the Cryptosheets ribbon, click Dashboard
Login to the service through Google, or sign-up option
Click the orange + button
Click Coin Metrics Historical
Choose Start Time (GMT) and End Time (GMT)
Click the Table Headers toggle
Click into A1 of the “Data” tab, click Highlight Range, and Place Data
Verify that data has updated
You also have the option to choose a timed refresh interval.

P.S.: Nic Carter (founder of Coinmetrics) just finished funding for his VC fund to invest in blockchain projects. Go send him a congratulations on Twitter!

Coindar

Coindar Social

Description: Returns an exhaustive list of social data for all coins.

Data Returned (Example used is Ripple):

coin_id: 3
website: https://ripple.com/xrp/
bitcointalk:
twitter: https://twitter.com/Ripple
reddit: https://reddit.com/r/ripple
telegram: https://t.me/Ripple
facebook: https://facebook.com/ripplepay
github: https://gitgub.com/ripple
explorer: https://xrpcharts.ripple.com/#/graph/
youtube: https://youtube.com/user/ripplevideo1
twitter_count: 886610
reddit_count: 189502
telegram_count: 64666
facebook_count: 125144

How to pull

In the Cryptosheets ribbon, click Dashboard
Login to the service through Google, or sign-up option
Click the orange + button
Click Coindar Social
Click the Table Headers toggle
Click into A1 of the “Data” tab, click Highlight Range, and Place Data
Verify that data has updated

Coindar Events

Description: Returns cryptocurrency events specified by coin

Data Returned:

caption — event caption.
source — link to the event description.
proof — proof link.
date_public — event publication date on Coindar.

All dates are in UTC and yyyy-mm-dd HH:mm format.

date_start — the date of the event start.

If there is no definiton of time, request will be returned in yyyy-mm-dd format.

If only month is defined, in yyyy-mm.

If only quarter is defined, in yyyy-QX, where X is a quarter number.

date_end — events end date.
coin_id — cryptocurrency’s ID.
coin_price_changes — the percentage change in value since the event publication.
tags — tags IDs.

How to pull