Tracking coronavirus cases worldwide
Tracking coronavirus cases worldwide

TL;DR — Use this Google Sheets template to very quickly track confirmed cases, deaths, and recoveries related to the Coronavirus worldwide.

How to use

  1. Open the Google Sheet template located here: https://docs.google.com/spreadsheets/d/1ngSUdIIddNyBPaTqvy-BSEXcg1EzI1pBwZRQgos3_9U/edit?usp=sharing


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

Cryptosheets 2.0 available for Excel & Googlesheets

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

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

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

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! 👌


TL;DR: It’s time for a new release. Spreadstreet now has a way to get a free month, added Solume.io, and now has loads of new endpoints for GDAX, Bittrex, and Cryptocompare.

Download

Invite your friends for a free month!

John Young

Founder, Cryptosheets and Spreadstreet. Husband to the most beautiful woman in the world. Runner-up in 6th grade spelling bee. Super-nerd.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store