Homepage
Open in app
Sign in
Get started
Cryptosheets
All your crypto data in one place for Excel or Googlesheets. Hundreds of providers. Thousands of datasets. Real time streaming data into your worksheets. Crypto data just got easy.
About
Homepage
Follow
How to Build a Real Time Streaming Cryptocurrency Dashboard in Excel in 5 Minutes
How to Build a Real Time Streaming Cryptocurrency Dashboard in Excel in 5 Minutes
It has never been easier to pull live streaming cryptocurrency prices into your spreadsheets. Now you can do it for free in a few seconds…
Chris Ware
Jul 28, 2020
Using Crypto ETF Pricing with Live Formulas in Excel & Googlesheets using Cryptosheets
Using Crypto ETF Pricing with Live Formulas in Excel & Googlesheets using Cryptosheets
Learn how to access an easy to use crypto ETF dashboard and standalone pricing with automatic refreshable formulas in Excel and…
Chris Ware
Feb 20
Get Started with Crypto Data & DeFi Metrics in your Spreadsheets
Get Started with Crypto Data & DeFi Metrics in your Spreadsheets
Easy to use crypto dashboards with automatic refreshable formulas in Excel and Googlesheets for your crypto portfolio including current and…
Chris Ware
Dec 11, 2023
Deribit API data in Excel & Google Sheets for Crypto Derivatives Risk Management & Options Analysis
Deribit API data in Excel & Google Sheets for Crypto Derivatives Risk Management & Options Analysis
Advanced crypto asset portfolio management strategies and tools
Chris Ware
Apr 15, 2022
How to Add Fundamental Analysis to Your Crypto Portfolio with Messari (Part 1)
How to Add Fundamental Analysis to Your Crypto Portfolio with Messari (Part 1)
Adding fundamental analysis to your crypto portfolio is the next step after basic market data like volatility and risk adjust performance…
Chris Ware
Oct 29, 2020
Introducing Cryptosheets Scenarios
Introducing Cryptosheets Scenarios
Cryptosheets scenarios are dynamic combinations of pre-configured queries, transformations and filters easily searchable & accessible with…
Chris Ware
Oct 27, 2020
How to Get Crypto DeFi Data Into Your Spreadsheet: Part 1
How to Get Crypto DeFi Data Into Your Spreadsheet: Part 1
While DeFi continues gaining in popularity, DeFi data remains difficult to access for non-developers. Learn how to get different types of…
Chris Ware
Sep 29, 2020
🔎 How to use the Cryptosheets CS.SYMBOLS function to get live/historical data for any crypto asset
🔎 How to use the Cryptosheets CS.SYMBOLS function to get live/historical data for any crypto asset
The most important crypto data for global adoption above all else isn’t the price or marketcap — it’s the symbol, identifier, ticker, slug…
Chris Ware
Jul 17, 2020
How to Pull 30,000 Cryptocurrency Sharpe Ratios in 5 seconds
How to Pull 30,000 Cryptocurrency Sharpe Ratios in 5 seconds
Access in depth Sharpe ratio & performance data on crypto assets to leverage one of the most widely used risk metrics in professional…
Chris Ware
Jun 30, 2020
📢Announcing IEX Cloud API & Cryptosheets Integration
📢Announcing IEX Cloud API & Cryptosheets Integration
We are excited to officially announce the integration of IEX Cloud with Cryptosheets! Institutional quality capital markets and crypto…
Chris Ware
May 12, 2020
Automatically Refresh 110,000 Crypto Assets in Real Time or at Any Interval in Excel &…
Automatically Refresh 110,000 Crypto Assets in Real Time or at Any Interval in Excel &…
Keeping crypto data up to date in a spreadsheet can be a real pain in the #ss. No more VBA, no shady scripts or downloads, no complicated…
Chris Ware
May 7, 2020
Bitcoin Halving — Historical Scenario Analysis Charts in Excel & Googlesheets
Bitcoin Halving — Historical Scenario Analysis Charts in Excel & Googlesheets
This ain’t your older brother’s halving. Analyzing price movements related to the Bitcoin block reward halving starts with getting your…
Chris Ware
Apr 30, 2020
Why Datetime Formatting for Crypto API Data is the Most Important Part of Your Trading Analysis
Why Datetime Formatting for Crypto API Data is the Most Important Part of Your Trading Analysis
Being able to instantly convert back and forth between hundreds of different datetime & timestamp formats is a game changer for any…
Chris Ware
Apr 10, 2020
Announcing Cryptocompare & Cryptosheets Integration
Announcing Cryptocompare & Cryptosheets Integration
We are excited to officially announce our partnership & full API docs portal integration with Cryptocompare! The highest quality crypto…
Chris Ware
Apr 2, 2020
Manage Your Crypto Portfolio with Cryptosheets & Cointracking.info (part 1)
Manage Your Crypto Portfolio with Cryptosheets & Cointracking.info (part 1)
Crypto portfolio management is incredibly challenging for many reasons including tracking & integrating accurate data for your positions…
Chris Ware
Mar 26, 2020
A simple spreadsheet to track Coronavirus
A simple spreadsheet to track Coronavirus
TL;DR — Use this Google Sheets template to very quickly track confirmed cases, deaths, and recoveries related to the Coronavirus worldwide.
John Young
Mar 20, 2020
CS.OHLCV — Pull Historical OHLCV Data in Cryptosheets using custom functions
CS.OHLCV — Pull Historical OHLCV Data in Cryptosheets using custom functions
Pull 100,000+ rows of OHLCV data from over 11,000 symbols directly into Excel & Googlesheets using =CS.OHLCV
Chris Ware
Feb 4, 2020
The Coolest Googlesheets Trick for Crypto Data You’ve (probably) never seen
The Coolest Googlesheets Trick for Crypto Data You’ve (probably) never seen
Unleash the worlds most powerful analysis engine on your crypto data for free using Cryptosheets & Google Explore to rapidly create…
Chris Ware
Feb 3, 2020
The shortest article you’ll ever read about Crypto Technical Analysis
The shortest article you’ll ever read about Crypto Technical Analysis
How fast can you pull multi-period SMA, volatility, percentage change and variance indicators — for any combination of crypto pairs at any…
Chris Ware
Jan 30, 2020
Cryptosheets 2.0 Relaunch!
Cryptosheets 2.0 Relaunch!
Announcing Cryptosheets 2.0 for Excel & Googlesheets — Crypto Data Just Got Easy
John Young
Jan 27, 2020
Bitwise Indices and CryptUnit Earnings now available in Cryptosheets
Bitwise Indices and CryptUnit Earnings now available in Cryptosheets
Cryptosheets is now available on Microsoft’s official store, Appsource
John Young
Aug 28, 2018
About Cryptosheets
Latest Stories
Archive
About Medium
Terms
Privacy
Teams