Single Exchange

<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-blocklytics-data-in-excel--googlesheets-with-cryptosheets">How to use Blocklytics 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>Returns a single exchange with the current price and liquidity details.</p> </blockquote> <h2 id="how-to-use-blocklytics-data-in-excel--googlesheets-with-cryptosheets">How to use Blocklytics data in Excel &#x26; Googlesheets with Cryptosheets</h2> <p>This article demonstrates three examples of how to pull Blocklytics data into your spreadsheet using the <code>side panel console</code>, <code>custom functions</code> and <code>templates</code>.</p> <p>Explore more Blocklytics endpoints <a href="https://app.cryptosheets.com/#/browse/Blocklytics">here</a></p> <h2 id="example-parameters">Example Parameters:</h2> <ul> <li>key: <code>Your_key</code></li> <li>address: <code>0x3958b4ec427f8fa24eb60f42821760e88d485f7f</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="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=intercom-Blocklytics">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 "Blocklytics..." then click on <code>Single Exchange</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("Blocklytics","Single Exchange",{"key","Your_key";"address","0x3958b4ec427f8fa24eb60f42821760e88d485f7f"})</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("Blocklytics","Single Exchange")</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 Blocklytics and Single Exchange</li> <li>You can also try searching "Blocklytics..." 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 Blocklytics <a href="https://docs.blocklytics.org/">here</a></p> <p>Troubleshooting: please reference the following troubleshooting code: QUE-1755-2871. Learn more <a href="https://intercom.help/cryptosheets/en/">here</a></p> <hr> <p>Tags: endpoint</p>