Introducing Cryptosheets: Real-time Excel Add-in for Cryptocurrencies
After many months of hard work, failures, firings, and question marks, I’m excited to finally announce Cryptosheets! 👌
Cryptosheets is the first Excel add-in for cryptocurrencies that:
- Pulls real-time quotes, OHLCV, and trades from over 95+ different exchanges, 3,000+ assets and 11,000+ symbols
- Pulls the entire 1,700+ cryptocurrency library of CoinMarketCap
- Up to 5 years worth of Open/High/Low/Close/Volume (OHLCV) data from Cryptocompare
Why does this matter? ❓
We have an entire generation of brilliant financial analysts, traders, investors, portfolio managers (the list goes on and on) who live and die within Excel.
These talented individuals are wizards in Excel from many years of use, but will never learn how to code.
Cryptosheets use cases:
- Backtesting trading strategies
- Portfolio valuation and optimization
- Risk management
- Research and analysis
- Third-party integrations
- Technical analysis
- Much, much more
Cryptocurrencies are a new asset class. A mountain of knowledge from trading and investing is immediately portable over to digital assets. Cryptosheets aims to ease this transition of knowledge.
The solution: A smarter, faster add-in built specifically for cryptocurrencies
We want to save thousands of hours of Copy->Paste->Spot Check->Pray. A few simple clicks through our interface and you will get whatever data your heart desires. ❤️
Initially we will connect CoinMarketCap, Cryptocompare, and CoinAPI. A large portion of our development resources will be spent integrating the data providers that our users request. 💨
Now ready for your feedback 🎧
Cryptosheets is live on Microsoft Appsource and during phase 1 we will be working relentlessly on speed, efficiency, reliability, and enhancements…all of which your feedback is absolutely critical.
Please do not hesitate to report any bugs you found, or give us any feature requests that you want to see implemented. Feature requests are voted on by users and built based on demand.
How to Install
Follow the steps below for your version of Excel and operating system.
Download from Appsource
Click here and click the button “Get it now”.
Excel 2016 for Windows
Please install the Cryptosheets add-in for Excel, using the following instructions:
- Open Microsoft Excel 2016.
- Select Blank Workbook.
- Go to Insert > My Add-ins.
- In the popup window, choose Store.
- Type Cryptosheets in the search box.
- Choose Cryptosheets.
- Take a moment to look at the Store page to familiarize yourself with the add-in.
- Choose Add to install the add-in.
Excel for Mac
- Open Excel for Mac
- Select Blank Workbook.
- Go to Insert > Store.
- Type Cryptosheets in the search box.
- Choose Cryptosheets.
- Take a moment to look at the Store page to familiarize yourself with the add-in.
- Choose Add to install the add-in.
Excel Online
- Head to https://office.live.com/start/Excel.aspx
- Sign in to your Office 365 account
- Select New Blank Workbook.
- Go to Insert > Office Add-ins.
- In the popup window, choose Store.
- Type Cryptosheets in the search box.
- Choose Cryptosheets.
- Take a moment to look at the Store page to familiarize yourself with the add-in.
- Choose Add to install the add-in.
View Dashboard
“Dashboard” in the ribbon is how you access all current connected data within Cryptosheets.
Pulling your first data source
The dashboard is where all data sources that have been pulled are stored. Right now you do not have anything yet, so click the orange “+” button to get started:
Cryptocompare
Full tutorial located here: https://intercom.help/cryptosheets/tutorials/cryptocompare-tutorials/how-to-pull-ohlcv-for-thousands-of-cryptocurrencies-directly-into-excel
- Click the “View Dashboard” in the ribbon
- Click the orange “+” symbol at the bottom right of home
- Click Cryptocompare OHLCV
- Choose Asset, Currency, Days Selected, and Refresh
- Make sure your cursor is in cell A1, and click the “Highlight Range” button
- Verify the data will not overwrite any existing cells, and click Place Data
- Data will be pasted into cell A1 of your worksheet
CoinMarketCap
Full tutorial located here: https://intercom.help/cryptosheets/cryptosheets-concepts/data-integrations/coinmarketcap
- Click the “View Dashboard” in the ribbon
- Click the orange “+” symbol at the bottom right of home
- Click CoinMarketCap Ticker
- Make sure your cursor is in cell A1, and click the “Highlight Range” button
- Verify the data will not overwrite any existing cells, and click Place Data
- Data will be pasted into cell A1 of your worksheet
Real-time Quotes
Common Issues and Solutions
Bitdefender
Bitdefender can sometimes block access to Internet Explorer unknowingly to the user. Make sure that Internet Explorer is a trusted application within the program.
More information: https://www.bitdefender.com/support/i-cannot-connect-to-the-internet-865.html?referrer=https%3A%2F%2Fwww.google.com%2F
We are here to help!
Send us a message from within the add-in, and we will help you get started!