Published in · 5 min read · Aug 3, 2018
--
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
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.
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. 💨
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.
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.
“Dashboard” in the ribbon is how you access all current connected data within Cryptosheets.
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
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
Send us a message from within the add-in, and we will help you get started!
Greetings, enthusiasts and professionals in the world of cryptocurrencies and financial data analysis! As someone deeply entrenched in the realm of digital assets and data integration, I bring to your attention an exciting development that is sure to revolutionize the way you interact with cryptocurrency data: Cryptosheets.
My extensive expertise in the field allows me to attest to the significance of Cryptosheets as the first-ever Excel add-in specifically designed for cryptocurrencies. This groundbreaking tool seamlessly integrates real-time quotes, OHLCV data, and trades from over 95+ different exchanges, covering a staggering 3,000+ assets and 11,000+ symbols. Notably, it incorporates the entire cryptocurrency library of CoinMarketCap and provides up to 5 years worth of Open/High/Low/Close/Volume (OHLCV) data from Cryptocompare.
The developers behind Cryptosheets understand the unique needs of financial analysts, traders, investors, and portfolio managers who have mastered Excel but may not possess coding skills. This Excel add-in caters to a diverse range of use cases, including backtesting trading strategies, portfolio valuation and optimization, risk management, research and analysis, technical analysis, and much more.
Cryptocurrencies represent a relatively new asset class, and Cryptosheets aims to facilitate the transfer of traditional financial knowledge to the realm of digital assets. The platform's intuitive interface allows users to save countless hours by streamlining processes that often involve tedious tasks like Copy->Paste->Spot Check->Pray.
The add-in currently connects with major data providers such as CoinMarketCap, Cryptocompare, and CoinAPI, with plans to integrate additional providers based on user demand. The live presence on Microsoft Appsource indicates the commitment to continuous improvement, with a focus on speed, efficiency, reliability, and enhancements during the initial phase.
Now, let's delve into some essential concepts related to Cryptosheets, as outlined in the article:
-
Installation Instructions:
- The article provides detailed instructions for installing Cryptosheets on different versions of Excel and operating systems, including Excel 2016 for Windows, Excel for Mac, and Excel Online.
-
Dashboard and Data Sources:
- The "Dashboard" in the ribbon is the central hub for accessing all connected data within Cryptosheets.
- Data sources pulled by the tool are stored in the dashboard, and users can initiate the process by clicking the orange "+" button.
-
Integration with Cryptocompare:
- The article offers a link to a full tutorial on pulling OHLCV data for thousands of cryptocurrencies directly into Excel using Cryptosheets and Cryptocompare.
- Steps include selecting the Cryptocompare OHLCV option, choosing assets, currencies, days selected, and initiating the data import process.
-
Integration with CoinMarketCap:
- A tutorial link is provided for integrating CoinMarketCap data into Excel using Cryptosheets.
- Similar to Cryptocompare, users can choose CoinMarketCap Ticker, select relevant options, and import data into Excel.
-
Real-time Quotes and Bitdefender Compatibility:
- The article addresses potential compatibility issues with Bitdefender, offering information on ensuring that Internet Explorer is a trusted application within the program.
- Users encountering issues are encouraged to send a message from within the add-in for assistance.
In conclusion, Cryptosheets emerges as a powerful tool catering to the diverse needs of Excel-savvy financial professionals in the cryptocurrency space. Its comprehensive features and commitment to user feedback make it a valuable addition to the toolkit of anyone involved in cryptocurrency trading, analysis, and portfolio management.