Blocklytics

<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="#excel">Excel</a></li><li class="toc-item toc-item-h2"><a class="toc-link toc-link-h2" href="#google-sheets">Google Sheets</a></li></ol></nav><blockquote> <p>Blocklytics We deliver blockchain data Empower your team with data.</p> </blockquote> <p>Find examples for accessing every <strong>Blocklytics</strong> endpoint using <strong>Cryptosheets</strong> through:</p> <ul> <li><code>side panel console</code></li> <li><code>custom functions</code> (Excel &#x26; Googlesheets)</li> <li><code>templates</code></li> </ul> <h2 id="excel">Excel</h2> <table> <thead> <tr> <th>App Url</th> <th>Docs Url</th> <th>Name</th> <th>Example</th> <th>Parameters</th> <th># of Parameters</th> </tr> </thead> <tbody> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/all-factories">Docs</a></td> <td><strong>All Factories</strong></td> <td>=CS.QUERY("Blocklytics","All Factories")</td> <td>=CS.PARAMETERS("Blocklytics","All Factories")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/all-exchanges---pools">Docs</a></td> <td><strong>All Exchanges - Pools</strong></td> <td>=CS.QUERY("Blocklytics","All Exchanges - Pools")</td> <td>=CS.PARAMETERS("Blocklytics","All Exchanges - Pools")</td> <td>7</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/exchanges-for-address">Docs</a></td> <td><strong>Exchanges for Address</strong></td> <td>=CS.QUERY("Blocklytics","Exchanges for Address")</td> <td>=CS.PARAMETERS("Blocklytics","Exchanges for Address")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/trades-for-address">Docs</a></td> <td><strong>Trades for Address</strong></td> <td>=CS.QUERY("Blocklytics","Trades for Address")</td> <td>=CS.PARAMETERS("Blocklytics","Trades for Address")</td> <td>4</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/liquidity-for-address">Docs</a></td> <td><strong>Liquidity for Address</strong></td> <td>=CS.QUERY("Blocklytics","Liquidity for Address")</td> <td>=CS.PARAMETERS("Blocklytics","Liquidity for Address")</td> <td>4</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/returns-for-address">Docs</a></td> <td><strong>Returns for Address</strong></td> <td>=CS.QUERY("Blocklytics","Returns for Address")</td> <td>=CS.PARAMETERS("Blocklytics","Returns for Address")</td> <td>4</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/single-exchange">Docs</a></td> <td><strong>Single Exchange</strong></td> <td>=CS.QUERY("Blocklytics","Single Exchange")</td> <td>=CS.PARAMETERS("Blocklytics","Single Exchange")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/trades-for-exchange">Docs</a></td> <td><strong>Trades for Exchange</strong></td> <td>=CS.QUERY("Blocklytics","Trades for Exchange")</td> <td>=CS.PARAMETERS("Blocklytics","Trades for Exchange")</td> <td>9</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/pool-owners">Docs</a></td> <td><strong>Pool Owners</strong></td> <td>=CS.QUERY("Blocklytics","Pool Owners")</td> <td>=CS.PARAMETERS("Blocklytics","Pool Owners")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/historical-liquidity">Docs</a></td> <td><strong>Historical Liquidity</strong></td> <td>=CS.QUERY("Blocklytics","Historical Liquidity")</td> <td>=CS.PARAMETERS("Blocklytics","Historical Liquidity")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/ownership-for-account">Docs</a></td> <td><strong>Ownership for Account</strong></td> <td>=CS.QUERY("Blocklytics","Ownership for Account")</td> <td>=CS.PARAMETERS("Blocklytics","Ownership for Account")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/returns-for-exchange">Docs</a></td> <td><strong>Returns for Exchange</strong></td> <td>=CS.QUERY("Blocklytics","Returns for Exchange")</td> <td>=CS.PARAMETERS("Blocklytics","Returns for Exchange")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/supply">Docs</a></td> <td><strong>Supply</strong></td> <td>=CS.QUERY("Blocklytics","Supply")</td> <td>=CS.PARAMETERS("Blocklytics","Supply")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/demand">Docs</a></td> <td><strong>Demand</strong></td> <td>=CS.QUERY("Blocklytics","Demand")</td> <td>=CS.PARAMETERS("Blocklytics","Demand")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/all-points">Docs</a></td> <td><strong>All Points</strong></td> <td>=CS.QUERY("Blocklytics","All Points")</td> <td>=CS.PARAMETERS("Blocklytics","All Points")</td> <td>5</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/history-for-point">Docs</a></td> <td><strong>History for Point</strong></td> <td>=CS.QUERY("Blocklytics","History for Point")</td> <td>=CS.PARAMETERS("Blocklytics","History for Point")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/all-challenges">Docs</a></td> <td><strong>All Challenges</strong></td> <td>=CS.QUERY("Blocklytics","All Challenges")</td> <td>=CS.PARAMETERS("Blocklytics","All Challenges")</td> <td>4</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/history-for-challenge">Docs</a></td> <td><strong>History for Challenge</strong></td> <td>=CS.QUERY("Blocklytics","History for Challenge")</td> <td>=CS.PARAMETERS("Blocklytics","History for Challenge")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/all-cartographers">Docs</a></td> <td><strong>All Cartographers</strong></td> <td>=CS.QUERY("Blocklytics","All Cartographers")</td> <td>=CS.PARAMETERS("Blocklytics","All Cartographers")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/history-for-cartographer">Docs</a></td> <td><strong>History for Cartographer</strong></td> <td>=CS.QUERY("Blocklytics","History for Cartographer")</td> <td>=CS.PARAMETERS("Blocklytics","History for Cartographer")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/rates">Docs</a></td> <td><strong>Rates</strong></td> <td>=CS.QUERY("Blocklytics","Rates")</td> <td>=CS.PARAMETERS("Blocklytics","Rates")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/trades">Docs</a></td> <td><strong>Trades</strong></td> <td>=CS.QUERY("Blocklytics","Trades")</td> <td>=CS.PARAMETERS("Blocklytics","Trades")</td> <td>4</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/all-exchanges---uniswap">Docs</a></td> <td><strong>All Exchanges - Uniswap</strong></td> <td>=CS.QUERY("Blocklytics","All Exchanges - Uniswap")</td> <td>=CS.PARAMETERS("Blocklytics","All Exchanges - Uniswap")</td> <td>1</td> </tr> </tbody> </table> <h2 id="google-sheets">Google Sheets</h2> <table> <thead> <tr> <th>App Url</th> <th>Docs Url</th> <th>Name</th> <th>Example</th> <th>Parameters</th> <th># of Parameters</th> </tr> </thead> <tbody> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/all-factories">Docs</a></td> <td><strong>All Factories</strong></td> <td>=CSQUERY("Blocklytics","All Factories")</td> <td>=CSPARAMETERS("Blocklytics","All Factories")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/all-exchanges---pools">Docs</a></td> <td><strong>All Exchanges - Pools</strong></td> <td>=CSQUERY("Blocklytics","All Exchanges - Pools")</td> <td>=CSPARAMETERS("Blocklytics","All Exchanges - Pools")</td> <td>7</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/exchanges-for-address">Docs</a></td> <td><strong>Exchanges for Address</strong></td> <td>=CSQUERY("Blocklytics","Exchanges for Address")</td> <td>=CSPARAMETERS("Blocklytics","Exchanges for Address")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/trades-for-address">Docs</a></td> <td><strong>Trades for Address</strong></td> <td>=CSQUERY("Blocklytics","Trades for Address")</td> <td>=CSPARAMETERS("Blocklytics","Trades for Address")</td> <td>4</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/liquidity-for-address">Docs</a></td> <td><strong>Liquidity for Address</strong></td> <td>=CSQUERY("Blocklytics","Liquidity for Address")</td> <td>=CSPARAMETERS("Blocklytics","Liquidity for Address")</td> <td>4</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/returns-for-address">Docs</a></td> <td><strong>Returns for Address</strong></td> <td>=CSQUERY("Blocklytics","Returns for Address")</td> <td>=CSPARAMETERS("Blocklytics","Returns for Address")</td> <td>4</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/single-exchange">Docs</a></td> <td><strong>Single Exchange</strong></td> <td>=CSQUERY("Blocklytics","Single Exchange")</td> <td>=CSPARAMETERS("Blocklytics","Single Exchange")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/trades-for-exchange">Docs</a></td> <td><strong>Trades for Exchange</strong></td> <td>=CSQUERY("Blocklytics","Trades for Exchange")</td> <td>=CSPARAMETERS("Blocklytics","Trades for Exchange")</td> <td>9</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/pool-owners">Docs</a></td> <td><strong>Pool Owners</strong></td> <td>=CSQUERY("Blocklytics","Pool Owners")</td> <td>=CSPARAMETERS("Blocklytics","Pool Owners")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/historical-liquidity">Docs</a></td> <td><strong>Historical Liquidity</strong></td> <td>=CSQUERY("Blocklytics","Historical Liquidity")</td> <td>=CSPARAMETERS("Blocklytics","Historical Liquidity")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/ownership-for-account">Docs</a></td> <td><strong>Ownership for Account</strong></td> <td>=CSQUERY("Blocklytics","Ownership for Account")</td> <td>=CSPARAMETERS("Blocklytics","Ownership for Account")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/returns-for-exchange">Docs</a></td> <td><strong>Returns for Exchange</strong></td> <td>=CSQUERY("Blocklytics","Returns for Exchange")</td> <td>=CSPARAMETERS("Blocklytics","Returns for Exchange")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/supply">Docs</a></td> <td><strong>Supply</strong></td> <td>=CSQUERY("Blocklytics","Supply")</td> <td>=CSPARAMETERS("Blocklytics","Supply")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/demand">Docs</a></td> <td><strong>Demand</strong></td> <td>=CSQUERY("Blocklytics","Demand")</td> <td>=CSPARAMETERS("Blocklytics","Demand")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/all-points">Docs</a></td> <td><strong>All Points</strong></td> <td>=CSQUERY("Blocklytics","All Points")</td> <td>=CSPARAMETERS("Blocklytics","All Points")</td> <td>5</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/history-for-point">Docs</a></td> <td><strong>History for Point</strong></td> <td>=CSQUERY("Blocklytics","History for Point")</td> <td>=CSPARAMETERS("Blocklytics","History for Point")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/all-challenges">Docs</a></td> <td><strong>All Challenges</strong></td> <td>=CSQUERY("Blocklytics","All Challenges")</td> <td>=CSPARAMETERS("Blocklytics","All Challenges")</td> <td>4</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/history-for-challenge">Docs</a></td> <td><strong>History for Challenge</strong></td> <td>=CSQUERY("Blocklytics","History for Challenge")</td> <td>=CSPARAMETERS("Blocklytics","History for Challenge")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/all-cartographers">Docs</a></td> <td><strong>All Cartographers</strong></td> <td>=CSQUERY("Blocklytics","All Cartographers")</td> <td>=CSPARAMETERS("Blocklytics","All Cartographers")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/history-for-cartographer">Docs</a></td> <td><strong>History for Cartographer</strong></td> <td>=CSQUERY("Blocklytics","History for Cartographer")</td> <td>=CSPARAMETERS("Blocklytics","History for Cartographer")</td> <td>2</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/rates">Docs</a></td> <td><strong>Rates</strong></td> <td>=CSQUERY("Blocklytics","Rates")</td> <td>=CSPARAMETERS("Blocklytics","Rates")</td> <td>1</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/trades">Docs</a></td> <td><strong>Trades</strong></td> <td>=CSQUERY("Blocklytics","Trades")</td> <td>=CSPARAMETERS("Blocklytics","Trades")</td> <td>4</td> </tr> <tr> <td>Try It</td> <td><a href="/providers/blocklytics/all-exchanges---uniswap">Docs</a></td> <td><strong>All Exchanges - Uniswap</strong></td> <td>=CSQUERY("Blocklytics","All Exchanges - Uniswap")</td> <td>=CSPARAMETERS("Blocklytics","All Exchanges - Uniswap")</td> <td>1</td> </tr> </tbody> </table> <p><a href="https://app.cryptosheets.com/#/register">Signing up for Cryptosheets is free</a> get crypto data in 30 seconds or less</p> <p><strong>Get Cryptosheets for Microsoft Excel</strong></p> <p><strong>Get Cryptosheets for Googlesheets</strong></p> <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</p> <p><strong>Click here</strong> for additional documentation from Blocklytics</p> <p>Learn more <a href="https://intercom.help/cryptosheets/en/">here</a></p> <hr> <p>Tags: Blocklytics</p>