Data Sources
Cryptosheets Data Sources
Cryptosheets takes a novel approach to promoting data access and transparency for the community. Users have unparalleled flexibility and visibility to access the largest combined crypto data set anywhere by maximizing the available number of unique data sources, types and styles through a simple and single access point.
Unified Data Access
- Proprietary unified access interface to all integrated data sources
- Unified crypto asset symbology database, taxonomy and metrics library
- Global search tool set to easily navigate and filter for specific metrics or data points from over 1.25mm unique fields
- Global transformations, filters, formatting and technical indicators usable with any data
- Identical app for data access in Excel Google Sheets and the web
Crypto and blockchain data represent a new paradigm relative to traditional financial markets data but Cryptosheets also supports over 250,000+ capital markets assets including stocks, bonds, ETFs, commodities etc
Data Sources
There are two main categories of data sources on the Cryptosheets platform
-
Cryptosheets 'core' data used as a global default for easiest possible access for all user levels.
- Driven by natively integrated market data from Coinapi.io as the default
- Driven by natively integrated data from ParadigmAPI.com for specific advanced data sets
- Driven by user specified overrides for the CS.PRICEA custom function including support for CoinGecko, CryptoCompare & Messari as defaults in addition to the 331+ exchanges & global VWAPs from Coinapi.io
-
Cryptosheets 'global' data
- Driven by any and all other integrated data providers on the platform using the API Console, UniConsole and CS.QUERY or CS.QUERYA custom functions
Custom Function Comparison
Below is a detailed comparison of the different features and capabilities of three of the most commonly used Cryptosheets custom functions (aka formulas) including the ability for each to define specific data providers & sources (ie global VWAP default, exchanges, API providers).
functionality | EXRATE | PRICE | PRICEA |
---|---|---|---|
live current price | ✅ | ✅ | ✅ |
live, streaming prices (streaming for Excel only) | ✅ | ❌ | ❌ |
live, automatic custom refresh (using CS.TIME in Excel only) | ❌ | ✅ | ✅ |
built-in native refresh as a parameter | ✅ | ❌ | ❌ |
global VWAP as default/fallback | ✅ | ✅ | ✅ |
specific pricing from over 331+ exchanges | ❌ | ✅ | ✅ |
specific pricing from over 572+ exchanges | ❌ | ❌ | ✅ |
default price source overrides | ❌ | ❌ | ✅ |
historical prices by date/time | ❌ | ✅ | ✅ |
supports single string symbolId parameter | ❌ | ❌ | ✅ |
supports the source parameter | ❌ | ❌ | ✅ |
market price type (bid/mid/ask) | ❌ | ✅ | ✅ |
derivatives live, current pricing (futures, options, perpetuals, swaps, index, credit) | ❌ | ❌ | ✅ |
derivatives historical pricing by date/time (futures, options, perpetuals, swaps, index, credit) | ❌ | ❌ | ✅ |
See the full help center article on CS.EXRATE vs CS.PRICE vs CS.PRICEA here
Data Access
Cryptosheets is specifically designed to be as flexible as possible to adopt to the constantly changing crypto data landscape. This gives our users adequate data redundancy, security and accessible resources to adjust to future data provider changes including payment models, accuracy of data and corporate merger & acquisition activity. Existing economics, credentials and permissions for users of integrated providers are fully preserved at the user and/or endpoint levels & can flow through manually, automatically or through active integrations. Cryptosheets makes it easy to add & activate your existing data providers.
There are 4 main categories of data access on the Cryptosheets platform
-
- Standard public APIs, endpoints and basic authorization including RESTful, GraphQL, Websocket & FIX*
- Basic dedicated documentation for endpoints & limited help center support
-
- Secure, stable access to full provider APIs including premium and authorized endpoints
- Enhanced dedicated documentation for endpoints, templates, help center support & YouTube tutorials
- Basic user discounts on paid subscriptions
-
- For sensitive, secure and personal user data including exchanges, portfolios & wallets
- Enhanced dedicated documentation for endpoints, templates, help center support & YouTube tutorials
- Automatic user discounts on paid subscriptions
- Natively integrated secure storage for user API keys, tokens and other authorization credentials
-
- For real time trading execution, order flow and risk management for professionals and institutional investors
- Custom dedicated documentation for endpoints, templates, help center support & YouTube tutorials
- Custom API endpoints and custom functions
- Dedicated infrastructure integration for secure storage of advanced authorization credentials & schemas
*FIX connectivity only supported in custom integrations for enterprise accounts
Adding New Data Sources
- Cryptosheets data provider pipeline
- User requests
Priority is given and assigned to requests:
- From users with paid subscriptions
- From Teams and group accounts
- From users with long term paid subscriptions & relationships
- Custom enterprise and corporate integrations