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

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 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
  2. Cryptosheets 'global' data

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).

functionalityEXRATEPRICEPRICEA
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

  1. Normal Data Provider

    • 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

    • 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
  3. Advanced Data Provider

    • 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
  4. Custom Data Integration

    • 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

  1. Cryptosheets data provider pipeline
  2. 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