> Real-time crypto market cap rankings, historical prices, charts, all-time highs, supply data & more for top cryptocurrencies like Bitcoin (BTC) & Ethereum (ETH). Find examples for accessing every **Nomics** endpoint using **Cryptosheets** through: - `side panel console` - `custom functions` (Excel & Googlesheets) - `templates` ## Excel

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | -------- | ----------- | | Try It | [Docs](/providers/nomics/currencies-ticker) | **Currencies Ticker** | =CS.QUERY("Nomics","Currencies Ticker") | =CS.PARAMETERS("Nomics","Currencies Ticker") | 4 | | Try It | [Docs](/providers/nomics/currencies) | **currencies** | =CS.QUERY("Nomics","currencies") | =CS.PARAMETERS("Nomics","currencies") | 0 | | Try It | [Docs](/providers/nomics/prices) | **prices** | =CS.QUERY("Nomics","prices") | =CS.PARAMETERS("Nomics","prices") | 0 | | Try It | [Docs](/providers/nomics/dashboard) | **dashboard** | =CS.QUERY("Nomics","dashboard") | =CS.PARAMETERS("Nomics","dashboard") | 0 | | Try It | [Docs](/providers/nomics/currencies-interval) | **Currencies Interval** | =CS.QUERY("Nomics","Currencies Interval") | =CS.PARAMETERS("Nomics","Currencies Interval") | 2 | | Try It | [Docs](/providers/nomics/currencies-metadata) | **Currencies Metadata** | =CS.QUERY("Nomics","Currencies Metadata") | =CS.PARAMETERS("Nomics","Currencies Metadata") | 3 | | Try It | [Docs](/providers/nomics/currencies-sparkline) | **Currencies Sparkline** | =CS.QUERY("Nomics","Currencies Sparkline") | =CS.PARAMETERS("Nomics","Currencies Sparkline") | 4 | | Try It | [Docs](/providers/nomics/markets) | **markets** | =CS.QUERY("Nomics","markets") | =CS.PARAMETERS("Nomics","markets") | 4 | | Try It | [Docs](/providers/nomics/market-cap-history) | **Market Cap History** | =CS.QUERY("Nomics","Market Cap History") | =CS.PARAMETERS("Nomics","Market Cap History") | 4 | | Try It | [Docs](/providers/nomics/global-volume-history) | **Global Volume History** | =CS.QUERY("Nomics","Global Volume History") | =CS.PARAMETERS("Nomics","Global Volume History") | 4 | | Try It | [Docs](/providers/nomics/exchange-rates) | **Exchange Rates** | =CS.QUERY("Nomics","Exchange Rates") | =CS.PARAMETERS("Nomics","Exchange Rates") | 1 | | Try It | [Docs](/providers/nomics/exchange-rates-history) | **Exchange Rates History** | =CS.QUERY("Nomics","Exchange Rates History") | =CS.PARAMETERS("Nomics","Exchange Rates History") | 4 | | Try It | [Docs](/providers/nomics/exchange-rates-interval) | **Exchange Rates Interval** | =CS.QUERY("Nomics","Exchange Rates Interval") | =CS.PARAMETERS("Nomics","Exchange Rates Interval") | 2 | | Try It | [Docs](/providers/nomics/aggregated-ohlcv-candles) | **Aggregated OHLCV Candles** | =CS.QUERY("Nomics","Aggregated OHLCV Candles") | =CS.PARAMETERS("Nomics","Aggregated OHLCV Candles") | 6 | | Try It | [Docs](/providers/nomics/exchange-ohlcv-candles) | **Exchange OHLCV Candles** | =CS.QUERY("Nomics","Exchange OHLCV Candles") | =CS.PARAMETERS("Nomics","Exchange OHLCV Candles") | 6 | | Try It | [Docs](/providers/nomics/aggregated-pair-ohlcv-candles) | **Aggregated Pair OHLCV Candles** | =CS.QUERY("Nomics","Aggregated Pair OHLCV Candles") | =CS.PARAMETERS("Nomics","Aggregated Pair OHLCV Candles") | 6 | | Try It | [Docs](/providers/nomics/trades) | **Trades** | =CS.QUERY("Nomics","Trades") | =CS.PARAMETERS("Nomics","Trades") | 6 | | Try It | [Docs](/providers/nomics/order-book-snapshot) | **Order Book Snapshot** | =CS.QUERY("Nomics","Order Book Snapshot") | =CS.PARAMETERS("Nomics","Order Book Snapshot") | 4 | | Try It | [Docs](/providers/nomics/supply-history) | **Supply History** | =CS.QUERY("Nomics","Supply History") | =CS.PARAMETERS("Nomics","Supply History") | 4 | | Try It | [Docs](/providers/nomics/exchanges-ticker) | **Exchanges Ticker** | =CS.QUERY("Nomics","Exchanges Ticker") | =CS.PARAMETERS("Nomics","Exchanges Ticker") | 4 | | Try It | [Docs](/providers/nomics/exchanges-metadata) | **Exchanges Metadata** | =CS.QUERY("Nomics","Exchanges Metadata") | =CS.PARAMETERS("Nomics","Exchanges Metadata") | 3 | | Try It | [Docs](/providers/nomics/exchange-markets-ticker) | **Exchange Markets Ticker** | =CS.QUERY("Nomics","Exchange Markets Ticker") | =CS.PARAMETERS("Nomics","Exchange Markets Ticker") | 7 | | Try It | [Docs](/providers/nomics/currency-predictions-ticker) | **Currency Predictions Ticker** | =CS.QUERY("Nomics","Currency Predictions Ticker") | =CS.PARAMETERS("Nomics","Currency Predictions Ticker") | 2 | | Try It | [Docs](/providers/nomics/currency-predictions-history) | **Currency Predictions History** | =CS.QUERY("Nomics","Currency Predictions History") | =CS.PARAMETERS("Nomics","Currency Predictions History") | 3 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/nomics/currencies-ticker) | **Currencies Ticker** | =CSQUERY("Nomics","Currencies Ticker") | =CSPARAMETERS("Nomics","Currencies Ticker") | 4 | | Try It | [Docs](/providers/nomics/currencies) | **currencies** | =CSQUERY("Nomics","currencies") | =CSPARAMETERS("Nomics","currencies") | 0 | | Try It | [Docs](/providers/nomics/prices) | **prices** | =CSQUERY("Nomics","prices") | =CSPARAMETERS("Nomics","prices") | 0 | | Try It | [Docs](/providers/nomics/dashboard) | **dashboard** | =CSQUERY("Nomics","dashboard") | =CSPARAMETERS("Nomics","dashboard") | 0 | | Try It | [Docs](/providers/nomics/currencies-interval) | **Currencies Interval** | =CSQUERY("Nomics","Currencies Interval") | =CSPARAMETERS("Nomics","Currencies Interval") | 2 | | Try It | [Docs](/providers/nomics/currencies-metadata) | **Currencies Metadata** | =CSQUERY("Nomics","Currencies Metadata") | =CSPARAMETERS("Nomics","Currencies Metadata") | 3 | | Try It | [Docs](/providers/nomics/currencies-sparkline) | **Currencies Sparkline** | =CSQUERY("Nomics","Currencies Sparkline") | =CSPARAMETERS("Nomics","Currencies Sparkline") | 4 | | Try It | [Docs](/providers/nomics/markets) | **markets** | =CSQUERY("Nomics","markets") | =CSPARAMETERS("Nomics","markets") | 4 | | Try It | [Docs](/providers/nomics/market-cap-history) | **Market Cap History** | =CSQUERY("Nomics","Market Cap History") | =CSPARAMETERS("Nomics","Market Cap History") | 4 | | Try It | [Docs](/providers/nomics/global-volume-history) | **Global Volume History** | =CSQUERY("Nomics","Global Volume History") | =CSPARAMETERS("Nomics","Global Volume History") | 4 | | Try It | [Docs](/providers/nomics/exchange-rates) | **Exchange Rates** | =CSQUERY("Nomics","Exchange Rates") | =CSPARAMETERS("Nomics","Exchange Rates") | 1 | | Try It | [Docs](/providers/nomics/exchange-rates-history) | **Exchange Rates History** | =CSQUERY("Nomics","Exchange Rates History") | =CSPARAMETERS("Nomics","Exchange Rates History") | 4 | | Try It | [Docs](/providers/nomics/exchange-rates-interval) | **Exchange Rates Interval** | =CSQUERY("Nomics","Exchange Rates Interval") | =CSPARAMETERS("Nomics","Exchange Rates Interval") | 2 | | Try It | [Docs](/providers/nomics/aggregated-ohlcv-candles) | **Aggregated OHLCV Candles** | =CSQUERY("Nomics","Aggregated OHLCV Candles") | =CSPARAMETERS("Nomics","Aggregated OHLCV Candles") | 6 | | Try It | [Docs](/providers/nomics/exchange-ohlcv-candles) | **Exchange OHLCV Candles** | =CSQUERY("Nomics","Exchange OHLCV Candles") | =CSPARAMETERS("Nomics","Exchange OHLCV Candles") | 6 | | Try It | [Docs](/providers/nomics/aggregated-pair-ohlcv-candles) | **Aggregated Pair OHLCV Candles** | =CSQUERY("Nomics","Aggregated Pair OHLCV Candles") | =CSPARAMETERS("Nomics","Aggregated Pair OHLCV Candles") | 6 | | Try It | [Docs](/providers/nomics/trades) | **Trades** | =CSQUERY("Nomics","Trades") | =CSPARAMETERS("Nomics","Trades") | 6 | | Try It | [Docs](/providers/nomics/order-book-snapshot) | **Order Book Snapshot** | =CSQUERY("Nomics","Order Book Snapshot") | =CSPARAMETERS("Nomics","Order Book Snapshot") | 4 | | Try It | [Docs](/providers/nomics/supply-history) | **Supply History** | =CSQUERY("Nomics","Supply History") | =CSPARAMETERS("Nomics","Supply History") | 4 | | Try It | [Docs](/providers/nomics/exchanges-ticker) | **Exchanges Ticker** | =CSQUERY("Nomics","Exchanges Ticker") | =CSPARAMETERS("Nomics","Exchanges Ticker") | 4 | | Try It | [Docs](/providers/nomics/exchanges-metadata) | **Exchanges Metadata** | =CSQUERY("Nomics","Exchanges Metadata") | =CSPARAMETERS("Nomics","Exchanges Metadata") | 3 | | Try It | [Docs](/providers/nomics/exchange-markets-ticker) | **Exchange Markets Ticker** | =CSQUERY("Nomics","Exchange Markets Ticker") | =CSPARAMETERS("Nomics","Exchange Markets Ticker") | 7 | | Try It | [Docs](/providers/nomics/currency-predictions-ticker) | **Currency Predictions Ticker** | =CSQUERY("Nomics","Currency Predictions Ticker") | =CSPARAMETERS("Nomics","Currency Predictions Ticker") | 2 | | Try It | [Docs](/providers/nomics/currency-predictions-history) | **Currency Predictions History** | =CSQUERY("Nomics","Currency Predictions History") | =CSPARAMETERS("Nomics","Currency Predictions History") | 3 |

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less **Get Cryptosheets for Microsoft Excel** **Get Cryptosheets for Googlesheets** \*Note: you must have one of the [supported versions](https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture) of Microsoft Office or Excel for custom functions to work **Click here** for additional documentation from Nomics Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `Nomics` `provider`