(click to enlarge)
This article covers how to get setup with Cryptosheets in Googlesheets so you can start using the app right now. It also covers some of the primary differences across Excel and Googlesheets to help get you started including:
- General setup and integration
- Custom Functions
- Data Limitations
Is and always has been to create a single unified experience for users across both Excel and Googlesheets. We are ultimately limited in certain areas re: specific functionality given the respective restrictions and capabilities of each platform, respectively.
The GOOD NEWS:
- The reality is both platforms continue to backfill eachothers flagship features more and more every day from macros to pivot tables to online sharing, autosaving and pretty much everything else.
- The flexibility to leverage the best features of Excel and Googlesheets from within Cryptosheets at anytime provides a powerful tool set for users
▶︎ BOTTOM LINE: THIS IS ALL VERY POSITIVE FOR CRYPTOSHEETS USERS!
▶︎ General setup and integration (Googlesheets)
Follow the normal steps to install a Google add-on:
- Going to the add-ons menu from your Googlesheet
- Get add-ons
- Type "cryptosheets" in the search bar in GSuite Marketplace
- Go back to the add-ons menu
Launch Sidebar from the Cryptosheets menu
*Note: you may need to refresh your browser window if you don't see the Launch Sidebar option the first time
FEATURE COMPARISON (OVERVIEW)
▶︎ Custom Functions
Using Cryptosheets custom functions in Excel vs Googlesheets is almost exactly the same with a few very slight differences. The most important one is that in Excel there is a "." (period) between the
CS and the
functionName so =CS.QUERY().
In Googlesheets there is NO "." (period) after the CS so the formula is simply =CSQUERY()
As of January 2020 - Googlesheets also does not yet support full streaming real time data through =CS.EXRATE like Excel does. We expect this to change in the near future so stay tuned to our changelog and join our mailing list a for a coming announcement...
▶︎ Data Limitations
Most data limitations in Cryptosheets are set by:
- Your subscription level
- Your local hardware, software and internet connection
Googlesheets also imposes additional restrictions in daily user data usage that Excel does not.
(excerpt from: https://developers.google.com/apps-script/guides/services/quotas)
"(Google) Apps Script services impose daily quotas and hard limitations on some features. If you exceed a quota or limitation, your script throws an exception and execution terminates.
Quotas are set at different levels for users of consumer accounts (such as gmail.com) and G Suite free edition (discontinued), or different G Suite editions.
Daily quotas are refreshed at the end of a 24-hour window; the exact time of this refresh, however, varies between users."
Cryptosheets uses next generation template protocol from Microsoft that allows Excel users to instantly load entire complex models, dashboards, charts and templates with one click from the side panel --- without having to download any files, workbooks or scripts!
You can access Googlesheets versions of these templates which will be continuously rolled out in the near term
Beginning in February 2020, Googlesheets users will be able to access a limited number of Cryptosheets templates directly through customary shared Googlehseet links. They can then save their own copies and adjust them however they like.
Cryptosheets is free to sign up and start using now. What are you waiting for?
Signing up for Cryptosheets is free --> Get crypto data in 30 seconds or less
TAGS : excel, googlesheets, spreadsheet, crypto data, bitcoin, blockchain, tutorial, help, support