Transactions by Wallet
Get Transactions for a Single Wallet. Returns all transactions involving a given address.
How to use Treehouse data in Excel & Googlesheets with Cryptosheets
This article demonstrates three examples of how to pull Treehouse API data into your spreadsheet using the side panel console
, custom functions
and templates
.
![](https://res.cloudinary.com/cryptosheets/image/upload/v1/cryptosheets-docs/providers/treehouse/console/transactions-by-wallet.gif)
Explore more Treehouse endpoints here
Example Parameters:
- access_key:
YOUR_ACCESS_KEY
- wallet:
0xd3f96a64d33ebeed09b9dd319fdbd1651ce319eb
- chains:
eth
- start_time:
1668130850
- end_time:
1673314850
- page:
1
- pageSize:
20
Example Fields:
This endpoint has no fields.
Excel:
=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"})
Googlesheets:
=CSQUERY("Treehouse","Transactions by Wallet",{"access_key","YOUR_ACCESS_KEY";"wallet","0xd3f96a64d33ebeed09b9dd319fdbd1651ce319eb";"chains","eth";"start_time","1668130850";"end_time","1673314850";"page","1";"pageSize","20"})
NOTE: Some international users may need to substitute commas
","
in custom functions with semicolons";"
so for something like=CS.TA("BTC","USD")
try=CS.TA("BTC";"USD")
instead
Usage
Cryptosheets data can be pulled through multiple interfaces:
Setup
Setup
-
Install the Cryptosheets add-in from the Microsoft AppSource Store
-
Install the Cryptosheets add-in from the Google GSuite Marketplace
-
After it is installed, make sure you are logged into your Cryptosheets account through the Cryptosheets side panel
Using the console
Using the console
- From the Cryptosheets Excel ribbon click
data
- From the Googlesheets Add-ons menu click
Cryptosheets
then selectLaunch side-bar
- Type in
Treehouse...
then click onTransactions by Wallet
- Scroll through the console parameters and input your values
- Select the cell you want to place the data into
- Click
make request
![](https://res.cloudinary.com/cryptosheets/image/upload/v1568230681/cryptosheets-docs/providers/treehouse/console/transactions-by-wallet.gif)
Using custom functions
Using custom functions
Tip: For both Excel and Googlesheeets you can use either the QUERY or QUERYA custom function
- Excel In any cell type the following:
=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"})
- Googlesheets In any cell type the following:
=CSQUERY("Treehouse","Transactions by Wallet",{"access_key","YOUR_ACCESS_KEY";"wallet","0xd3f96a64d33ebeed09b9dd319fdbd1651ce319eb";"chains","eth";"start_time","1668130850";"end_time","1673314850";"page","1";"pageSize","20"})
- In any console, after selecting the parameters to configure the query string as desired, simply click the radio button to toggle the the
function/formula builder
, then click theclipboard icon
to copy the full formula string and paste it into any cell see detailed examples and tutorial
![](https://downloads.intercomcdn.com/i/o/161179379/577ba7c6149cd8827b598623/image.png)
Hint: If you need help remembering the exact parameters for any function, you can always just type in any cell:
=CS.PARAMETERS("Treehouse","Transactions by Wallet")
for Excel or=CSPARAMETERS("Treehouse","Transactions by Wallet")
for Googlesheets
![](https://res.cloudinary.com/cryptosheets/image/upload/v1/cryptosheets-docs/providers/treehouse/functions/transactions-by-wallet.gif)
Using templates
Using templates
- From the Cryptosheets Excel ribbon click
templates
OR click on thetemplates tab
in the browse section - From the Googlesheets Add-ons menu click
Cryptosheets
then selectTemplates
- Load the template called
Query Builder
and type Treehouse and Transactions by Wallet - You can also try searching "Treehouse..." for other templates
![](https://res.cloudinary.com/cryptosheets/image/upload/v1/cryptosheets-docs/templates/gifs/query-builder-provider-endpoint.gif)
Signing up for Cryptosheets is free get crypto data in 30 seconds or less
Note: you must have one of the supported versions of Microsoft Office or Excel for custom functions to work. Learn more here
Helpful Resources:
- Visit the API documentation for Treehouse here
- See tutorials and examples for Treehouse on the Cryptosheets YouTube channel
- Troubleshooting: please reference the following troubleshooting code: QUE-1919-7232. Learn more here
Tags: Transactions by Wallet
Treehouse
endpoint