Derivatives Exchanges List

<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-coingecko-data-in-excel--googlesheets-with-cryptosheets">How to use CoinGecko 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>List all derivative exchanges name and identifier</p> </blockquote> <h2 id="how-to-use-coingecko-data-in-excel--googlesheets-with-cryptosheets">How to use CoinGecko data in Excel &#x26; Googlesheets with Cryptosheets</h2> <p>This article demonstrates three examples of how to pull CoinGecko data into your spreadsheet using the <code>side panel console</code>, <code>custom functions</code> and <code>templates</code>.</p> <p>Explore more CoinGecko endpoints <a href="https://app.cryptosheets.com/#/browse/CoinGecko">here</a></p> <h2 id="example-parameters">Example Parameters:</h2> <blockquote> <p>This endpoint has no parameters.</p> </blockquote> <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="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=intercom-CoinGecko">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 "CoinGecko..." then click on <code>Derivatives Exchanges List</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="https://res.cloudinary.com/cryptosheets/image/upload/v1570538223/cryptosheets-docs/excel/ribbon/data-browse-providers.png"><img src="https://res.cloudinary.com/cryptosheets/image/upload/v1570538223/cryptosheets-docs/excel/ribbon/data-browse-providers.png" alt="img"></a></p> <h3 id="using-custom-functions">Using custom functions</h3> <ol> <li>In any cell type the following: <code>=CS.QUERY("CoinGecko","Derivatives Exchanges List",{})</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="https://intercom.help/cryptosheets/en/articles/3472916-using-the-cryptosheets-api-console-query-and-function-formula-builder-for-excel-googlesheets">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("CoinGecko","Derivatives Exchanges List")</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 CoinGecko and Derivatives Exchanges List</li> <li>You can also try searching "CoinGecko..." for other templates specific or related to <code>Get Gains</code> </li> </ol> <p><a href="https://app.cryptosheets.com/#/register">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="https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture">supported versions</a> of Microsoft Office or Excel for custom functions to work. Learn more <a href="https://intercom.help/cryptosheets/en/">here</a></p> </blockquote> <h2 id="helpful-resources">Helpful Resources:</h2> <p>Visit the API documentation for CoinGecko <a href="http://www.coingecko.com/api">here</a></p> <p>Troubleshooting: please reference the following troubleshooting code: QUE-843-3030. Learn more <a href="https://intercom.help/cryptosheets/en/">here</a></p> <hr> <p>Tags: endpoint</p>