> Horizon is an API for interacting with the Stellar network. Find examples for accessing every **Stellar** 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/stellar/retrieve-a-ledger) | **Retrieve a Ledger** | =CS.QUERY("Stellar","Retrieve a Ledger") | =CS.PARAMETERS("Stellar","Retrieve a Ledger") | 1 | | Try It | [Docs](/providers/stellar/retrieve-a-ledgers-transactions) | **Retrieve a Ledgers Transactions** | =CS.QUERY("Stellar","Retrieve a Ledgers Transactions") | =CS.PARAMETERS("Stellar","Retrieve a Ledgers Transactions") | 5 | | Try It | [Docs](/providers/stellar/retrieve-a-ledgers-operations) | **Retrieve a Ledgers Operations** | =CS.QUERY("Stellar","Retrieve a Ledgers Operations") | =CS.PARAMETERS("Stellar","Retrieve a Ledgers Operations") | 6 | | Try It | [Docs](/providers/stellar/retrieve-a-ledgers-payments) | **Retrieve a Ledgers Payments** | =CS.QUERY("Stellar","Retrieve a Ledgers Payments") | =CS.PARAMETERS("Stellar","Retrieve a Ledgers Payments") | 6 | | Try It | [Docs](/providers/stellar/retrieve-a-ledgers-effects) | **Retrieve a Ledgers Effects** | =CS.QUERY("Stellar","Retrieve a Ledgers Effects") | =CS.PARAMETERS("Stellar","Retrieve a Ledgers Effects") | 4 | | Try It | [Docs](/providers/stellar/retrieve-a-transaction) | **Retrieve a Transaction** | =CS.QUERY("Stellar","Retrieve a Transaction") | =CS.PARAMETERS("Stellar","Retrieve a Transaction") | 1 | | Try It | [Docs](/providers/stellar/retrieve-a-transactions-operations) | **Retrieve a Transactions Operations** | =CS.QUERY("Stellar","Retrieve a Transactions Operations") | =CS.PARAMETERS("Stellar","Retrieve a Transactions Operations") | 6 | | Try It | [Docs](/providers/stellar/retrieve-a-transactions-effects) | **Retrieve a Transactions Effects** | =CS.QUERY("Stellar","Retrieve a Transactions Effects") | =CS.PARAMETERS("Stellar","Retrieve a Transactions Effects") | 4 | | Try It | [Docs](/providers/stellar/list-all-transactions) | **List All Transactions** | =CS.QUERY("Stellar","List All Transactions") | =CS.PARAMETERS("Stellar","List All Transactions") | 4 | | Try It | [Docs](/providers/stellar/retrieve-an-operation) | **Retrieve an Operation** | =CS.QUERY("Stellar","Retrieve an Operation") | =CS.PARAMETERS("Stellar","Retrieve an Operation") | 1 | | Try It | [Docs](/providers/stellar/retrieve-an-operations-effects) | **Retrieve an Operations Effects** | =CS.QUERY("Stellar","Retrieve an Operations Effects") | =CS.PARAMETERS("Stellar","Retrieve an Operations Effects") | 4 | | Try It | [Docs](/providers/stellar/list-all-operations) | **List All Operations** | =CS.QUERY("Stellar","List All Operations") | =CS.PARAMETERS("Stellar","List All Operations") | 5 | | Try It | [Docs](/providers/stellar/list-all-payments) | **List All Payments** | =CS.QUERY("Stellar","List All Payments") | =CS.PARAMETERS("Stellar","List All Payments") | 5 | | Try It | [Docs](/providers/stellar/list-all-effects) | **List All Effects** | =CS.QUERY("Stellar","List All Effects") | =CS.PARAMETERS("Stellar","List All Effects") | 3 | | Try It | [Docs](/providers/stellar/list-all-accounts) | **List All Accounts** | =CS.QUERY("Stellar","List All Accounts") | =CS.PARAMETERS("Stellar","List All Accounts") | 6 | | Try It | [Docs](/providers/stellar/retrieve-an-account) | **Retrieve an Account** | =CS.QUERY("Stellar","Retrieve an Account") | =CS.PARAMETERS("Stellar","Retrieve an Account") | 1 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-transactions) | **Retrieve an Accounts Transactions** | =CS.QUERY("Stellar","Retrieve an Accounts Transactions") | =CS.PARAMETERS("Stellar","Retrieve an Accounts Transactions") | 5 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-operations) | **Retrieve an Accounts Operations** | =CS.QUERY("Stellar","Retrieve an Accounts Operations") | =CS.PARAMETERS("Stellar","Retrieve an Accounts Operations") | 6 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-payments) | **Retrieve an Accounts Payments** | =CS.QUERY("Stellar","Retrieve an Accounts Payments") | =CS.PARAMETERS("Stellar","Retrieve an Accounts Payments") | 6 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-effects) | **Retrieve an Accounts Effects** | =CS.QUERY("Stellar","Retrieve an Accounts Effects") | =CS.PARAMETERS("Stellar","Retrieve an Accounts Effects") | 4 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-offers) | **Retrieve an Accounts Offers** | =CS.QUERY("Stellar","Retrieve an Accounts Offers") | =CS.PARAMETERS("Stellar","Retrieve an Accounts Offers") | 4 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-trades) | **Retrieve an Accounts Trades** | =CS.QUERY("Stellar","Retrieve an Accounts Trades") | =CS.PARAMETERS("Stellar","Retrieve an Accounts Trades") | 4 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-data) | **Retrieve an Accounts Data** | =CS.QUERY("Stellar","Retrieve an Accounts Data") | =CS.PARAMETERS("Stellar","Retrieve an Accounts Data") | 2 | | Try It | [Docs](/providers/stellar/retrieve-an-offer) | **Retrieve an Offer** | =CS.QUERY("Stellar","Retrieve an Offer") | =CS.PARAMETERS("Stellar","Retrieve an Offer") | 1 | | Try It | [Docs](/providers/stellar/list-all-offers) | **List All Offers** | =CS.QUERY("Stellar","List All Offers") | =CS.PARAMETERS("Stellar","List All Offers") | 12 | | Try It | [Docs](/providers/stellar/list-all-trades) | **List All Trades** | =CS.QUERY("Stellar","List All Trades") | =CS.PARAMETERS("Stellar","List All Trades") | 9 | | Try It | [Docs](/providers/stellar/list-all-assets) | **List All Assets** | =CS.QUERY("Stellar","List All Assets") | =CS.PARAMETERS("Stellar","List All Assets") | 6 | | Try It | [Docs](/providers/stellar/retrieve-a-claimable-balance) | **Retrieve a Claimable Balance** | =CS.QUERY("Stellar","Retrieve a Claimable Balance") | =CS.PARAMETERS("Stellar","Retrieve a Claimable Balance") | 1 | | Try It | [Docs](/providers/stellar/list-claimable-balances) | **List Claimable Balances** | =CS.QUERY("Stellar","List Claimable Balances") | =CS.PARAMETERS("Stellar","List Claimable Balances") | 6 | | Try It | [Docs](/providers/stellar/retrieve-an-order-book) | **Retrieve an Order Book** | =CS.QUERY("Stellar","Retrieve an Order Book") | =CS.PARAMETERS("Stellar","Retrieve an Order Book") | 6 | | Try It | [Docs](/providers/stellar/list-strict-receive-payment-paths) | **List Strict Receive Payment Paths** | =CS.QUERY("Stellar","List Strict Receive Payment Paths") | =CS.PARAMETERS("Stellar","List Strict Receive Payment Paths") | 6 | | Try It | [Docs](/providers/stellar/list-strict-send-payment-paths) | **List Strict Send Payment Paths** | =CS.QUERY("Stellar","List Strict Send Payment Paths") | =CS.PARAMETERS("Stellar","List Strict Send Payment Paths") | 6 | | Try It | [Docs](/providers/stellar/list-trade-aggregations) | **List Trade Aggregations** | =CS.QUERY("Stellar","List Trade Aggregations") | =CS.PARAMETERS("Stellar","List Trade Aggregations") | 12 | | Try It | [Docs](/providers/stellar/fee-stats) | **Fee Stats** | =CS.QUERY("Stellar","Fee Stats") | =CS.PARAMETERS("Stellar","Fee Stats") | 0 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/stellar/retrieve-a-ledger) | **Retrieve a Ledger** | =CSQUERY("Stellar","Retrieve a Ledger") | =CSPARAMETERS("Stellar","Retrieve a Ledger") | 1 | | Try It | [Docs](/providers/stellar/retrieve-a-ledgers-transactions) | **Retrieve a Ledgers Transactions** | =CSQUERY("Stellar","Retrieve a Ledgers Transactions") | =CSPARAMETERS("Stellar","Retrieve a Ledgers Transactions") | 5 | | Try It | [Docs](/providers/stellar/retrieve-a-ledgers-operations) | **Retrieve a Ledgers Operations** | =CSQUERY("Stellar","Retrieve a Ledgers Operations") | =CSPARAMETERS("Stellar","Retrieve a Ledgers Operations") | 6 | | Try It | [Docs](/providers/stellar/retrieve-a-ledgers-payments) | **Retrieve a Ledgers Payments** | =CSQUERY("Stellar","Retrieve a Ledgers Payments") | =CSPARAMETERS("Stellar","Retrieve a Ledgers Payments") | 6 | | Try It | [Docs](/providers/stellar/retrieve-a-ledgers-effects) | **Retrieve a Ledgers Effects** | =CSQUERY("Stellar","Retrieve a Ledgers Effects") | =CSPARAMETERS("Stellar","Retrieve a Ledgers Effects") | 4 | | Try It | [Docs](/providers/stellar/retrieve-a-transaction) | **Retrieve a Transaction** | =CSQUERY("Stellar","Retrieve a Transaction") | =CSPARAMETERS("Stellar","Retrieve a Transaction") | 1 | | Try It | [Docs](/providers/stellar/retrieve-a-transactions-operations) | **Retrieve a Transactions Operations** | =CSQUERY("Stellar","Retrieve a Transactions Operations") | =CSPARAMETERS("Stellar","Retrieve a Transactions Operations") | 6 | | Try It | [Docs](/providers/stellar/retrieve-a-transactions-effects) | **Retrieve a Transactions Effects** | =CSQUERY("Stellar","Retrieve a Transactions Effects") | =CSPARAMETERS("Stellar","Retrieve a Transactions Effects") | 4 | | Try It | [Docs](/providers/stellar/list-all-transactions) | **List All Transactions** | =CSQUERY("Stellar","List All Transactions") | =CSPARAMETERS("Stellar","List All Transactions") | 4 | | Try It | [Docs](/providers/stellar/retrieve-an-operation) | **Retrieve an Operation** | =CSQUERY("Stellar","Retrieve an Operation") | =CSPARAMETERS("Stellar","Retrieve an Operation") | 1 | | Try It | [Docs](/providers/stellar/retrieve-an-operations-effects) | **Retrieve an Operations Effects** | =CSQUERY("Stellar","Retrieve an Operations Effects") | =CSPARAMETERS("Stellar","Retrieve an Operations Effects") | 4 | | Try It | [Docs](/providers/stellar/list-all-operations) | **List All Operations** | =CSQUERY("Stellar","List All Operations") | =CSPARAMETERS("Stellar","List All Operations") | 5 | | Try It | [Docs](/providers/stellar/list-all-payments) | **List All Payments** | =CSQUERY("Stellar","List All Payments") | =CSPARAMETERS("Stellar","List All Payments") | 5 | | Try It | [Docs](/providers/stellar/list-all-effects) | **List All Effects** | =CSQUERY("Stellar","List All Effects") | =CSPARAMETERS("Stellar","List All Effects") | 3 | | Try It | [Docs](/providers/stellar/list-all-accounts) | **List All Accounts** | =CSQUERY("Stellar","List All Accounts") | =CSPARAMETERS("Stellar","List All Accounts") | 6 | | Try It | [Docs](/providers/stellar/retrieve-an-account) | **Retrieve an Account** | =CSQUERY("Stellar","Retrieve an Account") | =CSPARAMETERS("Stellar","Retrieve an Account") | 1 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-transactions) | **Retrieve an Accounts Transactions** | =CSQUERY("Stellar","Retrieve an Accounts Transactions") | =CSPARAMETERS("Stellar","Retrieve an Accounts Transactions") | 5 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-operations) | **Retrieve an Accounts Operations** | =CSQUERY("Stellar","Retrieve an Accounts Operations") | =CSPARAMETERS("Stellar","Retrieve an Accounts Operations") | 6 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-payments) | **Retrieve an Accounts Payments** | =CSQUERY("Stellar","Retrieve an Accounts Payments") | =CSPARAMETERS("Stellar","Retrieve an Accounts Payments") | 6 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-effects) | **Retrieve an Accounts Effects** | =CSQUERY("Stellar","Retrieve an Accounts Effects") | =CSPARAMETERS("Stellar","Retrieve an Accounts Effects") | 4 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-offers) | **Retrieve an Accounts Offers** | =CSQUERY("Stellar","Retrieve an Accounts Offers") | =CSPARAMETERS("Stellar","Retrieve an Accounts Offers") | 4 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-trades) | **Retrieve an Accounts Trades** | =CSQUERY("Stellar","Retrieve an Accounts Trades") | =CSPARAMETERS("Stellar","Retrieve an Accounts Trades") | 4 | | Try It | [Docs](/providers/stellar/retrieve-an-accounts-data) | **Retrieve an Accounts Data** | =CSQUERY("Stellar","Retrieve an Accounts Data") | =CSPARAMETERS("Stellar","Retrieve an Accounts Data") | 2 | | Try It | [Docs](/providers/stellar/retrieve-an-offer) | **Retrieve an Offer** | =CSQUERY("Stellar","Retrieve an Offer") | =CSPARAMETERS("Stellar","Retrieve an Offer") | 1 | | Try It | [Docs](/providers/stellar/list-all-offers) | **List All Offers** | =CSQUERY("Stellar","List All Offers") | =CSPARAMETERS("Stellar","List All Offers") | 12 | | Try It | [Docs](/providers/stellar/list-all-trades) | **List All Trades** | =CSQUERY("Stellar","List All Trades") | =CSPARAMETERS("Stellar","List All Trades") | 9 | | Try It | [Docs](/providers/stellar/list-all-assets) | **List All Assets** | =CSQUERY("Stellar","List All Assets") | =CSPARAMETERS("Stellar","List All Assets") | 6 | | Try It | [Docs](/providers/stellar/retrieve-a-claimable-balance) | **Retrieve a Claimable Balance** | =CSQUERY("Stellar","Retrieve a Claimable Balance") | =CSPARAMETERS("Stellar","Retrieve a Claimable Balance") | 1 | | Try It | [Docs](/providers/stellar/list-claimable-balances) | **List Claimable Balances** | =CSQUERY("Stellar","List Claimable Balances") | =CSPARAMETERS("Stellar","List Claimable Balances") | 6 | | Try It | [Docs](/providers/stellar/retrieve-an-order-book) | **Retrieve an Order Book** | =CSQUERY("Stellar","Retrieve an Order Book") | =CSPARAMETERS("Stellar","Retrieve an Order Book") | 6 | | Try It | [Docs](/providers/stellar/list-strict-receive-payment-paths) | **List Strict Receive Payment Paths** | =CSQUERY("Stellar","List Strict Receive Payment Paths") | =CSPARAMETERS("Stellar","List Strict Receive Payment Paths") | 6 | | Try It | [Docs](/providers/stellar/list-strict-send-payment-paths) | **List Strict Send Payment Paths** | =CSQUERY("Stellar","List Strict Send Payment Paths") | =CSPARAMETERS("Stellar","List Strict Send Payment Paths") | 6 | | Try It | [Docs](/providers/stellar/list-trade-aggregations) | **List Trade Aggregations** | =CSQUERY("Stellar","List Trade Aggregations") | =CSPARAMETERS("Stellar","List Trade Aggregations") | 12 | | Try It | [Docs](/providers/stellar/fee-stats) | **Fee Stats** | =CSQUERY("Stellar","Fee Stats") | =CSPARAMETERS("Stellar","Fee Stats") | 0 |

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