Cryptosheets Da...

Unified Data Ac...

Data Sources

Custom Function...

Data Access

Adding New Data...

## 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](https://app.cryptosheets.com/#/browse) 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](https://app.cryptosheets.com/#/uni) to all integrated data sources
- Unified crypto asset [symbology database](/functions/symbols/), taxonomy and metrics library
- [Global search tool set](https://intercom.help/cryptosheets/en/articles/3453231-navigating-cryptosheets-how-to-search) to easily navigate and filter for specific [metrics or data points](https://docs.cryptosheets.com/functions/fields) from over 1.25mm unique fields
- [Global transformations](functions/common/), filters, formatting and [technical indicators](/functions/technical-indicators/) usable with any data
- Identical app for data access in Excel Google Sheets and the [web](https://app.cryptosheets.com)

> 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

1. **Cryptosheets ['core' data](/functions/core/)**
     used as a global default for easiest possible access for all user levels.
     - Driven by natively integrated market data from [Coinapi.io](https://coinapi.io) as the default
     - Driven by natively integrated data from [ParadigmAPI.com](https://docs.paradigmapi.com) for specific advanced data sets
     - Driven by user specified overrides for the [CS.PRICEA custom function](https://docs.cryptosheets.com/functions/pricea/#pricea---examples) including support for CoinGecko, CryptoCompare & Messari as defaults in addition to the 314+ exchanges & global VWAPs from Coinapi.io

2. **Cryptosheets ['global' data](/providers/)**
     - Driven by any and all other [integrated data providers](/providers/) on the platform using the [API Console](https://docs.cryptosheets.com/cryptosheets-concepts/api-console/), [UniConsole](https://docs.cryptosheets.com/cryptosheets-concepts/uniconsole/) and [CS.QUERY](https://docs.cryptosheets.com/functions/query) or [CS.QUERYA](https://docs.cryptosheets.com/functions/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](https://docs.cryptosheets.com/functions)** (aka formulas) including the ability for each to define specific data providers & sources (ie global VWAP default, exchanges, API providers).

<div class="markdown">


| **functionality** | **[EXRATE](https://docs.cryptosheets.com/functions/streaming)** | **[PRICE](https://docs.cryptosheets.com/functions/price)** | **[PRICEA](https://docs.cryptosheets.com/functions/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 314+ exchanges](https://docs.cryptosheets.com/metadata)**                                                        | ❌                            | ✅                          | ✅                          |
| specific **[pricing from over 572+ exchanges](https://docs.cryptosheets.com/metadata)**                                                        | ❌                            | ❌                          | ✅                          |
| [**default price source overrides** (for CoinGecko, CryptoCompare, Messari)](https://docs.cryptosheets.com/functions/pricea)                           | ❌                            | ❌                          | ✅                          |
| **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) | ❌                            | ❌                          | ✅                          |

</div>

> **[See the full help center article on CS.EXRATE vs CS.PRICE vs CS.PRICEA here](https://intercom.help/cryptosheets/en/articles/4448907-what-s-the-difference-between-cs-exrate-vs-cs-price-vs-cs-pricea)**


### 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](https://intercom.help/cryptosheets/en/articles/3712972-adding-activating-crypto-api-data-providers-to-your-cryptosheets-integrations).

There are 4 main categories of data access on the Cryptosheets platform

1. **[Normal Data Provider](/providers/)**
     - Standard public APIs, endpoints and basic authorization including RESTful, GraphQL, Websocket & FIX*
     - Basic dedicated documentation for endpoints & limited help center support 

2. **[Integrated Data Provider](/providers/)**
     - Secure, stable access to full provider APIs including premium and authorized endpoints
     - Enhanced dedicated documentation for endpoints, templates, help center support & [YouTube tutorials](https://www.youtube.com/channel/UCReKkrBSlgKgNJlWHLASiPQ)
     - Basic user discounts on paid subscriptions

3. **[Advanced Data Provider](/providers/)**
     - For sensitive, secure and personal user data including exchanges, portfolios & wallets 
     - Enhanced dedicated documentation for endpoints, templates, help center support & [YouTube tutorials](https://www.youtube.com/channel/UCReKkrBSlgKgNJlWHLASiPQ)
     - Automatic user discounts on paid subscriptions
     - Natively integrated secure storage for user API keys, tokens and other authorization credentials

4. **[Custom Data Integration](https://cryptosheets.com/pricing)**
     - 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](https://www.youtube.com/channel/UCReKkrBSlgKgNJlWHLASiPQ)
     - 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

1. Cryptosheets data [provider pipeline](https://app.cryptosheets.com/#/resources/changelog)
2. User requests
   Priority is given and assigned to requests:
   - From users with [paid subscriptions](https://cryptosheets.com/pricing)
   - From Teams and group accounts
   - From users with long term paid subscriptions & relationships
   - Custom enterprise and corporate integrations 








Understanding how to use different data sources in Cryptosheets