Excel

Google Sheets

> The most comprehensive platform to monitor your DeFi investments for the productive investor using enterprise-level portfolio analytics tools, built with institutions in mind

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Treehouse">Treehouse</a>** endpoint using **Cryptosheets** through:

- `side panel console`
- `custom functions` (Excel & Googlesheets)
- `templates`

## Excel

<div class="markdown">

| App Url                                                                                 | Docs Url                                                                                 | Name                        | Example                                             | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | --------   | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/All%20Positions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/all-positions) | **All Positions** | <inline-code functionvalue='=CS.QUERY("Treehouse","All Positions",{"access_key","YOUR_ACCESS_KEY";"wallet","0xd3f96a64d33ebeed09b9dd319fdbd1651ce319eb";"chains","eth";"date","2023-01-01"})'>=CS.QUERY("Treehouse","All Positions")</inline-code> | <inline-code>=CS.PARAMETERS("Treehouse","All Positions")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Positions%20by%20Underlying" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/positions-by-underlying) | **Positions by Underlying** | <inline-code functionvalue='=CS.QUERY("Treehouse","Positions by Underlying",{"access_key","YOUR_ACCESS_KEY";"wallet","0xd3f96a64d33ebeed09b9dd319fdbd1651ce319eb";"chains","eth";"date","2023-01-01"})'>=CS.QUERY("Treehouse","Positions by Underlying")</inline-code> | <inline-code>=CS.PARAMETERS("Treehouse","Positions by Underlying")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Transactions%20by%20Wallet" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/transactions-by-wallet) | **Transactions by Wallet** | <inline-code functionvalue='=CS.QUERY("Treehouse","Transactions by Wallet",{"access_key","YOUR_ACCESS_KEY";"wallet","0xd3f96a64d33ebeed09b9dd319fdbd1651ce319eb";"chains","eth";"start_time","1668130850";"end_time","1673314850";"page","1";"pageSize","20"})'>=CS.QUERY("Treehouse","Transactions by Wallet")</inline-code> | <inline-code>=CS.PARAMETERS("Treehouse","Transactions by Wallet")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Logs%20by%20Transaction%20Hash" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/logs-by-transaction-hash) | **Logs by Transaction Hash** | <inline-code functionvalue='=CS.QUERY("Treehouse","Logs by Transaction Hash",{"access_key","YOUR_ACCESS_KEY";"txn_hash","0x09962215cfea375f4fd3767703327f1796ed01f876b794b9bca272cbb0d3a628";"chain_id","eth";"page","1";"pageSize","20"})'>=CS.QUERY("Treehouse","Logs by Transaction Hash")</inline-code> | <inline-code>=CS.PARAMETERS("Treehouse","Logs by Transaction Hash")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Get%20Supported%20Chains" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/get-supported-chains) | **Get Supported Chains** | <inline-code functionvalue='=CS.QUERY("Treehouse","Get Supported Chains",{"access_key","YOUR_ACCESS_KEY"})'>=CS.QUERY("Treehouse","Get Supported Chains")</inline-code> | <inline-code>=CS.PARAMETERS("Treehouse","Get Supported Chains")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Get%20Supported%20Protocols" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/get-supported-protocols) | **Get Supported Protocols** | <inline-code functionvalue='=CS.QUERY("Treehouse","Get Supported Protocols",{"access_key","YOUR_ACCESS_KEY";"chain_id","eth"})'>=CS.QUERY("Treehouse","Get Supported Protocols")</inline-code> | <inline-code>=CS.PARAMETERS("Treehouse","Get Supported Protocols")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Get%20Supported%20Tokens" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/get-supported-tokens) | **Get Supported Tokens** | <inline-code functionvalue='=CS.QUERY("Treehouse","Get Supported Tokens",{"access_key","YOUR_ACCESS_KEY";"chain_id","eth"})'>=CS.QUERY("Treehouse","Get Supported Tokens")</inline-code> | <inline-code>=CS.PARAMETERS("Treehouse","Get Supported Tokens")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Get%20Supported%20Contracts" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/get-supported-contracts) | **Get Supported Contracts** | <inline-code functionvalue='=CS.QUERY("Treehouse","Get Supported Contracts",{"access_key","YOUR_ACCESS_KEY";"chain_id","eth";"protocol_id","Balancer"})'>=CS.QUERY("Treehouse","Get Supported Contracts")</inline-code> | <inline-code>=CS.PARAMETERS("Treehouse","Get Supported Contracts")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Get%20Method%20Hex%20by%20Action%20Type" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/get-method-hex-by-action-type) | **Get Method Hex by Action Type** | <inline-code functionvalue='=CS.QUERY("Treehouse","Get Method Hex by Action Type",{"access_key","YOUR_ACCESS_KEY";"action_type","config";"page","1";"pageSize","20"})'>=CS.QUERY("Treehouse","Get Method Hex by Action Type")</inline-code> | <inline-code>=CS.PARAMETERS("Treehouse","Get Method Hex by Action Type")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Get%20Action%20Type%20by%20Method%20Hex" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/get-action-type-by-method-hex) | **Get Action Type by Method Hex** | <inline-code functionvalue='=CS.QUERY("Treehouse","Get Action Type by Method Hex",{"access_key","YOUR_ACCESS_KEY";"method_hex","0x4a420138";"page","1";"pageSize","20"})'>=CS.QUERY("Treehouse","Get Action Type by Method Hex")</inline-code> | <inline-code>=CS.PARAMETERS("Treehouse","Get Action Type by Method Hex")</inline-code> | 4 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/All%20Positions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/all-positions) | **All Positions** | <inline-code functionvalue='=CSQUERY("Treehouse","All Positions",{"access_key","YOUR_ACCESS_KEY";"wallet","0xd3f96a64d33ebeed09b9dd319fdbd1651ce319eb";"chains","eth";"date","2023-01-01"})'>=CSQUERY("Treehouse","All Positions")</inline-code> | <inline-code>=CSPARAMETERS("Treehouse","All Positions")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Positions%20by%20Underlying" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/positions-by-underlying) | **Positions by Underlying** | <inline-code functionvalue='=CSQUERY("Treehouse","Positions by Underlying",{"access_key","YOUR_ACCESS_KEY";"wallet","0xd3f96a64d33ebeed09b9dd319fdbd1651ce319eb";"chains","eth";"date","2023-01-01"})'>=CSQUERY("Treehouse","Positions by Underlying")</inline-code> | <inline-code>=CSPARAMETERS("Treehouse","Positions by Underlying")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Transactions%20by%20Wallet" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/transactions-by-wallet) | **Transactions by Wallet** | <inline-code functionvalue='=CSQUERY("Treehouse","Transactions by Wallet",{"access_key","YOUR_ACCESS_KEY";"wallet","0xd3f96a64d33ebeed09b9dd319fdbd1651ce319eb";"chains","eth";"start_time","1668130850";"end_time","1673314850";"page","1";"pageSize","20"})'>=CSQUERY("Treehouse","Transactions by Wallet")</inline-code> | <inline-code>=CSPARAMETERS("Treehouse","Transactions by Wallet")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Logs%20by%20Transaction%20Hash" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/logs-by-transaction-hash) | **Logs by Transaction Hash** | <inline-code functionvalue='=CSQUERY("Treehouse","Logs by Transaction Hash",{"access_key","YOUR_ACCESS_KEY";"txn_hash","0x09962215cfea375f4fd3767703327f1796ed01f876b794b9bca272cbb0d3a628";"chain_id","eth";"page","1";"pageSize","20"})'>=CSQUERY("Treehouse","Logs by Transaction Hash")</inline-code> | <inline-code>=CSPARAMETERS("Treehouse","Logs by Transaction Hash")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Get%20Supported%20Chains" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/get-supported-chains) | **Get Supported Chains** | <inline-code functionvalue='=CSQUERY("Treehouse","Get Supported Chains",{"access_key","YOUR_ACCESS_KEY"})'>=CSQUERY("Treehouse","Get Supported Chains")</inline-code> | <inline-code>=CSPARAMETERS("Treehouse","Get Supported Chains")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Get%20Supported%20Protocols" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/get-supported-protocols) | **Get Supported Protocols** | <inline-code functionvalue='=CSQUERY("Treehouse","Get Supported Protocols",{"access_key","YOUR_ACCESS_KEY";"chain_id","eth"})'>=CSQUERY("Treehouse","Get Supported Protocols")</inline-code> | <inline-code>=CSPARAMETERS("Treehouse","Get Supported Protocols")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Get%20Supported%20Tokens" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/get-supported-tokens) | **Get Supported Tokens** | <inline-code functionvalue='=CSQUERY("Treehouse","Get Supported Tokens",{"access_key","YOUR_ACCESS_KEY";"chain_id","eth"})'>=CSQUERY("Treehouse","Get Supported Tokens")</inline-code> | <inline-code>=CSPARAMETERS("Treehouse","Get Supported Tokens")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Get%20Supported%20Contracts" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/get-supported-contracts) | **Get Supported Contracts** | <inline-code functionvalue='=CSQUERY("Treehouse","Get Supported Contracts",{"access_key","YOUR_ACCESS_KEY";"chain_id","eth";"protocol_id","Balancer"})'>=CSQUERY("Treehouse","Get Supported Contracts")</inline-code> | <inline-code>=CSPARAMETERS("Treehouse","Get Supported Contracts")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Get%20Method%20Hex%20by%20Action%20Type" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/get-method-hex-by-action-type) | **Get Method Hex by Action Type** | <inline-code functionvalue='=CSQUERY("Treehouse","Get Method Hex by Action Type",{"access_key","YOUR_ACCESS_KEY";"action_type","config";"page","1";"pageSize","20"})'>=CSQUERY("Treehouse","Get Method Hex by Action Type")</inline-code> | <inline-code>=CSPARAMETERS("Treehouse","Get Method Hex by Action Type")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Treehouse/Get%20Action%20Type%20by%20Method%20Hex" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/treehouse/get-action-type-by-method-hex) | **Get Action Type by Method Hex** | <inline-code functionvalue='=CSQUERY("Treehouse","Get Action Type by Method Hex",{"access_key","YOUR_ACCESS_KEY";"method_hex","0x4a420138";"page","1";"pageSize","20"})'>=CSQUERY("Treehouse","Get Action Type by Method Hex")</inline-code> | <inline-code>=CSPARAMETERS("Treehouse","Get Action Type by Method Hex")</inline-code> | 4 |

</div>

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less

**<a href="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=docs-Treehouse">Get Cryptosheets for Microsoft Excel</a>**

**<a href="https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?hl=en&pann=sheets_addon_widget?src=docs-Treehouse">Get Cryptosheets for Googlesheets</a>**

\*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

**<a href="https://api-docs.treehouse.finance/apis-by-treehouse/">Click here</a>** for additional documentation from Treehouse

Learn more [here](https://intercom.help/cryptosheets/en/)

---

Tags: `Treehouse` `provider` 


How to pull Treehouse data into Excel and Google Sheets