> Bitcoin Payment, Wallet & Transaction Data Find examples for accessing every **Blockchain** 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/blockchain/charts-api) | **Charts API** | =CS.QUERY("Blockchain","Charts API") | =CS.PARAMETERS("Blockchain","Charts API") | 6 | | Try It | [Docs](/providers/blockchain/stats-api) | **Stats API** | =CS.QUERY("Blockchain","Stats API") | =CS.PARAMETERS("Blockchain","Stats API") | 0 | | Try It | [Docs](/providers/blockchain/pools-api) | **Pools API** | =CS.QUERY("Blockchain","Pools API") | =CS.PARAMETERS("Blockchain","Pools API") | 1 | | Try It | [Docs](/providers/blockchain/single-block) | **Single Block** | =CS.QUERY("Blockchain","Single Block") | =CS.PARAMETERS("Blockchain","Single Block") | 1 | | Try It | [Docs](/providers/blockchain/single-transaction) | **Single Transaction** | =CS.QUERY("Blockchain","Single Transaction") | =CS.PARAMETERS("Blockchain","Single Transaction") | 1 | | Try It | [Docs](/providers/blockchain/block-height) | **Block Height** | =CS.QUERY("Blockchain","Block Height") | =CS.PARAMETERS("Blockchain","Block Height") | 1 | | Try It | [Docs](/providers/blockchain/single-address) | **Single Address** | =CS.QUERY("Blockchain","Single Address") | =CS.PARAMETERS("Blockchain","Single Address") | 3 | | Try It | [Docs](/providers/blockchain/multi-address) | **Multi Address** | =CS.QUERY("Blockchain","Multi Address") | =CS.PARAMETERS("Blockchain","Multi Address") | 3 | | Try It | [Docs](/providers/blockchain/unspent-outputs) | **Unspent Outputs** | =CS.QUERY("Blockchain","Unspent Outputs") | =CS.PARAMETERS("Blockchain","Unspent Outputs") | 3 | | Try It | [Docs](/providers/blockchain/balance) | **Balance** | =CS.QUERY("Blockchain","Balance") | =CS.PARAMETERS("Blockchain","Balance") | 1 | | Try It | [Docs](/providers/blockchain/latest-block) | **Latest Block** | =CS.QUERY("Blockchain","Latest Block") | =CS.PARAMETERS("Blockchain","Latest Block") | 0 | | Try It | [Docs](/providers/blockchain/unconfirmed-transactions) | **Unconfirmed Transactions** | =CS.QUERY("Blockchain","Unconfirmed Transactions") | =CS.PARAMETERS("Blockchain","Unconfirmed Transactions") | 0 | | Try It | [Docs](/providers/blockchain/blocks-for-day) | **Blocks For Day** | =CS.QUERY("Blockchain","Blocks For Day") | =CS.PARAMETERS("Blockchain","Blocks For Day") | 1 | | Try It | [Docs](/providers/blockchain/blocks-for-pool) | **Blocks For Pool** | =CS.QUERY("Blockchain","Blocks For Pool") | =CS.PARAMETERS("Blockchain","Blocks For Pool") | 1 | | Try It | [Docs](/providers/blockchain/difficulty) | **Difficulty** | =CS.QUERY("Blockchain","Difficulty") | =CS.PARAMETERS("Blockchain","Difficulty") | 0 | | Try It | [Docs](/providers/blockchain/block-count) | **Block Count** | =CS.QUERY("Blockchain","Block Count") | =CS.PARAMETERS("Blockchain","Block Count") | 0 | | Try It | [Docs](/providers/blockchain/latest-hash) | **Latest Hash** | =CS.QUERY("Blockchain","Latest Hash") | =CS.PARAMETERS("Blockchain","Latest Hash") | 0 | | Try It | [Docs](/providers/blockchain/bc-per-block) | **BC Per Block** | =CS.QUERY("Blockchain","BC Per Block") | =CS.PARAMETERS("Blockchain","BC Per Block") | 0 | | Try It | [Docs](/providers/blockchain/total-bc) | **Total BC** | =CS.QUERY("Blockchain","Total BC") | =CS.PARAMETERS("Blockchain","Total BC") | 0 | | Try It | [Docs](/providers/blockchain/probability) | **Probability** | =CS.QUERY("Blockchain","Probability") | =CS.PARAMETERS("Blockchain","Probability") | 0 | | Try It | [Docs](/providers/blockchain/hashes-to-win) | **Hashes To Win** | =CS.QUERY("Blockchain","Hashes To Win") | =CS.PARAMETERS("Blockchain","Hashes To Win") | 0 | | Try It | [Docs](/providers/blockchain/next-retarget) | **Next Retarget** | =CS.QUERY("Blockchain","Next Retarget") | =CS.PARAMETERS("Blockchain","Next Retarget") | 0 | | Try It | [Docs](/providers/blockchain/average-transaction-size) | **Average Transaction Size** | =CS.QUERY("Blockchain","Average Transaction Size") | =CS.PARAMETERS("Blockchain","Average Transaction Size") | 0 | | Try It | [Docs](/providers/blockchain/average-transaction-value) | **Average Transaction Value** | =CS.QUERY("Blockchain","Average Transaction Value") | =CS.PARAMETERS("Blockchain","Average Transaction Value") | 0 | | Try It | [Docs](/providers/blockchain/interval) | **Interval** | =CS.QUERY("Blockchain","Interval") | =CS.PARAMETERS("Blockchain","Interval") | 0 | | Try It | [Docs](/providers/blockchain/eta) | **ETA** | =CS.QUERY("Blockchain","ETA") | =CS.PARAMETERS("Blockchain","ETA") | 0 | | Try It | [Docs](/providers/blockchain/average-transaction-number) | **Average Transaction Number** | =CS.QUERY("Blockchain","Average Transaction Number") | =CS.PARAMETERS("Blockchain","Average Transaction Number") | 0 | | Try It | [Docs](/providers/blockchain/received-by-address) | **Received By Address** | =CS.QUERY("Blockchain","Received By Address") | =CS.PARAMETERS("Blockchain","Received By Address") | 3 | | Try It | [Docs](/providers/blockchain/sent-by-address) | **Sent By Address** | =CS.QUERY("Blockchain","Sent By Address") | =CS.PARAMETERS("Blockchain","Sent By Address") | 1 | | Try It | [Docs](/providers/blockchain/address-balance) | **Address Balance** | =CS.QUERY("Blockchain","Address Balance") | =CS.PARAMETERS("Blockchain","Address Balance") | 1 | | Try It | [Docs](/providers/blockchain/address-first-seen) | **Address First Seen** | =CS.QUERY("Blockchain","Address First Seen") | =CS.PARAMETERS("Blockchain","Address First Seen") | 1 | | Try It | [Docs](/providers/blockchain/transaction-total-btc-output) | **Transaction Total BTC Output** | =CS.QUERY("Blockchain","Transaction Total BTC Output") | =CS.PARAMETERS("Blockchain","Transaction Total BTC Output") | 1 | | Try It | [Docs](/providers/blockchain/transaction-total-btc-input) | **Transaction Total BTC Input** | =CS.QUERY("Blockchain","Transaction Total BTC Input") | =CS.PARAMETERS("Blockchain","Transaction Total BTC Input") | 1 | | Try It | [Docs](/providers/blockchain/transaction-fee) | **Transaction Fee** | =CS.QUERY("Blockchain","Transaction Fee") | =CS.PARAMETERS("Blockchain","Transaction Fee") | 1 | | Try It | [Docs](/providers/blockchain/transaction-result) | **Transaction Result** | =CS.QUERY("Blockchain","Transaction Result") | =CS.PARAMETERS("Blockchain","Transaction Result") | 1 | | Try It | [Docs](/providers/blockchain/address-to-hash) | **Address To Hash** | =CS.QUERY("Blockchain","Address To Hash") | =CS.PARAMETERS("Blockchain","Address To Hash") | 1 | | Try It | [Docs](/providers/blockchain/hash-to-address) | **Hash To Address** | =CS.QUERY("Blockchain","Hash To Address") | =CS.PARAMETERS("Blockchain","Hash To Address") | 1 | | Try It | [Docs](/providers/blockchain/hash-public-key) | **Hash Public Key** | =CS.QUERY("Blockchain","Hash Public Key") | =CS.PARAMETERS("Blockchain","Hash Public Key") | 1 | | Try It | [Docs](/providers/blockchain/address-public-key) | **Address Public Key** | =CS.QUERY("Blockchain","Address Public Key") | =CS.PARAMETERS("Blockchain","Address Public Key") | 1 | | Try It | [Docs](/providers/blockchain/public-key-address) | **Public Key Address** | =CS.QUERY("Blockchain","Public Key Address") | =CS.PARAMETERS("Blockchain","Public Key Address") | 1 | | Try It | [Docs](/providers/blockchain/24hr-price) | **24hr Price** | =CS.QUERY("Blockchain","24hr Price") | =CS.PARAMETERS("Blockchain","24hr Price") | 0 | | Try It | [Docs](/providers/blockchain/market-cap) | **Market Cap** | =CS.QUERY("Blockchain","Market Cap") | =CS.PARAMETERS("Blockchain","Market Cap") | 0 | | Try It | [Docs](/providers/blockchain/24hr-transaction-count) | **24hr Transaction Count** | =CS.QUERY("Blockchain","24hr Transaction Count") | =CS.PARAMETERS("Blockchain","24hr Transaction Count") | 0 | | Try It | [Docs](/providers/blockchain/24hr-btc-sent) | **24hr Btc Sent** | =CS.QUERY("Blockchain","24hr Btc Sent") | =CS.PARAMETERS("Blockchain","24hr Btc Sent") | 0 | | Try It | [Docs](/providers/blockchain/hash-rate) | **Hash Rate** | =CS.QUERY("Blockchain","Hash Rate") | =CS.PARAMETERS("Blockchain","Hash Rate") | 0 | | Try It | [Docs](/providers/blockchain/rejected) | **Rejected** | =CS.QUERY("Blockchain","Rejected") | =CS.PARAMETERS("Blockchain","Rejected") | 0 | | Try It | [Docs](/providers/blockchain/unconfirmed-transactions-count) | **Unconfirmed Transactions Count** | =CS.QUERY("Blockchain","Unconfirmed Transactions Count") | =CS.PARAMETERS("Blockchain","Unconfirmed Transactions Count") | 0 | | Try It | [Docs](/providers/blockchain/get-l2-order-book) | **Get L2 Order Book** | =CS.QUERY("Blockchain","Get L2 Order Book") | =CS.PARAMETERS("Blockchain","Get L2 Order Book") | 1 | | Try It | [Docs](/providers/blockchain/get-l3-order-book) | **Get L3 Order Book** | =CS.QUERY("Blockchain","Get L3 Order Book") | =CS.PARAMETERS("Blockchain","Get L3 Order Book") | 1 | | Try It | [Docs](/providers/blockchain/get-tickers) | **Get Tickers** | =CS.QUERY("Blockchain","Get Tickers") | =CS.PARAMETERS("Blockchain","Get Tickers") | 0 | | Try It | [Docs](/providers/blockchain/get-ticker-by-symbol) | **Get Ticker By Symbol** | =CS.QUERY("Blockchain","Get Ticker By Symbol") | =CS.PARAMETERS("Blockchain","Get Ticker By Symbol") | 1 | | Try It | [Docs](/providers/blockchain/get-symbols) | **Get Symbols** | =CS.QUERY("Blockchain","Get Symbols") | =CS.PARAMETERS("Blockchain","Get Symbols") | 0 | | Try It | [Docs](/providers/blockchain/get-symbol-by-name) | **Get Symbol By Name** | =CS.QUERY("Blockchain","Get Symbol By Name") | =CS.PARAMETERS("Blockchain","Get Symbol By Name") | 1 | | Try It | [Docs](/providers/blockchain/get-accounts) | **Get Accounts** | =CS.QUERY("Blockchain","Get Accounts") | =CS.PARAMETERS("Blockchain","Get Accounts") | 0 | | Try It | [Docs](/providers/blockchain/get-account-by-type-and-currency) | **Get Account By Type And Currency** | =CS.QUERY("Blockchain","Get Account By Type And Currency") | =CS.PARAMETERS("Blockchain","Get Account By Type And Currency") | 2 | | Try It | [Docs](/providers/blockchain/get-fees) | **Get Fees** | =CS.QUERY("Blockchain","Get Fees") | =CS.PARAMETERS("Blockchain","Get Fees") | 0 | | Try It | [Docs](/providers/blockchain/get-orders) | **Get Orders** | =CS.QUERY("Blockchain","Get Orders") | =CS.PARAMETERS("Blockchain","Get Orders") | 5 | | Try It | [Docs](/providers/blockchain/get-order-by-id) | **Get Order By Id** | =CS.QUERY("Blockchain","Get Order By Id") | =CS.PARAMETERS("Blockchain","Get Order By Id") | 1 | | Try It | [Docs](/providers/blockchain/get-deposits) | **Get Deposits** | =CS.QUERY("Blockchain","Get Deposits") | =CS.PARAMETERS("Blockchain","Get Deposits") | 2 | | Try It | [Docs](/providers/blockchain/get-deposit-by-id) | **Get Deposit By Id** | =CS.QUERY("Blockchain","Get Deposit By Id") | =CS.PARAMETERS("Blockchain","Get Deposit By Id") | 1 | | Try It | [Docs](/providers/blockchain/get-whitelist) | **Get Whitelist** | =CS.QUERY("Blockchain","Get Whitelist") | =CS.PARAMETERS("Blockchain","Get Whitelist") | 0 | | Try It | [Docs](/providers/blockchain/get-whitelist-by-currency) | **Get Whitelist By Currency** | =CS.QUERY("Blockchain","Get Whitelist By Currency") | =CS.PARAMETERS("Blockchain","Get Whitelist By Currency") | 1 | | Try It | [Docs](/providers/blockchain/get-withdrawals) | **Get Withdrawals** | =CS.QUERY("Blockchain","Get Withdrawals") | =CS.PARAMETERS("Blockchain","Get Withdrawals") | 2 | | Try It | [Docs](/providers/blockchain/get-withdrawal-by-id) | **Get Withdrawal By Id** | =CS.QUERY("Blockchain","Get Withdrawal By Id") | =CS.PARAMETERS("Blockchain","Get Withdrawal By Id") | 1 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/blockchain/charts-api) | **Charts API** | =CSQUERY("Blockchain","Charts API") | =CSPARAMETERS("Blockchain","Charts API") | 6 | | Try It | [Docs](/providers/blockchain/stats-api) | **Stats API** | =CSQUERY("Blockchain","Stats API") | =CSPARAMETERS("Blockchain","Stats API") | 0 | | Try It | [Docs](/providers/blockchain/pools-api) | **Pools API** | =CSQUERY("Blockchain","Pools API") | =CSPARAMETERS("Blockchain","Pools API") | 1 | | Try It | [Docs](/providers/blockchain/single-block) | **Single Block** | =CSQUERY("Blockchain","Single Block") | =CSPARAMETERS("Blockchain","Single Block") | 1 | | Try It | [Docs](/providers/blockchain/single-transaction) | **Single Transaction** | =CSQUERY("Blockchain","Single Transaction") | =CSPARAMETERS("Blockchain","Single Transaction") | 1 | | Try It | [Docs](/providers/blockchain/block-height) | **Block Height** | =CSQUERY("Blockchain","Block Height") | =CSPARAMETERS("Blockchain","Block Height") | 1 | | Try It | [Docs](/providers/blockchain/single-address) | **Single Address** | =CSQUERY("Blockchain","Single Address") | =CSPARAMETERS("Blockchain","Single Address") | 3 | | Try It | [Docs](/providers/blockchain/multi-address) | **Multi Address** | =CSQUERY("Blockchain","Multi Address") | =CSPARAMETERS("Blockchain","Multi Address") | 3 | | Try It | [Docs](/providers/blockchain/unspent-outputs) | **Unspent Outputs** | =CSQUERY("Blockchain","Unspent Outputs") | =CSPARAMETERS("Blockchain","Unspent Outputs") | 3 | | Try It | [Docs](/providers/blockchain/balance) | **Balance** | =CSQUERY("Blockchain","Balance") | =CSPARAMETERS("Blockchain","Balance") | 1 | | Try It | [Docs](/providers/blockchain/latest-block) | **Latest Block** | =CSQUERY("Blockchain","Latest Block") | =CSPARAMETERS("Blockchain","Latest Block") | 0 | | Try It | [Docs](/providers/blockchain/unconfirmed-transactions) | **Unconfirmed Transactions** | =CSQUERY("Blockchain","Unconfirmed Transactions") | =CSPARAMETERS("Blockchain","Unconfirmed Transactions") | 0 | | Try It | [Docs](/providers/blockchain/blocks-for-day) | **Blocks For Day** | =CSQUERY("Blockchain","Blocks For Day") | =CSPARAMETERS("Blockchain","Blocks For Day") | 1 | | Try It | [Docs](/providers/blockchain/blocks-for-pool) | **Blocks For Pool** | =CSQUERY("Blockchain","Blocks For Pool") | =CSPARAMETERS("Blockchain","Blocks For Pool") | 1 | | Try It | [Docs](/providers/blockchain/difficulty) | **Difficulty** | =CSQUERY("Blockchain","Difficulty") | =CSPARAMETERS("Blockchain","Difficulty") | 0 | | Try It | [Docs](/providers/blockchain/block-count) | **Block Count** | =CSQUERY("Blockchain","Block Count") | =CSPARAMETERS("Blockchain","Block Count") | 0 | | Try It | [Docs](/providers/blockchain/latest-hash) | **Latest Hash** | =CSQUERY("Blockchain","Latest Hash") | =CSPARAMETERS("Blockchain","Latest Hash") | 0 | | Try It | [Docs](/providers/blockchain/bc-per-block) | **BC Per Block** | =CSQUERY("Blockchain","BC Per Block") | =CSPARAMETERS("Blockchain","BC Per Block") | 0 | | Try It | [Docs](/providers/blockchain/total-bc) | **Total BC** | =CSQUERY("Blockchain","Total BC") | =CSPARAMETERS("Blockchain","Total BC") | 0 | | Try It | [Docs](/providers/blockchain/probability) | **Probability** | =CSQUERY("Blockchain","Probability") | =CSPARAMETERS("Blockchain","Probability") | 0 | | Try It | [Docs](/providers/blockchain/hashes-to-win) | **Hashes To Win** | =CSQUERY("Blockchain","Hashes To Win") | =CSPARAMETERS("Blockchain","Hashes To Win") | 0 | | Try It | [Docs](/providers/blockchain/next-retarget) | **Next Retarget** | =CSQUERY("Blockchain","Next Retarget") | =CSPARAMETERS("Blockchain","Next Retarget") | 0 | | Try It | [Docs](/providers/blockchain/average-transaction-size) | **Average Transaction Size** | =CSQUERY("Blockchain","Average Transaction Size") | =CSPARAMETERS("Blockchain","Average Transaction Size") | 0 | | Try It | [Docs](/providers/blockchain/average-transaction-value) | **Average Transaction Value** | =CSQUERY("Blockchain","Average Transaction Value") | =CSPARAMETERS("Blockchain","Average Transaction Value") | 0 | | Try It | [Docs](/providers/blockchain/interval) | **Interval** | =CSQUERY("Blockchain","Interval") | =CSPARAMETERS("Blockchain","Interval") | 0 | | Try It | [Docs](/providers/blockchain/eta) | **ETA** | =CSQUERY("Blockchain","ETA") | =CSPARAMETERS("Blockchain","ETA") | 0 | | Try It | [Docs](/providers/blockchain/average-transaction-number) | **Average Transaction Number** | =CSQUERY("Blockchain","Average Transaction Number") | =CSPARAMETERS("Blockchain","Average Transaction Number") | 0 | | Try It | [Docs](/providers/blockchain/received-by-address) | **Received By Address** | =CSQUERY("Blockchain","Received By Address") | =CSPARAMETERS("Blockchain","Received By Address") | 3 | | Try It | [Docs](/providers/blockchain/sent-by-address) | **Sent By Address** | =CSQUERY("Blockchain","Sent By Address") | =CSPARAMETERS("Blockchain","Sent By Address") | 1 | | Try It | [Docs](/providers/blockchain/address-balance) | **Address Balance** | =CSQUERY("Blockchain","Address Balance") | =CSPARAMETERS("Blockchain","Address Balance") | 1 | | Try It | [Docs](/providers/blockchain/address-first-seen) | **Address First Seen** | =CSQUERY("Blockchain","Address First Seen") | =CSPARAMETERS("Blockchain","Address First Seen") | 1 | | Try It | [Docs](/providers/blockchain/transaction-total-btc-output) | **Transaction Total BTC Output** | =CSQUERY("Blockchain","Transaction Total BTC Output") | =CSPARAMETERS("Blockchain","Transaction Total BTC Output") | 1 | | Try It | [Docs](/providers/blockchain/transaction-total-btc-input) | **Transaction Total BTC Input** | =CSQUERY("Blockchain","Transaction Total BTC Input") | =CSPARAMETERS("Blockchain","Transaction Total BTC Input") | 1 | | Try It | [Docs](/providers/blockchain/transaction-fee) | **Transaction Fee** | =CSQUERY("Blockchain","Transaction Fee") | =CSPARAMETERS("Blockchain","Transaction Fee") | 1 | | Try It | [Docs](/providers/blockchain/transaction-result) | **Transaction Result** | =CSQUERY("Blockchain","Transaction Result") | =CSPARAMETERS("Blockchain","Transaction Result") | 1 | | Try It | [Docs](/providers/blockchain/address-to-hash) | **Address To Hash** | =CSQUERY("Blockchain","Address To Hash") | =CSPARAMETERS("Blockchain","Address To Hash") | 1 | | Try It | [Docs](/providers/blockchain/hash-to-address) | **Hash To Address** | =CSQUERY("Blockchain","Hash To Address") | =CSPARAMETERS("Blockchain","Hash To Address") | 1 | | Try It | [Docs](/providers/blockchain/hash-public-key) | **Hash Public Key** | =CSQUERY("Blockchain","Hash Public Key") | =CSPARAMETERS("Blockchain","Hash Public Key") | 1 | | Try It | [Docs](/providers/blockchain/address-public-key) | **Address Public Key** | =CSQUERY("Blockchain","Address Public Key") | =CSPARAMETERS("Blockchain","Address Public Key") | 1 | | Try It | [Docs](/providers/blockchain/public-key-address) | **Public Key Address** | =CSQUERY("Blockchain","Public Key Address") | =CSPARAMETERS("Blockchain","Public Key Address") | 1 | | Try It | [Docs](/providers/blockchain/24hr-price) | **24hr Price** | =CSQUERY("Blockchain","24hr Price") | =CSPARAMETERS("Blockchain","24hr Price") | 0 | | Try It | [Docs](/providers/blockchain/market-cap) | **Market Cap** | =CSQUERY("Blockchain","Market Cap") | =CSPARAMETERS("Blockchain","Market Cap") | 0 | | Try It | [Docs](/providers/blockchain/24hr-transaction-count) | **24hr Transaction Count** | =CSQUERY("Blockchain","24hr Transaction Count") | =CSPARAMETERS("Blockchain","24hr Transaction Count") | 0 | | Try It | [Docs](/providers/blockchain/24hr-btc-sent) | **24hr Btc Sent** | =CSQUERY("Blockchain","24hr Btc Sent") | =CSPARAMETERS("Blockchain","24hr Btc Sent") | 0 | | Try It | [Docs](/providers/blockchain/hash-rate) | **Hash Rate** | =CSQUERY("Blockchain","Hash Rate") | =CSPARAMETERS("Blockchain","Hash Rate") | 0 | | Try It | [Docs](/providers/blockchain/rejected) | **Rejected** | =CSQUERY("Blockchain","Rejected") | =CSPARAMETERS("Blockchain","Rejected") | 0 | | Try It | [Docs](/providers/blockchain/unconfirmed-transactions-count) | **Unconfirmed Transactions Count** | =CSQUERY("Blockchain","Unconfirmed Transactions Count") | =CSPARAMETERS("Blockchain","Unconfirmed Transactions Count") | 0 | | Try It | [Docs](/providers/blockchain/get-l2-order-book) | **Get L2 Order Book** | =CSQUERY("Blockchain","Get L2 Order Book") | =CSPARAMETERS("Blockchain","Get L2 Order Book") | 1 | | Try It | [Docs](/providers/blockchain/get-l3-order-book) | **Get L3 Order Book** | =CSQUERY("Blockchain","Get L3 Order Book") | =CSPARAMETERS("Blockchain","Get L3 Order Book") | 1 | | Try It | [Docs](/providers/blockchain/get-tickers) | **Get Tickers** | =CSQUERY("Blockchain","Get Tickers") | =CSPARAMETERS("Blockchain","Get Tickers") | 0 | | Try It | [Docs](/providers/blockchain/get-ticker-by-symbol) | **Get Ticker By Symbol** | =CSQUERY("Blockchain","Get Ticker By Symbol") | =CSPARAMETERS("Blockchain","Get Ticker By Symbol") | 1 | | Try It | [Docs](/providers/blockchain/get-symbols) | **Get Symbols** | =CSQUERY("Blockchain","Get Symbols") | =CSPARAMETERS("Blockchain","Get Symbols") | 0 | | Try It | [Docs](/providers/blockchain/get-symbol-by-name) | **Get Symbol By Name** | =CSQUERY("Blockchain","Get Symbol By Name") | =CSPARAMETERS("Blockchain","Get Symbol By Name") | 1 | | Try It | [Docs](/providers/blockchain/get-accounts) | **Get Accounts** | =CSQUERY("Blockchain","Get Accounts") | =CSPARAMETERS("Blockchain","Get Accounts") | 0 | | Try It | [Docs](/providers/blockchain/get-account-by-type-and-currency) | **Get Account By Type And Currency** | =CSQUERY("Blockchain","Get Account By Type And Currency") | =CSPARAMETERS("Blockchain","Get Account By Type And Currency") | 2 | | Try It | [Docs](/providers/blockchain/get-fees) | **Get Fees** | =CSQUERY("Blockchain","Get Fees") | =CSPARAMETERS("Blockchain","Get Fees") | 0 | | Try It | [Docs](/providers/blockchain/get-orders) | **Get Orders** | =CSQUERY("Blockchain","Get Orders") | =CSPARAMETERS("Blockchain","Get Orders") | 5 | | Try It | [Docs](/providers/blockchain/get-order-by-id) | **Get Order By Id** | =CSQUERY("Blockchain","Get Order By Id") | =CSPARAMETERS("Blockchain","Get Order By Id") | 1 | | Try It | [Docs](/providers/blockchain/get-deposits) | **Get Deposits** | =CSQUERY("Blockchain","Get Deposits") | =CSPARAMETERS("Blockchain","Get Deposits") | 2 | | Try It | [Docs](/providers/blockchain/get-deposit-by-id) | **Get Deposit By Id** | =CSQUERY("Blockchain","Get Deposit By Id") | =CSPARAMETERS("Blockchain","Get Deposit By Id") | 1 | | Try It | [Docs](/providers/blockchain/get-whitelist) | **Get Whitelist** | =CSQUERY("Blockchain","Get Whitelist") | =CSPARAMETERS("Blockchain","Get Whitelist") | 0 | | Try It | [Docs](/providers/blockchain/get-whitelist-by-currency) | **Get Whitelist By Currency** | =CSQUERY("Blockchain","Get Whitelist By Currency") | =CSPARAMETERS("Blockchain","Get Whitelist By Currency") | 1 | | Try It | [Docs](/providers/blockchain/get-withdrawals) | **Get Withdrawals** | =CSQUERY("Blockchain","Get Withdrawals") | =CSPARAMETERS("Blockchain","Get Withdrawals") | 2 | | Try It | [Docs](/providers/blockchain/get-withdrawal-by-id) | **Get Withdrawal By Id** | =CSQUERY("Blockchain","Get Withdrawal By Id") | =CSPARAMETERS("Blockchain","Get Withdrawal By Id") | 1 |

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