Vaults Apy

Setup

1. Install the Cryptosheets add-in from the [Microsoft AppSource Store](https://appsource.microsoft.com/en-us/product/office/WA104381695?src=intercom-Yearn API)

2. Install the Cryptosheets add-in from the [Google GSuite Marketplace](https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?src=intercom-Yearn API)

3. After it is installed, make sure you are logged into your Cryptosheets account through the Cryptosheets side panel

   

Using the console

1. From the Cryptosheets Excel ribbon click data
2. From the Googlesheets Add-ons menu click Cryptosheets then select Launch side-bar
3. Type in Yearn API... then click on Vaults Apy
4. Scroll through the console parameters and input your values
5. Select the cell you want to place the data into
6. Click make request

Using custom functions

Tip: For both Excel and Googlesheeets you can use either the QUERY or QUERYA custom function

1. Excel In any cell type the following:

=CS.QUERY("Yearn API","Vaults Apy",{})

2. Googlesheets In any cell type the following:

=CSQUERY("Yearn API","Vaults Apy",{})

3. 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 the clipboard icon to copy the full formula string and paste it into any cell see detailed examples and tutorial

Hint: If you need help remembering the exact parameters for any function, you can always just type in any cell: =CS.PARAMETERS("Yearn API","Vaults Apy") for Excel or =CSPARAMETERS("Yearn API","Vaults Apy") for Googlesheets

Using templates

1. From the Cryptosheets Excel ribbon click templates OR click on the templates tab in the browse section
2. From the Googlesheets Add-ons menu click Cryptosheets then select Templates
3. Load the template called Query Builder and type Yearn API and Vaults Apy
4. You can also try searching "Yearn API..." for other templates