Markets V2

<nav class="toc"><ol class="toc-level toc-level-1"><li class="toc-item toc-item-h2"><a class="toc-link toc-link-h2" href="#how-to-use-dydx-data-in-excel--googlesheets-with-cryptosheets">How to use dYdX data in Excel &#x26; Googlesheets with Cryptosheets</a></li><li class="toc-item toc-item-h2"><a class="toc-link toc-link-h2" href="#example-parameters">Example Parameters:</a></li><li class="toc-item toc-item-h2"><a class="toc-link toc-link-h2" href="#usage">Usage</a><ol class="toc-level toc-level-2"><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#setup">Setup</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#using-the-console">Using the console</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#using-custom-functions">Using custom functions</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#using-templates">Using templates</a></li></ol></li><li class="toc-item toc-item-h2"><a class="toc-link toc-link-h2" href="#helpful-resources">Helpful Resources:</a></li></ol></nav><blockquote> <p>Get high-level information on all Solo markets.</p> </blockquote> <h2 id="how-to-use-dydx-data-in-excel--googlesheets-with-cryptosheets">How to use dYdX data in Excel &#x26; Googlesheets with Cryptosheets</h2> <p>This article demonstrates three examples of how to pull dYdX data into your spreadsheet using the <code>side panel console</code>, <code>custom functions</code> and <code>templates</code>.</p> <p>Explore more dYdX endpoints <a href="">here</a></p> <h2 id="example-parameters">Example Parameters:</h2> <ul> <li>market: <code>WETH-DAI</code></li> </ul> <h2 id="usage">Usage</h2> <p>Cryptosheets data can be pulled through multiple surfaces:</p> <h3 id="setup">Setup</h3> <ol> <li> <p>Install the Cryptosheets add-in from Microsoft <a href="">AppSource Store</a></p> </li> <li> <p>Make sure you are logged into your Cryptosheets account</p> </li> </ol> <h3 id="using-the-console">Using the console</h3> <ol> <li>From the Cryptosheets ribbon click <code>data</code></li> <li>Type in type in "dYdX..." then click on <code>Markets V2</code> </li> <li>Scroll through the console parameters and input your values</li> <li>Select the cell you want to place the data into</li> <li>Click <code>make request</code></li> </ol> <p><a href=""><img src="" alt="img"></a></p> <h3 id="using-custom-functions">Using custom functions</h3> <ol> <li>In any cell type the following: <code>=CS.QUERY("dYdX","Markets V2",{"market","WETH-DAI"})</code></li> <li>In any console, after selecting the parameters to configure the query string as desired, simply click the radio button to toggle the the <code>function/formula builder</code>, then click the <code>clipboard icon</code> to copy the full formula string and paste it into any cell <a href="">see detailed examples and tutorial</a></li> </ol> <blockquote> <p><strong>Hint</strong>: If you need help remembering the exact parameters for any function, you can always just type in any cell: <code>=CS.PARAMETERS("dYdX","Markets V2")</code></p> </blockquote> <h3 id="using-templates">Using templates</h3> <ol> <li>From the Cryptosheets ribbon click <code>templates</code> OR click on the <code>templates tab</code> in the browse section</li> <li>Load the template called <code>Query Builder</code> and type dYdX and Markets V2</li> <li>You can also try searching "dYdX..." for other templates specific or related to <code>Get Gains</code> </li> </ol> <p><a href="">Signing up for Cryptosheets is free</a> get crypto data in 30 seconds or less</p> <blockquote> <p>Note: you must have one of the <a href="">supported versions</a> of Microsoft Office or Excel for custom functions to work. Learn more <a href="">here</a></p> </blockquote> <h2 id="helpful-resources">Helpful Resources:</h2> <p>Visit the API documentation for dYdX <a href="">here</a></p> <p>Troubleshooting: please reference the following troubleshooting code: QUE-1685-2890. Learn more <a href="">here</a></p> <hr> <p>Tags: endpoint</p>