Scenario Timeline Benchmarks His

<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-paradigm-data-in-excel--googlesheets-with-cryptosheets">How to use Paradigm 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>A method to query data from our crypto benchmark stress test scenario model timelines. Data returned includes event details, description, comprehensive price, volume, percentage change and volatility leading up to and for a trailing period after each event. Events are grouped by category (ie regulatory, corporate integration), type (regulatory investigation, sovereign policy, hack) and are assinged a primary factor attribution (liquidity, momentum). This endpoint is an input for the aggregated stress test scenario models (Scenario Benchmarks).</p> </blockquote> <h2 id="how-to-use-paradigm-data-in-excel--googlesheets-with-cryptosheets">How to use Paradigm data in Excel &#x26; Googlesheets with Cryptosheets</h2> <p>This article demonstrates three examples of how to pull Paradigm data into your spreadsheet using the <code>side panel console</code>, <code>custom functions</code> and <code>templates</code>.</p> <p>Explore more Paradigm endpoints <a href="https://app.cryptosheets.com/#/browse/Paradigm">here</a></p> <h2 id="example-parameters">Example Parameters:</h2> <ul> <li>page: <code>1</code></li> <li>limit: <code>100</code></li> <li>sort: ``</li> <li>dateBegin: <code>43262</code></li> <li>order: <code>asc</code></li> <li>excl_cols: ``</li> <li>factor: <code>liquidity</code></li> <li>name: <code>CoinMarketCap drops South Korean Exchange prices</code></li> <li>firstStacked: ``</li> <li>description: <code>CoinMarketCap drops South Korea prices from cryptocurrency rates and regulator inspects cryptocurrency bank accounts.</code></li> <li>pctChangePost2d: <code>0.1:</code></li> <li>pctChangePost1d: <code>0.1:</code></li> <li>pctChangePost3d: <code>0.1:</code></li> <li>pctChangePre1d: <code>0.1:</code></li> <li>pctChangePost4d: <code>0.1:</code></li> <li>pctChangePost5d: <code>0.1:</code></li> <li>pctChangePre2d: <code>0.1:</code></li> <li>pctChangePre5d: <code>0.1:</code></li> <li>pctChangePre4d: <code>0.1:</code></li> <li>pctChangePre3d: <code>0.1:</code></li> <li>price: ``</li> <li>pricePre1d: <code>:[price]</code></li> <li>pricePost1d: <code>:[price]</code></li> <li>vol5: <code>0.5:</code></li> <li>secondStacked: <code>ETHUSD</code></li> <li>type: <code>government ban</code></li> <li>vol5Post1D: <code>0.5:</code></li> <li>thirdStacked: ``</li> <li>vol5Post2D: <code>0.5:</code></li> <li>vol5Post3D: <code>0.5:</code></li> <li>vol5Post5D: <code>0.5:</code></li> <li>vol5Post4D: <code>0.5:</code></li> <li>vol5Pre2D: <code>0.5:</code></li> <li>vol5Pre1D: <code>0.5:</code></li> <li>vol5Pre3D: <code>0.5:</code></li> <li>vol5Pre4D: <code>0.5:</code></li> <li>vol5Pre5D: <code>0.5:</code></li> <li>category: <code>corporate positive</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-Paradigm">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 "Paradigm..." then click on <code>Scenario Timeline Benchmarks His</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("Paradigm","Scenario Timeline Benchmarks His",{"page","1";"limit","100";"sort","";"dateBegin","43262";"order","asc";"excl_cols","";"factor","liquidity";"name","CoinMarketCap drops South Korean Exchange prices";"firstStacked","";"description","CoinMarketCap drops South Korea prices from cryptocurrency rates and regulator inspects cryptocurrency bank accounts.";"pctChangePost2d","0.1:";"pctChangePost1d","0.1:";"pctChangePost3d","0.1:";"pctChangePre1d","0.1:";"pctChangePost4d","0.1:";"pctChangePost5d","0.1:";"pctChangePre2d","0.1:";"pctChangePre5d","0.1:";"pctChangePre4d","0.1:";"pctChangePre3d","0.1:";"price","";"pricePre1d",":[price]";"pricePost1d",":[price]";"vol5","0.5:";"secondStacked","ETHUSD";"type","government ban";"vol5Post1D","0.5:";"thirdStacked","";"vol5Post2D","0.5:";"vol5Post3D","0.5:";"vol5Post5D","0.5:";"vol5Post4D","0.5:";"vol5Pre2D","0.5:";"vol5Pre1D","0.5:";"vol5Pre3D","0.5:";"vol5Pre4D","0.5:";"vol5Pre5D","0.5:";"category","corporate positive"})</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("Paradigm","Scenario Timeline Benchmarks His")</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 Paradigm and Scenario Timeline Benchmarks His</li> <li>You can also try searching "Paradigm..." 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 Paradigm <a href="https://docs.paradigmapi.com/home">here</a></p> <p>Troubleshooting: please reference the following troubleshooting code: QUE-1211-353. Learn more <a href="https://intercom.help/cryptosheets/en/">here</a></p> <hr> <p>Tags: api provider</p>