Announcing Cryptosheets 2.0 for Excel & Googlesheets — Crypto Data Just Got Easy

Read about the relaunch of Cryptosheets including all of our new features, data and more Help center | Excel | | Googlesheets | Contact us

We are excited to announce the new features, functions and redesign of the Cryptosheets.com platform including the Microsoft Excel and GoogleSheets add-ins and new WebApp!

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:

• Bitwise Index Historical: Full historical data for all of Bitwise’s indices
• Bitwise Ticker: Current ticker index price data, performance, and constituent weights
• CryptUnit Earnings: Displays the earnings of a cryptocurrency based on user-input hash rate

Let’s take a deeper dive into each integration:

Bitwise

About Bitwise

Bitwise Asset Management pioneered…

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

Times are tough in the crypto world.

Cryptocurrencies have shed ~$600 billion in market cap from the peaks of early 2018, and the once glorious euphoria of daily gains has all been erased from the minds of investors.

You know cryptocurrencies are “risky”, that cryptocurrencies are “speculative”…but what does that mean?

As we embrace this new market, it’s critical that we try to understand what’s going on. Risk comes in many forms, at both the micro-level (e.g., personal investments) and macro-level (e.g., prevention of market crashes and major loss of capital).

Total Returns are not adjusted for risk

Let’s take the following quiz…one is the right answer…

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:

• Current and historical Quotes
• Current and historical Trades
• Current and historical Order Book
• Current and historical OHLCV
• Data back up to 5 years, down to the millisecond granularity

Note: All data is available for 95+ exchanges, across 2,000+ assets and 11,000+ symbols. …

So, you’re sitting at your computer with money to invest.

You have made some good money already in the market, but you want more.

Cryptocurrencies reached a record $800 billion in market value then came crashing back down to earth and sit right around $200-$300 billion today.

The price movement of top currencies remains a mystery. But it doesn’t have to be.

THE PAIN OF UNCERTAINTY

Cryptocurrencies are volatile, irrational beasts.

Simple methods of forecasting grossly over/underestimate the potential of a volatile currency.

For example, moving averages are used frequently to estimate future prices. …

TL;DR: I created a spreadsheet that automates pulling the entire 1,700+ library of cryptocurrencies from CoinMarketCap. You can find the spreadsheet here:

https://www.dropbox.com/s/19l2bksgojeah4w/Pulling_CoinMarketCap_Data_into_Excel.xlsx?dl=1

CoinMarketCap is the most popular cryptocurrency website in the world. With over 100M page views per month, the website is the go-to resource for cryptocurrency quotes and aggregated spot rates.

While not a perfect solution (we all remember the removal of Korean exchanges event) it still represents the prime place to check cryptocurrency aggregated pricing.

The Problem

While CoinMarketCap does include historical pricing for each coin on it’s website, they do not offer an “Export to CSV” option to…

After many months of hard work, failures, firings, and question marks, I’m excited to finally announce Cryptosheets! 👌