Excel

Google Sheets

> Alpha DeFi is a digital asset manager that combines over 20 years of experience in legacy finance with the newest and most cutting edge investment strategies in the world of digital assets with secured infrastructure on the Terra LUNA blockchain

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi">Alpha DeFi</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/Alpha%20DeFi/Historical%20Long%20APRs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/historical-long-aprs) | **Historical Long APRs** | <inline-code functionvalue='=CS.QUERY("Alpha DeFi","Historical Long APRs",{"ticker","mAAPL";"from","2021-08-10T01:00:00.000Z";"to","2021-08-14T01:00:00.000Z"})'>=CS.QUERY("Alpha DeFi","Historical Long APRs")</inline-code> | <inline-code>=CS.PARAMETERS("Alpha DeFi","Historical Long APRs")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Historical%20Short%20APRs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/historical-short-aprs) | **Historical Short APRs** | <inline-code functionvalue='=CS.QUERY("Alpha DeFi","Historical Short APRs",{"ticker","mAAPL";"from","2021-08-10T01:00:00.000Z";"to","2021-08-14T01:00:00.000Z"})'>=CS.QUERY("Alpha DeFi","Historical Short APRs")</inline-code> | <inline-code>=CS.PARAMETERS("Alpha DeFi","Historical Short APRs")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Historical%20Spread%20Statistics" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/historical-spread-statistics) | **Historical Spread Statistics** | <inline-code functionvalue='=CS.QUERY("Alpha DeFi","Historical Spread Statistics")'>=CS.QUERY("Alpha DeFi","Historical Spread Statistics")</inline-code> | <inline-code>=CS.PARAMETERS("Alpha DeFi","Historical Spread Statistics")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Token%20Dictionary" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/token-dictionary) | **Token Dictionary** | <inline-code functionvalue='=CS.QUERY("Alpha DeFi","Token Dictionary")'>=CS.QUERY("Alpha DeFi","Token Dictionary")</inline-code> | <inline-code>=CS.PARAMETERS("Alpha DeFi","Token Dictionary")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Rolling%2021%20Day%20Long%20APR%20Volatily%20Rankings" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/rolling-21-day-long-apr-volatily-rankings) | **Rolling 21 Day Long APR Volatily Rankings** | <inline-code functionvalue='=CS.QUERY("Alpha DeFi","Rolling 21 Day Long APR Volatily Rankings")'>=CS.QUERY("Alpha DeFi","Rolling 21 Day Long APR Volatily Rankings")</inline-code> | <inline-code>=CS.PARAMETERS("Alpha DeFi","Rolling 21 Day Long APR Volatily Rankings")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Rolling%2021%20Day%20Short%20APR%20Volatily%20Rankings" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/rolling-21-day-short-apr-volatily-rankings) | **Rolling 21 Day Short APR Volatily Rankings** | <inline-code functionvalue='=CS.QUERY("Alpha DeFi","Rolling 21 Day Short APR Volatily Rankings")'>=CS.QUERY("Alpha DeFi","Rolling 21 Day Short APR Volatily Rankings")</inline-code> | <inline-code>=CS.PARAMETERS("Alpha DeFi","Rolling 21 Day Short APR Volatily Rankings")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Historical%20Commission%20APRs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/historical-commission-aprs) | **Historical Commission APRs** | <inline-code functionvalue='=CS.QUERY("Alpha DeFi","Historical Commission APRs",{"ticker","mAAPL";"from","2021-08-10T01:00:00.000Z";"to","2021-08-14T01:00:00.000Z"})'>=CS.QUERY("Alpha DeFi","Historical Commission APRs")</inline-code> | <inline-code>=CS.PARAMETERS("Alpha DeFi","Historical Commission APRs")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Historical%20Total%20Value%20Locked" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/historical-total-value-locked) | **Historical Total Value Locked** | <inline-code functionvalue='=CS.QUERY("Alpha DeFi","Historical Total Value Locked",{"ticker","mAAPL";"from","2021-08-10T01:00:00.000Z";"to","2021-08-14T01:00:00.000Z"})'>=CS.QUERY("Alpha DeFi","Historical Total Value Locked")</inline-code> | <inline-code>=CS.PARAMETERS("Alpha DeFi","Historical Total Value Locked")</inline-code> | 3 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Historical%20Long%20APRs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/historical-long-aprs) | **Historical Long APRs** | <inline-code functionvalue='=CSQUERY("Alpha DeFi","Historical Long APRs",{"ticker","mAAPL";"from","2021-08-10T01:00:00.000Z";"to","2021-08-14T01:00:00.000Z"})'>=CSQUERY("Alpha DeFi","Historical Long APRs")</inline-code> | <inline-code>=CSPARAMETERS("Alpha DeFi","Historical Long APRs")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Historical%20Short%20APRs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/historical-short-aprs) | **Historical Short APRs** | <inline-code functionvalue='=CSQUERY("Alpha DeFi","Historical Short APRs",{"ticker","mAAPL";"from","2021-08-10T01:00:00.000Z";"to","2021-08-14T01:00:00.000Z"})'>=CSQUERY("Alpha DeFi","Historical Short APRs")</inline-code> | <inline-code>=CSPARAMETERS("Alpha DeFi","Historical Short APRs")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Historical%20Spread%20Statistics" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/historical-spread-statistics) | **Historical Spread Statistics** | <inline-code functionvalue='=CSQUERY("Alpha DeFi","Historical Spread Statistics")'>=CSQUERY("Alpha DeFi","Historical Spread Statistics")</inline-code> | <inline-code>=CSPARAMETERS("Alpha DeFi","Historical Spread Statistics")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Token%20Dictionary" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/token-dictionary) | **Token Dictionary** | <inline-code functionvalue='=CSQUERY("Alpha DeFi","Token Dictionary")'>=CSQUERY("Alpha DeFi","Token Dictionary")</inline-code> | <inline-code>=CSPARAMETERS("Alpha DeFi","Token Dictionary")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Rolling%2021%20Day%20Long%20APR%20Volatily%20Rankings" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/rolling-21-day-long-apr-volatily-rankings) | **Rolling 21 Day Long APR Volatily Rankings** | <inline-code functionvalue='=CSQUERY("Alpha DeFi","Rolling 21 Day Long APR Volatily Rankings")'>=CSQUERY("Alpha DeFi","Rolling 21 Day Long APR Volatily Rankings")</inline-code> | <inline-code>=CSPARAMETERS("Alpha DeFi","Rolling 21 Day Long APR Volatily Rankings")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Rolling%2021%20Day%20Short%20APR%20Volatily%20Rankings" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/rolling-21-day-short-apr-volatily-rankings) | **Rolling 21 Day Short APR Volatily Rankings** | <inline-code functionvalue='=CSQUERY("Alpha DeFi","Rolling 21 Day Short APR Volatily Rankings")'>=CSQUERY("Alpha DeFi","Rolling 21 Day Short APR Volatily Rankings")</inline-code> | <inline-code>=CSPARAMETERS("Alpha DeFi","Rolling 21 Day Short APR Volatily Rankings")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Historical%20Commission%20APRs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/historical-commission-aprs) | **Historical Commission APRs** | <inline-code functionvalue='=CSQUERY("Alpha DeFi","Historical Commission APRs",{"ticker","mAAPL";"from","2021-08-10T01:00:00.000Z";"to","2021-08-14T01:00:00.000Z"})'>=CSQUERY("Alpha DeFi","Historical Commission APRs")</inline-code> | <inline-code>=CSPARAMETERS("Alpha DeFi","Historical Commission APRs")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Alpha%20DeFi/Historical%20Total%20Value%20Locked" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/alpha-defi/historical-total-value-locked) | **Historical Total Value Locked** | <inline-code functionvalue='=CSQUERY("Alpha DeFi","Historical Total Value Locked",{"ticker","mAAPL";"from","2021-08-10T01:00:00.000Z";"to","2021-08-14T01:00:00.000Z"})'>=CSQUERY("Alpha DeFi","Historical Total Value Locked")</inline-code> | <inline-code>=CSPARAMETERS("Alpha DeFi","Historical Total Value Locked")</inline-code> | 3 |

</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-Alpha DeFi">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-Alpha DeFi">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://alphadefi.fund/">Click here</a>** for additional documentation from Alpha DeFi

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

---

Tags: `Alpha DeFi` `provider` 


How to pull Alpha DeFi data into Excel and Google Sheets