> Crypto & Blockchain non-custodial wallet solutions for Crypto exchanges, Crypto wallets, Payment Processors with Blockchain APIs Find examples for accessing every **CryptoAPIs** 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/cryptoapis/list-all-symbols-supported-in-exchange) | **List All Symbols supported in exchange** | =CS.QUERY("CryptoAPIs","List All Symbols supported in exchange") | =CS.PARAMETERS("CryptoAPIs","List All Symbols supported in exchange") | 4 | | Try It | [Docs](/providers/cryptoapis/list-all-assets-meta) | **List All Assets Meta** | =CS.QUERY("CryptoAPIs","List All Assets Meta") | =CS.PARAMETERS("CryptoAPIs","List All Assets Meta") | 4 | | Try It | [Docs](/providers/cryptoapis/list-all-assets) | **List All Assets** | =CS.QUERY("CryptoAPIs","List All Assets") | =CS.PARAMETERS("CryptoAPIs","List All Assets") | 1 | | Try It | [Docs](/providers/cryptoapis/get-asset-details) | **Get Asset Details** | =CS.QUERY("CryptoAPIs","Get Asset Details") | =CS.PARAMETERS("CryptoAPIs","Get Asset Details") | 2 | | Try It | [Docs](/providers/cryptoapis/list-all-symbols) | **List All Symbols** | =CS.QUERY("CryptoAPIs","List All Symbols") | =CS.PARAMETERS("CryptoAPIs","List All Symbols") | 1 | | Try It | [Docs](/providers/cryptoapis/get-symbol-details) | **Get Symbol Details** | =CS.QUERY("CryptoAPIs","Get Symbol Details") | =CS.PARAMETERS("CryptoAPIs","Get Symbol Details") | 2 | | Try It | [Docs](/providers/cryptoapis/get-specific-rate) | **Get Specific Rate** | =CS.QUERY("CryptoAPIs","Get Specific Rate") | =CS.PARAMETERS("CryptoAPIs","Get Specific Rate") | 4 | | Try It | [Docs](/providers/cryptoapis/get-all-current-rates) | **Get All Current Rates** | =CS.QUERY("CryptoAPIs","Get All Current Rates") | =CS.PARAMETERS("CryptoAPIs","Get All Current Rates") | 2 | | Try It | [Docs](/providers/cryptoapis/get-specific-rate-in-a-specific-exchange) | **Get Specific Rate in a Specific Exchange** | =CS.QUERY("CryptoAPIs","Get Specific Rate in a Specific Exchange") | =CS.PARAMETERS("CryptoAPIs","Get Specific Rate in a Specific Exchange") | 5 | | Try It | [Docs](/providers/cryptoapis/get-all-current-rates-in-a-specific-exchange) | **Get All Current Rates in a Specific Exchange** | =CS.QUERY("CryptoAPIs","Get All Current Rates in a Specific Exchange") | =CS.PARAMETERS("CryptoAPIs","Get All Current Rates in a Specific Exchange") | 3 | | Try It | [Docs](/providers/cryptoapis/list-all-periods) | **List All Periods** | =CS.QUERY("CryptoAPIs","List All Periods") | =CS.PARAMETERS("CryptoAPIs","List All Periods") | 1 | | Try It | [Docs](/providers/cryptoapis/latest-data) | **Latest Data** | =CS.QUERY("CryptoAPIs","Latest Data") | =CS.PARAMETERS("CryptoAPIs","Latest Data") | 4 | | Try It | [Docs](/providers/cryptoapis/historical-data) | **Historical Data** | =CS.QUERY("CryptoAPIs","Historical Data") | =CS.PARAMETERS("CryptoAPIs","Historical Data") | 7 | | Try It | [Docs](/providers/cryptoapis/latest-data-by-exchange-and-asset) | **Latest Data By Exchange And Asset** | =CS.QUERY("CryptoAPIs","Latest Data By Exchange And Asset") | =CS.PARAMETERS("CryptoAPIs","Latest Data By Exchange And Asset") | 8 | | Try It | [Docs](/providers/cryptoapis/historical-data-by-exchange) | **Historical Data By Exchange** | =CS.QUERY("CryptoAPIs","Historical Data By Exchange") | =CS.PARAMETERS("CryptoAPIs","Historical Data By Exchange") | 7 | | Try It | [Docs](/providers/cryptoapis/trades-latest-data) | **Trades Latest Data** | =CS.QUERY("CryptoAPIs","Trades Latest Data") | =CS.PARAMETERS("CryptoAPIs","Trades Latest Data") | 1 | | Try It | [Docs](/providers/cryptoapis/trades-latest-data-by-symbol) | **Trades Latest Data by Symbol** | =CS.QUERY("CryptoAPIs","Trades Latest Data by Symbol") | =CS.PARAMETERS("CryptoAPIs","Trades Latest Data by Symbol") | 4 | | Try It | [Docs](/providers/cryptoapis/trades-latest-data-by-exchange) | **Trades Latest Data by Exchange** | =CS.QUERY("CryptoAPIs","Trades Latest Data by Exchange") | =CS.PARAMETERS("CryptoAPIs","Trades Latest Data by Exchange") | 2 | | Try It | [Docs](/providers/cryptoapis/trades-latest-data-by-base-asset) | **Trades Latest Data by Base Asset** | =CS.QUERY("CryptoAPIs","Trades Latest Data by Base Asset") | =CS.PARAMETERS("CryptoAPIs","Trades Latest Data by Base Asset") | 4 | | Try It | [Docs](/providers/cryptoapis/trades-latest-data-by-asset-pair) | **Trades Latest Data by Asset Pair** | =CS.QUERY("CryptoAPIs","Trades Latest Data by Asset Pair") | =CS.PARAMETERS("CryptoAPIs","Trades Latest Data by Asset Pair") | 5 | | Try It | [Docs](/providers/cryptoapis/trades-latest-data-by-exchange-assets-pair) | **Trades Latest Data by Exchange Assets Pair** | =CS.QUERY("CryptoAPIs","Trades Latest Data by Exchange Assets Pair") | =CS.PARAMETERS("CryptoAPIs","Trades Latest Data by Exchange Assets Pair") | 6 | | Try It | [Docs](/providers/cryptoapis/trades-historical-data) | **Trades Historical Data** | =CS.QUERY("CryptoAPIs","Trades Historical Data") | =CS.PARAMETERS("CryptoAPIs","Trades Historical Data") | 4 | | Try It | [Docs](/providers/cryptoapis/trades-historical-data-by-exchange) | **Trades Historical Data by Exchange** | =CS.QUERY("CryptoAPIs","Trades Historical Data by Exchange") | =CS.PARAMETERS("CryptoAPIs","Trades Historical Data by Exchange") | 6 | | Try It | [Docs](/providers/cryptoapis/trades-historical-data-by-base-asset) | **Trades Historical Data by Base Asset** | =CS.QUERY("CryptoAPIs","Trades Historical Data by Base Asset") | =CS.PARAMETERS("CryptoAPIs","Trades Historical Data by Base Asset") | 6 | | Try It | [Docs](/providers/cryptoapis/trades-historical-data-by-asset-pair) | **Trades Historical Data by Asset Pair** | =CS.QUERY("CryptoAPIs","Trades Historical Data by Asset Pair") | =CS.PARAMETERS("CryptoAPIs","Trades Historical Data by Asset Pair") | 5 | | Try It | [Docs](/providers/cryptoapis/trades-historical-data-by-exchange-assets-pair) | **Trades Historical Data by Exchange Assets Pair** | =CS.QUERY("CryptoAPIs","Trades Historical Data by Exchange Assets Pair") | =CS.PARAMETERS("CryptoAPIs","Trades Historical Data by Exchange Assets Pair") | 8 | | Try It | [Docs](/providers/cryptoapis/snapshot-by-symbol) | **Snapshot by symbol** | =CS.QUERY("CryptoAPIs","Snapshot by symbol") | =CS.PARAMETERS("CryptoAPIs","Snapshot by symbol") | 2 | | Try It | [Docs](/providers/cryptoapis/get-node-information) | **Get Node Information** | =CS.QUERY("CryptoAPIs","Get Node Information") | =CS.PARAMETERS("CryptoAPIs","Get Node Information") | 3 | | Try It | [Docs](/providers/cryptoapis/get-block-by-hash) | **Get Block By Hash** | =CS.QUERY("CryptoAPIs","Get Block By Hash") | =CS.PARAMETERS("CryptoAPIs","Get Block By Hash") | 4 | | Try It | [Docs](/providers/cryptoapis/get-address-details) | **Get Address Details** | =CS.QUERY("CryptoAPIs","Get Address Details") | =CS.PARAMETERS("CryptoAPIs","Get Address Details") | 4 | | Try It | [Docs](/providers/cryptoapis/get-basic-transactions-by-address) | **Get Basic Transactions By Address** | =CS.QUERY("CryptoAPIs","Get Basic Transactions By Address") | =CS.PARAMETERS("CryptoAPIs","Get Basic Transactions By Address") | 6 | | Try It | [Docs](/providers/cryptoapis/get-multisig-address-details) | **Get Multisig Address Details** | =CS.QUERY("CryptoAPIs","Get Multisig Address Details") | =CS.PARAMETERS("CryptoAPIs","Get Multisig Address Details") | 4 | | Try It | [Docs](/providers/cryptoapis/get-confirmed-transactions-for-address-by-range) | **Get Confirmed Transactions For Address By Range** | =CS.QUERY("CryptoAPIs","Get Confirmed Transactions For Address By Range") | =CS.PARAMETERS("CryptoAPIs","Get Confirmed Transactions For Address By Range") | 6 | | Try It | [Docs](/providers/cryptoapis/get-confirmed-transactions-by-address) | **Get Confirmed Transactions By Address** | =CS.QUERY("CryptoAPIs","Get Confirmed Transactions By Address") | =CS.PARAMETERS("CryptoAPIs","Get Confirmed Transactions By Address") | 4 | | Try It | [Docs](/providers/cryptoapis/get-unconfirmed-transactions-by-address) | **Get Unconfirmed Transactions By Address** | =CS.QUERY("CryptoAPIs","Get Unconfirmed Transactions By Address") | =CS.PARAMETERS("CryptoAPIs","Get Unconfirmed Transactions By Address") | 4 | | Try It | [Docs](/providers/cryptoapis/get-basic-transaction-details-by-transaction-id) | **Get Basic Transaction Details By Transaction ID** | =CS.QUERY("CryptoAPIs","Get Basic Transaction Details By Transaction ID") | =CS.PARAMETERS("CryptoAPIs","Get Basic Transaction Details By Transaction ID") | 4 | | Try It | [Docs](/providers/cryptoapis/get-transaction-details-by-transaction-id) | **Get Transaction Details By Transaction ID** | =CS.QUERY("CryptoAPIs","Get Transaction Details By Transaction ID") | =CS.PARAMETERS("CryptoAPIs","Get Transaction Details By Transaction ID") | 4 | | Try It | [Docs](/providers/cryptoapis/get-transactions-by-block-number) | **Get Transactions By Block Number** | =CS.QUERY("CryptoAPIs","Get Transactions By Block Number") | =CS.PARAMETERS("CryptoAPIs","Get Transactions By Block Number") | 6 | | Try It | [Docs](/providers/cryptoapis/get-unconfirmed-transactions) | **Get Unconfirmed Transactions** | =CS.QUERY("CryptoAPIs","Get Unconfirmed Transactions") | =CS.PARAMETERS("CryptoAPIs","Get Unconfirmed Transactions") | 5 | | Try It | [Docs](/providers/cryptoapis/get-raw-transaction-hex-by-transaction-id-(txid)) | **Get Raw Transaction Hex By Transaction ID (Txid)** | =CS.QUERY("CryptoAPIs","Get Raw Transaction Hex By Transaction ID (Txid)") | =CS.PARAMETERS("CryptoAPIs","Get Raw Transaction Hex By Transaction ID (Txid)") | 4 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/cryptoapis/list-all-symbols-supported-in-exchange) | **List All Symbols supported in exchange** | =CSQUERY("CryptoAPIs","List All Symbols supported in exchange") | =CSPARAMETERS("CryptoAPIs","List All Symbols supported in exchange") | 4 | | Try It | [Docs](/providers/cryptoapis/list-all-assets-meta) | **List All Assets Meta** | =CSQUERY("CryptoAPIs","List All Assets Meta") | =CSPARAMETERS("CryptoAPIs","List All Assets Meta") | 4 | | Try It | [Docs](/providers/cryptoapis/list-all-assets) | **List All Assets** | =CSQUERY("CryptoAPIs","List All Assets") | =CSPARAMETERS("CryptoAPIs","List All Assets") | 1 | | Try It | [Docs](/providers/cryptoapis/get-asset-details) | **Get Asset Details** | =CSQUERY("CryptoAPIs","Get Asset Details") | =CSPARAMETERS("CryptoAPIs","Get Asset Details") | 2 | | Try It | [Docs](/providers/cryptoapis/list-all-symbols) | **List All Symbols** | =CSQUERY("CryptoAPIs","List All Symbols") | =CSPARAMETERS("CryptoAPIs","List All Symbols") | 1 | | Try It | [Docs](/providers/cryptoapis/get-symbol-details) | **Get Symbol Details** | =CSQUERY("CryptoAPIs","Get Symbol Details") | =CSPARAMETERS("CryptoAPIs","Get Symbol Details") | 2 | | Try It | [Docs](/providers/cryptoapis/get-specific-rate) | **Get Specific Rate** | =CSQUERY("CryptoAPIs","Get Specific Rate") | =CSPARAMETERS("CryptoAPIs","Get Specific Rate") | 4 | | Try It | [Docs](/providers/cryptoapis/get-all-current-rates) | **Get All Current Rates** | =CSQUERY("CryptoAPIs","Get All Current Rates") | =CSPARAMETERS("CryptoAPIs","Get All Current Rates") | 2 | | Try It | [Docs](/providers/cryptoapis/get-specific-rate-in-a-specific-exchange) | **Get Specific Rate in a Specific Exchange** | =CSQUERY("CryptoAPIs","Get Specific Rate in a Specific Exchange") | =CSPARAMETERS("CryptoAPIs","Get Specific Rate in a Specific Exchange") | 5 | | Try It | [Docs](/providers/cryptoapis/get-all-current-rates-in-a-specific-exchange) | **Get All Current Rates in a Specific Exchange** | =CSQUERY("CryptoAPIs","Get All Current Rates in a Specific Exchange") | =CSPARAMETERS("CryptoAPIs","Get All Current Rates in a Specific Exchange") | 3 | | Try It | [Docs](/providers/cryptoapis/list-all-periods) | **List All Periods** | =CSQUERY("CryptoAPIs","List All Periods") | =CSPARAMETERS("CryptoAPIs","List All Periods") | 1 | | Try It | [Docs](/providers/cryptoapis/latest-data) | **Latest Data** | =CSQUERY("CryptoAPIs","Latest Data") | =CSPARAMETERS("CryptoAPIs","Latest Data") | 4 | | Try It | [Docs](/providers/cryptoapis/historical-data) | **Historical Data** | =CSQUERY("CryptoAPIs","Historical Data") | =CSPARAMETERS("CryptoAPIs","Historical Data") | 7 | | Try It | [Docs](/providers/cryptoapis/latest-data-by-exchange-and-asset) | **Latest Data By Exchange And Asset** | =CSQUERY("CryptoAPIs","Latest Data By Exchange And Asset") | =CSPARAMETERS("CryptoAPIs","Latest Data By Exchange And Asset") | 8 | | Try It | [Docs](/providers/cryptoapis/historical-data-by-exchange) | **Historical Data By Exchange** | =CSQUERY("CryptoAPIs","Historical Data By Exchange") | =CSPARAMETERS("CryptoAPIs","Historical Data By Exchange") | 7 | | Try It | [Docs](/providers/cryptoapis/trades-latest-data) | **Trades Latest Data** | =CSQUERY("CryptoAPIs","Trades Latest Data") | =CSPARAMETERS("CryptoAPIs","Trades Latest Data") | 1 | | Try It | [Docs](/providers/cryptoapis/trades-latest-data-by-symbol) | **Trades Latest Data by Symbol** | =CSQUERY("CryptoAPIs","Trades Latest Data by Symbol") | =CSPARAMETERS("CryptoAPIs","Trades Latest Data by Symbol") | 4 | | Try It | [Docs](/providers/cryptoapis/trades-latest-data-by-exchange) | **Trades Latest Data by Exchange** | =CSQUERY("CryptoAPIs","Trades Latest Data by Exchange") | =CSPARAMETERS("CryptoAPIs","Trades Latest Data by Exchange") | 2 | | Try It | [Docs](/providers/cryptoapis/trades-latest-data-by-base-asset) | **Trades Latest Data by Base Asset** | =CSQUERY("CryptoAPIs","Trades Latest Data by Base Asset") | =CSPARAMETERS("CryptoAPIs","Trades Latest Data by Base Asset") | 4 | | Try It | [Docs](/providers/cryptoapis/trades-latest-data-by-asset-pair) | **Trades Latest Data by Asset Pair** | =CSQUERY("CryptoAPIs","Trades Latest Data by Asset Pair") | =CSPARAMETERS("CryptoAPIs","Trades Latest Data by Asset Pair") | 5 | | Try It | [Docs](/providers/cryptoapis/trades-latest-data-by-exchange-assets-pair) | **Trades Latest Data by Exchange Assets Pair** | =CSQUERY("CryptoAPIs","Trades Latest Data by Exchange Assets Pair") | =CSPARAMETERS("CryptoAPIs","Trades Latest Data by Exchange Assets Pair") | 6 | | Try It | [Docs](/providers/cryptoapis/trades-historical-data) | **Trades Historical Data** | =CSQUERY("CryptoAPIs","Trades Historical Data") | =CSPARAMETERS("CryptoAPIs","Trades Historical Data") | 4 | | Try It | [Docs](/providers/cryptoapis/trades-historical-data-by-exchange) | **Trades Historical Data by Exchange** | =CSQUERY("CryptoAPIs","Trades Historical Data by Exchange") | =CSPARAMETERS("CryptoAPIs","Trades Historical Data by Exchange") | 6 | | Try It | [Docs](/providers/cryptoapis/trades-historical-data-by-base-asset) | **Trades Historical Data by Base Asset** | =CSQUERY("CryptoAPIs","Trades Historical Data by Base Asset") | =CSPARAMETERS("CryptoAPIs","Trades Historical Data by Base Asset") | 6 | | Try It | [Docs](/providers/cryptoapis/trades-historical-data-by-asset-pair) | **Trades Historical Data by Asset Pair** | =CSQUERY("CryptoAPIs","Trades Historical Data by Asset Pair") | =CSPARAMETERS("CryptoAPIs","Trades Historical Data by Asset Pair") | 5 | | Try It | [Docs](/providers/cryptoapis/trades-historical-data-by-exchange-assets-pair) | **Trades Historical Data by Exchange Assets Pair** | =CSQUERY("CryptoAPIs","Trades Historical Data by Exchange Assets Pair") | =CSPARAMETERS("CryptoAPIs","Trades Historical Data by Exchange Assets Pair") | 8 | | Try It | [Docs](/providers/cryptoapis/snapshot-by-symbol) | **Snapshot by symbol** | =CSQUERY("CryptoAPIs","Snapshot by symbol") | =CSPARAMETERS("CryptoAPIs","Snapshot by symbol") | 2 | | Try It | [Docs](/providers/cryptoapis/get-node-information) | **Get Node Information** | =CSQUERY("CryptoAPIs","Get Node Information") | =CSPARAMETERS("CryptoAPIs","Get Node Information") | 3 | | Try It | [Docs](/providers/cryptoapis/get-block-by-hash) | **Get Block By Hash** | =CSQUERY("CryptoAPIs","Get Block By Hash") | =CSPARAMETERS("CryptoAPIs","Get Block By Hash") | 4 | | Try It | [Docs](/providers/cryptoapis/get-address-details) | **Get Address Details** | =CSQUERY("CryptoAPIs","Get Address Details") | =CSPARAMETERS("CryptoAPIs","Get Address Details") | 4 | | Try It | [Docs](/providers/cryptoapis/get-basic-transactions-by-address) | **Get Basic Transactions By Address** | =CSQUERY("CryptoAPIs","Get Basic Transactions By Address") | =CSPARAMETERS("CryptoAPIs","Get Basic Transactions By Address") | 6 | | Try It | [Docs](/providers/cryptoapis/get-multisig-address-details) | **Get Multisig Address Details** | =CSQUERY("CryptoAPIs","Get Multisig Address Details") | =CSPARAMETERS("CryptoAPIs","Get Multisig Address Details") | 4 | | Try It | [Docs](/providers/cryptoapis/get-confirmed-transactions-for-address-by-range) | **Get Confirmed Transactions For Address By Range** | =CSQUERY("CryptoAPIs","Get Confirmed Transactions For Address By Range") | =CSPARAMETERS("CryptoAPIs","Get Confirmed Transactions For Address By Range") | 6 | | Try It | [Docs](/providers/cryptoapis/get-confirmed-transactions-by-address) | **Get Confirmed Transactions By Address** | =CSQUERY("CryptoAPIs","Get Confirmed Transactions By Address") | =CSPARAMETERS("CryptoAPIs","Get Confirmed Transactions By Address") | 4 | | Try It | [Docs](/providers/cryptoapis/get-unconfirmed-transactions-by-address) | **Get Unconfirmed Transactions By Address** | =CSQUERY("CryptoAPIs","Get Unconfirmed Transactions By Address") | =CSPARAMETERS("CryptoAPIs","Get Unconfirmed Transactions By Address") | 4 | | Try It | [Docs](/providers/cryptoapis/get-basic-transaction-details-by-transaction-id) | **Get Basic Transaction Details By Transaction ID** | =CSQUERY("CryptoAPIs","Get Basic Transaction Details By Transaction ID") | =CSPARAMETERS("CryptoAPIs","Get Basic Transaction Details By Transaction ID") | 4 | | Try It | [Docs](/providers/cryptoapis/get-transaction-details-by-transaction-id) | **Get Transaction Details By Transaction ID** | =CSQUERY("CryptoAPIs","Get Transaction Details By Transaction ID") | =CSPARAMETERS("CryptoAPIs","Get Transaction Details By Transaction ID") | 4 | | Try It | [Docs](/providers/cryptoapis/get-transactions-by-block-number) | **Get Transactions By Block Number** | =CSQUERY("CryptoAPIs","Get Transactions By Block Number") | =CSPARAMETERS("CryptoAPIs","Get Transactions By Block Number") | 6 | | Try It | [Docs](/providers/cryptoapis/get-unconfirmed-transactions) | **Get Unconfirmed Transactions** | =CSQUERY("CryptoAPIs","Get Unconfirmed Transactions") | =CSPARAMETERS("CryptoAPIs","Get Unconfirmed Transactions") | 5 | | Try It | [Docs](/providers/cryptoapis/get-raw-transaction-hex-by-transaction-id-(txid)) | **Get Raw Transaction Hex By Transaction ID (Txid)** | =CSQUERY("CryptoAPIs","Get Raw Transaction Hex By Transaction ID (Txid)") | =CSPARAMETERS("CryptoAPIs","Get Raw Transaction Hex By Transaction ID (Txid)") | 4 |

[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 CryptoAPIs Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `CryptoAPIs` `provider`