Cryptosheets - Pull cryptocurrency real-time and historical data into Excel or Google Sheets
As cryptocurrency enthusiasts or professionals we either use different tools to track our assets from the portfolio or do our own thing in Excel or Google Sheets. Working with excel sheets gives you more customization capabilities (@nealmcspadden knows this better) and you can track your cryptocurrencies the way that you want and you can try different calculations, arbitrage opportunities, comparison, returns or any other analysis.
As I am also an excel sheet user, I stumbled upon Cryptosheets which is an Excel or Google Sheets plugin that pull real-time and historical data into Excel in seconds from hundreds of data sources and providers. You don't need any programming skills to make use of it or to understand the links behind it and you have on hand formulas or widgets to retrieve and analyze anything you need on your cryptocurrencies. It offers a Free Forever subscription along with other paid ones, which is limited to 1,000 Monthly Requests which might be good enough for common activities.
Cryptosheets offers an impressive number of features through which the following are most important:
- Over 7,000 cryptocurrency assets
- Over 800 exchanges
- Over 500 unique providers
- Live API consoles for testing
- Powerful custom functions
- Customizable workspaces
- Dashboard widgets
- Smart lookup
- Integrated research
- Load sample templates no downloads required
- Browse charts and load data instantly
- Import your portfolio or trading account
The addon provides use cases for any kind of user:
- Investor
- Analyst
- Journalist
- Trader
- Portfolio Management
- Accountant
- Hobbyist
- Student
It brings numerous benefits, through which some important ones are:
- Mix and match to compare data sources
- No downloads required
- Access everything from one place
- Leverage the unparalleled power of Excel
- Use powerful new generation custom functions
- Use on any device or OS (Mac, iOS, Windows, Online)
To use it you need to use an e-mail address and that should do it. Adjacently you can make use of templates or use them for later use which is quite great because this can be shared between users. Pretty powerful to be able to bring the data at your fingertips and be able to perform live calculations or any other computations based on that. A simple example can be seen at
I think this can enhance anyone's use of the sheets tracking and being able to get live price data or any other information on it. Instead of manually checking prices on different sites and bringing them where your data is sometimes is time consuming and usually might not be kept updated. This avoids that and brings live information which can be used for different purposes. Hopefully this helps and you can enrich your cryptocurrency analys, tracking and portfolio management.
Posted Using LeoFinance Beta
https://twitter.com/behiver1/status/1332233453698502657
I must say that it was kind of frustrating to go on different sites just to get some calcutions right, must times I waste hours and even before I could complete it, the prices and every other data might have experienced a change and then I have to start all over.
I think I will try this method and see where it goes, hopefully it works better, thanks for letting this in...
Posted Using LeoFinance Beta
I feel you on this and hopefully this helps. I mostly use excel as well for different arbitrage calculations or other cryptocurrencies analysis from my portfolio - like earning per day and so forth - and I find it useful.
Posted Using LeoFinance Beta
Thanks for this.
Really useful info. I've bookmarked it.
Yes, we all love our excel calculations and this help us with that. I've started using such plugins when doing sports arbitrage from my excel sheets and it is pretty cool what such integrations can do.
Posted Using LeoFinance Beta
This is cool.
Will check it out!
Thanks for sharing.
Posted Using LeoFinance Beta
It brings more power to excel users, live crypto feed to get all your calculations right.
Posted Using LeoFinance Beta
This is a really useful information and educative for all.
Although I do not really know anything about excel as I do not love it at all but with your detailed explanation about the Cryptosheets, it looks simple and has a lot of benefits.
Posted Using LeoFinance Beta