> Trustless margin trading, borrowing, and lending built on Ethereum & Web3 Find examples for accessing every **dYdX** 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/dydx/markets) | **Markets** | =CS.QUERY("dYdX","Markets") | =CS.PARAMETERS("dYdX","Markets") | 0 | | Try It | [Docs](/providers/dydx/stats-market) | **Stats Market** | =CS.QUERY("dYdX","Stats Market") | =CS.PARAMETERS("dYdX","Stats Market") | 0 | | Try It | [Docs](/providers/dydx/fills) | **Fills** | =CS.QUERY("dYdX","Fills") | =CS.PARAMETERS("dYdX","Fills") | 6 | | Try It | [Docs](/providers/dydx/trades) | **Trades** | =CS.QUERY("dYdX","Trades") | =CS.PARAMETERS("dYdX","Trades") | 5 | | Try It | [Docs](/providers/dydx/candles) | **Candles** | =CS.QUERY("dYdX","Candles") | =CS.PARAMETERS("dYdX","Candles") | 3 | | Try It | [Docs](/providers/dydx/orders) | **Orders** | =CS.QUERY("dYdX","Orders") | =CS.PARAMETERS("dYdX","Orders") | 8 | | Try It | [Docs](/providers/dydx/order-book) | **Order Book** | =CS.QUERY("dYdX","Order Book") | =CS.PARAMETERS("dYdX","Order Book") | 1 | | Try It | [Docs](/providers/dydx/standard-actions) | **Standard Actions** | =CS.QUERY("dYdX","Standard Actions") | =CS.PARAMETERS("dYdX","Standard Actions") | 7 | | Try It | [Docs](/providers/dydx/markets-v2) | **Markets V2** | =CS.QUERY("dYdX","Markets V2") | =CS.PARAMETERS("dYdX","Markets V2") | 0 | | Try It | [Docs](/providers/dydx/market-v2) | **Market V2** | =CS.QUERY("dYdX","Market V2") | =CS.PARAMETERS("dYdX","Market V2") | 1 | | Try It | [Docs](/providers/dydx/account) | **Account** | =CS.QUERY("dYdX","Account") | =CS.PARAMETERS("dYdX","Account") | 2 | | Try It | [Docs](/providers/dydx/accounts) | **Accounts** | =CS.QUERY("dYdX","Accounts") | =CS.PARAMETERS("dYdX","Accounts") | 3 | | Try It | [Docs](/providers/dydx/market) | **Market** | =CS.QUERY("dYdX","Market") | =CS.PARAMETERS("dYdX","Market") | 1 | | Try It | [Docs](/providers/dydx/balance-updates) | **Balance Updates** | =CS.QUERY("dYdX","Balance Updates") | =CS.PARAMETERS("dYdX","Balance Updates") | 4 | | Try It | [Docs](/providers/dydx/positions) | **Positions** | =CS.QUERY("dYdX","Positions") | =CS.PARAMETERS("dYdX","Positions") | 6 | | Try It | [Docs](/providers/dydx/perpetual-markets) | **Perpetual Markets** | =CS.QUERY("dYdX","Perpetual Markets") | =CS.PARAMETERS("dYdX","Perpetual Markets") | 0 | | Try It | [Docs](/providers/dydx/perpetual-market) | **Perpetual Market** | =CS.QUERY("dYdX","Perpetual Market") | =CS.PARAMETERS("dYdX","Perpetual Market") | 1 | | Try It | [Docs](/providers/dydx/perpetual-balance-updates) | **Perpetual Balance Updates** | =CS.QUERY("dYdX","Perpetual Balance Updates") | =CS.PARAMETERS("dYdX","Perpetual Balance Updates") | 3 | | Try It | [Docs](/providers/dydx/perpetual-account-from-wallet) | **Perpetual Account from Wallet** | =CS.QUERY("dYdX","Perpetual Account from Wallet") | =CS.PARAMETERS("dYdX","Perpetual Account from Wallet") | 1 | | Try It | [Docs](/providers/dydx/perpetual-accounts) | **Perpetual Accounts** | =CS.QUERY("dYdX","Perpetual Accounts") | =CS.PARAMETERS("dYdX","Perpetual Accounts") | 0 | | Try It | [Docs](/providers/dydx/funding-rates) | **Funding Rates** | =CS.QUERY("dYdX","Funding Rates") | =CS.PARAMETERS("dYdX","Funding Rates") | 1 | | Try It | [Docs](/providers/dydx/historical-funding-rates) | **Historical Funding Rates** | =CS.QUERY("dYdX","Historical Funding Rates") | =CS.PARAMETERS("dYdX","Historical Funding Rates") | 3 | | Try It | [Docs](/providers/dydx/index-price) | **Index Price** | =CS.QUERY("dYdX","Index Price") | =CS.PARAMETERS("dYdX","Index Price") | 0 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/dydx/markets) | **Markets** | =CSQUERY("dYdX","Markets") | =CSPARAMETERS("dYdX","Markets") | 0 | | Try It | [Docs](/providers/dydx/stats-market) | **Stats Market** | =CSQUERY("dYdX","Stats Market") | =CSPARAMETERS("dYdX","Stats Market") | 0 | | Try It | [Docs](/providers/dydx/fills) | **Fills** | =CSQUERY("dYdX","Fills") | =CSPARAMETERS("dYdX","Fills") | 6 | | Try It | [Docs](/providers/dydx/trades) | **Trades** | =CSQUERY("dYdX","Trades") | =CSPARAMETERS("dYdX","Trades") | 5 | | Try It | [Docs](/providers/dydx/candles) | **Candles** | =CSQUERY("dYdX","Candles") | =CSPARAMETERS("dYdX","Candles") | 3 | | Try It | [Docs](/providers/dydx/orders) | **Orders** | =CSQUERY("dYdX","Orders") | =CSPARAMETERS("dYdX","Orders") | 8 | | Try It | [Docs](/providers/dydx/order-book) | **Order Book** | =CSQUERY("dYdX","Order Book") | =CSPARAMETERS("dYdX","Order Book") | 1 | | Try It | [Docs](/providers/dydx/standard-actions) | **Standard Actions** | =CSQUERY("dYdX","Standard Actions") | =CSPARAMETERS("dYdX","Standard Actions") | 7 | | Try It | [Docs](/providers/dydx/markets-v2) | **Markets V2** | =CSQUERY("dYdX","Markets V2") | =CSPARAMETERS("dYdX","Markets V2") | 0 | | Try It | [Docs](/providers/dydx/market-v2) | **Market V2** | =CSQUERY("dYdX","Market V2") | =CSPARAMETERS("dYdX","Market V2") | 1 | | Try It | [Docs](/providers/dydx/account) | **Account** | =CSQUERY("dYdX","Account") | =CSPARAMETERS("dYdX","Account") | 2 | | Try It | [Docs](/providers/dydx/accounts) | **Accounts** | =CSQUERY("dYdX","Accounts") | =CSPARAMETERS("dYdX","Accounts") | 3 | | Try It | [Docs](/providers/dydx/market) | **Market** | =CSQUERY("dYdX","Market") | =CSPARAMETERS("dYdX","Market") | 1 | | Try It | [Docs](/providers/dydx/balance-updates) | **Balance Updates** | =CSQUERY("dYdX","Balance Updates") | =CSPARAMETERS("dYdX","Balance Updates") | 4 | | Try It | [Docs](/providers/dydx/positions) | **Positions** | =CSQUERY("dYdX","Positions") | =CSPARAMETERS("dYdX","Positions") | 6 | | Try It | [Docs](/providers/dydx/perpetual-markets) | **Perpetual Markets** | =CSQUERY("dYdX","Perpetual Markets") | =CSPARAMETERS("dYdX","Perpetual Markets") | 0 | | Try It | [Docs](/providers/dydx/perpetual-market) | **Perpetual Market** | =CSQUERY("dYdX","Perpetual Market") | =CSPARAMETERS("dYdX","Perpetual Market") | 1 | | Try It | [Docs](/providers/dydx/perpetual-balance-updates) | **Perpetual Balance Updates** | =CSQUERY("dYdX","Perpetual Balance Updates") | =CSPARAMETERS("dYdX","Perpetual Balance Updates") | 3 | | Try It | [Docs](/providers/dydx/perpetual-account-from-wallet) | **Perpetual Account from Wallet** | =CSQUERY("dYdX","Perpetual Account from Wallet") | =CSPARAMETERS("dYdX","Perpetual Account from Wallet") | 1 | | Try It | [Docs](/providers/dydx/perpetual-accounts) | **Perpetual Accounts** | =CSQUERY("dYdX","Perpetual Accounts") | =CSPARAMETERS("dYdX","Perpetual Accounts") | 0 | | Try It | [Docs](/providers/dydx/funding-rates) | **Funding Rates** | =CSQUERY("dYdX","Funding Rates") | =CSPARAMETERS("dYdX","Funding Rates") | 1 | | Try It | [Docs](/providers/dydx/historical-funding-rates) | **Historical Funding Rates** | =CSQUERY("dYdX","Historical Funding Rates") | =CSPARAMETERS("dYdX","Historical Funding Rates") | 3 | | Try It | [Docs](/providers/dydx/index-price) | **Index Price** | =CSQUERY("dYdX","Index Price") | =CSPARAMETERS("dYdX","Index Price") | 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 dYdX Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `dYdX` `provider`