Quotes

<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-0xapi-data-in-excel--googlesheets-with-cryptosheets">How to use 0xAPI 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 an easy-to-consume quote for buying or selling any token. The return format is a valid unsigned Ethereum transaction and can be submitted directly to an Ethereum node to complete the swap. For transactions where the sellToken is not ETH, you will have to set your allowances.</p> </blockquote> <h2 id="how-to-use-0xapi-data-in-excel--googlesheets-with-cryptosheets">How to use 0xAPI data in Excel &#x26; Googlesheets with Cryptosheets</h2> <p>This article demonstrates three examples of how to pull 0xAPI data into your spreadsheet using the <code>side panel console</code>, <code>custom functions</code> and <code>templates</code>.</p> <p>Explore more 0xAPI endpoints <a href="https://app.cryptosheets.com/#/browse/0xAPI">here</a></p> <h2 id="example-parameters">Example Parameters:</h2> <ul> <li>sellToken: <code>DAI</code></li> <li>buyToken: <code>COMP</code></li> <li>sellAmount: <code>100000000</code></li> <li>buyAmount: ``</li> <li>slippagePercentage: ``</li> <li>gasPrice: ``</li> <li>takerAddress: ``</li> <li>excludedSources: ``</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-0xAPI">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 "0xAPI..." then click on <code>Quotes</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("0xAPI","Quotes",{"sellToken","DAI";"buyToken","COMP";"sellAmount","100000000";"buyAmount","";"slippagePercentage","";"gasPrice","";"takerAddress","";"excludedSources",""})</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("0xAPI","Quotes")</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 0xAPI and Quotes</li> <li>You can also try searching "0xAPI..." 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 0xAPI <a href="https://0x.org/docs/api#introduction">here</a></p> <p>Troubleshooting: please reference the following troubleshooting code: QUE-1753-2852. Learn more <a href="https://intercom.help/cryptosheets/en/">here</a></p> <hr> <p>Tags: endpoint</p>