> Financial information and analytics for debt issued on the Ethereum blockchain Find examples for accessing every **LoanScan** endpoint using **Cryptosheets** through: - `side panel console` - `custom functions` (Excel & Googlesheets) - `templates` ## Excel

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | -------- | ----------- | | Try It | [Docs](/providers/loanscan/agreements) | **Agreements** | =CS.QUERY("LoanScan","Agreements") | =CS.PARAMETERS("LoanScan","Agreements") | 2 | | Try It | [Docs](/providers/loanscan/agreements-by-protocol-or-agreementid) | **Agreements by Protocol or Agreementid** | =CS.QUERY("LoanScan","Agreements by Protocol or Agreementid") | =CS.PARAMETERS("LoanScan","Agreements by Protocol or Agreementid") | 3 | | Try It | [Docs](/providers/loanscan/interest-rates) | **Interest Rates** | =CS.QUERY("LoanScan","Interest Rates") | =CS.PARAMETERS("LoanScan","Interest Rates") | 1 | | Try It | [Docs](/providers/loanscan/interest-rates-historical) | **Interest Rates Historical** | =CS.QUERY("LoanScan","Interest Rates Historical") | =CS.PARAMETERS("LoanScan","Interest Rates Historical") | 5 | | Try It | [Docs](/providers/loanscan/issuances) | **Issuances** | =CS.QUERY("LoanScan","Issuances") | =CS.PARAMETERS("LoanScan","Issuances") | 1 | | Try It | [Docs](/providers/loanscan/issuances-by-protocol-agreementid-issuanceid) | **Issuances by Protocol Agreementid Issuanceid** | =CS.QUERY("LoanScan","Issuances by Protocol Agreementid Issuanceid") | =CS.PARAMETERS("LoanScan","Issuances by Protocol Agreementid Issuanceid") | 4 | | Try It | [Docs](/providers/loanscan/reference-rates-historical) | **Reference Rates Historical** | =CS.QUERY("LoanScan","Reference Rates Historical") | =CS.PARAMETERS("LoanScan","Reference Rates Historical") | 4 | | Try It | [Docs](/providers/loanscan/reference-rates-current) | **Reference Rates Current** | =CS.QUERY("LoanScan","Reference Rates Current") | =CS.PARAMETERS("LoanScan","Reference Rates Current") | 3 | | Try It | [Docs](/providers/loanscan/stats-supply-volume) | **Stats Supply Volume** | =CS.QUERY("LoanScan","Stats Supply Volume") | =CS.PARAMETERS("LoanScan","Stats Supply Volume") | 4 | | Try It | [Docs](/providers/loanscan/stats-borrow-volume) | **Stats Borrow Volume** | =CS.QUERY("LoanScan","Stats Borrow Volume") | =CS.PARAMETERS("LoanScan","Stats Borrow Volume") | 4 | | Try It | [Docs](/providers/loanscan/stats-repayment-volume) | **Stats Repayment Volume** | =CS.QUERY("LoanScan","Stats Repayment Volume") | =CS.PARAMETERS("LoanScan","Stats Repayment Volume") | 4 | | Try It | [Docs](/providers/loanscan/stats-liquidation-volume) | **Stats Liquidation Volume** | =CS.QUERY("LoanScan","Stats Liquidation Volume") | =CS.PARAMETERS("LoanScan","Stats Liquidation Volume") | 3 | | Try It | [Docs](/providers/loanscan/stats-outstanding-debt) | **Stats Outstanding Debt** | =CS.QUERY("LoanScan","Stats Outstanding Debt") | =CS.PARAMETERS("LoanScan","Stats Outstanding Debt") | 4 | | Try It | [Docs](/providers/loanscan/stats-collateral-ratio) | **Stats Collateral Ratio** | =CS.QUERY("LoanScan","Stats Collateral Ratio") | =CS.PARAMETERS("LoanScan","Stats Collateral Ratio") | 3 | | Try It | [Docs](/providers/loanscan/stats-most-borrowed-asset) | **Stats Most Borrowed Asset** | =CS.QUERY("LoanScan","Stats Most Borrowed Asset") | =CS.PARAMETERS("LoanScan","Stats Most Borrowed Asset") | 1 | | Try It | [Docs](/providers/loanscan/stats-top-borrowed-assets) | **Stats Top Borrowed Assets** | =CS.QUERY("LoanScan","Stats Top Borrowed Assets") | =CS.PARAMETERS("LoanScan","Stats Top Borrowed Assets") | 1 | | Try It | [Docs](/providers/loanscan/stats-top-supplied-assets) | **Stats Top Supplied Assets** | =CS.QUERY("LoanScan","Stats Top Supplied Assets") | =CS.PARAMETERS("LoanScan","Stats Top Supplied Assets") | 1 | | Try It | [Docs](/providers/loanscan/stats-top-liquidated-assets) | **Stats Top Liquidated Assets** | =CS.QUERY("LoanScan","Stats Top Liquidated Assets") | =CS.PARAMETERS("LoanScan","Stats Top Liquidated Assets") | 1 | | Try It | [Docs](/providers/loanscan/stats-top-outstanding-debt-assets) | **Stats Top Outstanding Debt Assets** | =CS.QUERY("LoanScan","Stats Top Outstanding Debt Assets") | =CS.PARAMETERS("LoanScan","Stats Top Outstanding Debt Assets") | 1 | | Try It | [Docs](/providers/loanscan/stats-top-repaid-assets) | **Stats Top Repaid Assets** | =CS.QUERY("LoanScan","Stats Top Repaid Assets") | =CS.PARAMETERS("LoanScan","Stats Top Repaid Assets") | 2 | | Try It | [Docs](/providers/loanscan/stats-top-borrowed-protocols) | **Stats Top Borrowed Protocols** | =CS.QUERY("LoanScan","Stats Top Borrowed Protocols") | =CS.PARAMETERS("LoanScan","Stats Top Borrowed Protocols") | 2 | | Try It | [Docs](/providers/loanscan/stats-top-liquidated-protocols) | **Stats Top Liquidated Protocols** | =CS.QUERY("LoanScan","Stats Top Liquidated Protocols") | =CS.PARAMETERS("LoanScan","Stats Top Liquidated Protocols") | 1 | | Try It | [Docs](/providers/loanscan/stats-top-supplied-protocols) | **Stats Top Supplied Protocols** | =CS.QUERY("LoanScan","Stats Top Supplied Protocols") | =CS.PARAMETERS("LoanScan","Stats Top Supplied Protocols") | 2 | | Try It | [Docs](/providers/loanscan/stats-top-repaid-protocols) | **Stats Top Repaid Protocols** | =CS.QUERY("LoanScan","Stats Top Repaid Protocols") | =CS.PARAMETERS("LoanScan","Stats Top Repaid Protocols") | 1 | | Try It | [Docs](/providers/loanscan/stats-metadata) | **Stats Metadata** | =CS.QUERY("LoanScan","Stats Metadata") | =CS.PARAMETERS("LoanScan","Stats Metadata") | 1 | | Try It | [Docs](/providers/loanscan/stats-dipor) | **Stats Dipor** | =CS.QUERY("LoanScan","Stats Dipor") | =CS.PARAMETERS("LoanScan","Stats Dipor") | 1 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/loanscan/agreements) | **Agreements** | =CSQUERY("LoanScan","Agreements") | =CSPARAMETERS("LoanScan","Agreements") | 2 | | Try It | [Docs](/providers/loanscan/agreements-by-protocol-or-agreementid) | **Agreements by Protocol or Agreementid** | =CSQUERY("LoanScan","Agreements by Protocol or Agreementid") | =CSPARAMETERS("LoanScan","Agreements by Protocol or Agreementid") | 3 | | Try It | [Docs](/providers/loanscan/interest-rates) | **Interest Rates** | =CSQUERY("LoanScan","Interest Rates") | =CSPARAMETERS("LoanScan","Interest Rates") | 1 | | Try It | [Docs](/providers/loanscan/interest-rates-historical) | **Interest Rates Historical** | =CSQUERY("LoanScan","Interest Rates Historical") | =CSPARAMETERS("LoanScan","Interest Rates Historical") | 5 | | Try It | [Docs](/providers/loanscan/issuances) | **Issuances** | =CSQUERY("LoanScan","Issuances") | =CSPARAMETERS("LoanScan","Issuances") | 1 | | Try It | [Docs](/providers/loanscan/issuances-by-protocol-agreementid-issuanceid) | **Issuances by Protocol Agreementid Issuanceid** | =CSQUERY("LoanScan","Issuances by Protocol Agreementid Issuanceid") | =CSPARAMETERS("LoanScan","Issuances by Protocol Agreementid Issuanceid") | 4 | | Try It | [Docs](/providers/loanscan/reference-rates-historical) | **Reference Rates Historical** | =CSQUERY("LoanScan","Reference Rates Historical") | =CSPARAMETERS("LoanScan","Reference Rates Historical") | 4 | | Try It | [Docs](/providers/loanscan/reference-rates-current) | **Reference Rates Current** | =CSQUERY("LoanScan","Reference Rates Current") | =CSPARAMETERS("LoanScan","Reference Rates Current") | 3 | | Try It | [Docs](/providers/loanscan/stats-supply-volume) | **Stats Supply Volume** | =CSQUERY("LoanScan","Stats Supply Volume") | =CSPARAMETERS("LoanScan","Stats Supply Volume") | 4 | | Try It | [Docs](/providers/loanscan/stats-borrow-volume) | **Stats Borrow Volume** | =CSQUERY("LoanScan","Stats Borrow Volume") | =CSPARAMETERS("LoanScan","Stats Borrow Volume") | 4 | | Try It | [Docs](/providers/loanscan/stats-repayment-volume) | **Stats Repayment Volume** | =CSQUERY("LoanScan","Stats Repayment Volume") | =CSPARAMETERS("LoanScan","Stats Repayment Volume") | 4 | | Try It | [Docs](/providers/loanscan/stats-liquidation-volume) | **Stats Liquidation Volume** | =CSQUERY("LoanScan","Stats Liquidation Volume") | =CSPARAMETERS("LoanScan","Stats Liquidation Volume") | 3 | | Try It | [Docs](/providers/loanscan/stats-outstanding-debt) | **Stats Outstanding Debt** | =CSQUERY("LoanScan","Stats Outstanding Debt") | =CSPARAMETERS("LoanScan","Stats Outstanding Debt") | 4 | | Try It | [Docs](/providers/loanscan/stats-collateral-ratio) | **Stats Collateral Ratio** | =CSQUERY("LoanScan","Stats Collateral Ratio") | =CSPARAMETERS("LoanScan","Stats Collateral Ratio") | 3 | | Try It | [Docs](/providers/loanscan/stats-most-borrowed-asset) | **Stats Most Borrowed Asset** | =CSQUERY("LoanScan","Stats Most Borrowed Asset") | =CSPARAMETERS("LoanScan","Stats Most Borrowed Asset") | 1 | | Try It | [Docs](/providers/loanscan/stats-top-borrowed-assets) | **Stats Top Borrowed Assets** | =CSQUERY("LoanScan","Stats Top Borrowed Assets") | =CSPARAMETERS("LoanScan","Stats Top Borrowed Assets") | 1 | | Try It | [Docs](/providers/loanscan/stats-top-supplied-assets) | **Stats Top Supplied Assets** | =CSQUERY("LoanScan","Stats Top Supplied Assets") | =CSPARAMETERS("LoanScan","Stats Top Supplied Assets") | 1 | | Try It | [Docs](/providers/loanscan/stats-top-liquidated-assets) | **Stats Top Liquidated Assets** | =CSQUERY("LoanScan","Stats Top Liquidated Assets") | =CSPARAMETERS("LoanScan","Stats Top Liquidated Assets") | 1 | | Try It | [Docs](/providers/loanscan/stats-top-outstanding-debt-assets) | **Stats Top Outstanding Debt Assets** | =CSQUERY("LoanScan","Stats Top Outstanding Debt Assets") | =CSPARAMETERS("LoanScan","Stats Top Outstanding Debt Assets") | 1 | | Try It | [Docs](/providers/loanscan/stats-top-repaid-assets) | **Stats Top Repaid Assets** | =CSQUERY("LoanScan","Stats Top Repaid Assets") | =CSPARAMETERS("LoanScan","Stats Top Repaid Assets") | 2 | | Try It | [Docs](/providers/loanscan/stats-top-borrowed-protocols) | **Stats Top Borrowed Protocols** | =CSQUERY("LoanScan","Stats Top Borrowed Protocols") | =CSPARAMETERS("LoanScan","Stats Top Borrowed Protocols") | 2 | | Try It | [Docs](/providers/loanscan/stats-top-liquidated-protocols) | **Stats Top Liquidated Protocols** | =CSQUERY("LoanScan","Stats Top Liquidated Protocols") | =CSPARAMETERS("LoanScan","Stats Top Liquidated Protocols") | 1 | | Try It | [Docs](/providers/loanscan/stats-top-supplied-protocols) | **Stats Top Supplied Protocols** | =CSQUERY("LoanScan","Stats Top Supplied Protocols") | =CSPARAMETERS("LoanScan","Stats Top Supplied Protocols") | 2 | | Try It | [Docs](/providers/loanscan/stats-top-repaid-protocols) | **Stats Top Repaid Protocols** | =CSQUERY("LoanScan","Stats Top Repaid Protocols") | =CSPARAMETERS("LoanScan","Stats Top Repaid Protocols") | 1 | | Try It | [Docs](/providers/loanscan/stats-metadata) | **Stats Metadata** | =CSQUERY("LoanScan","Stats Metadata") | =CSPARAMETERS("LoanScan","Stats Metadata") | 1 | | Try It | [Docs](/providers/loanscan/stats-dipor) | **Stats Dipor** | =CSQUERY("LoanScan","Stats Dipor") | =CSPARAMETERS("LoanScan","Stats Dipor") | 1 |

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less **Get Cryptosheets for Microsoft Excel** **Get Cryptosheets for Googlesheets** \*Note: you must have one of the [supported versions](https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture) of Microsoft Office or Excel for custom functions to work **Click here** for additional documentation from LoanScan Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `LoanScan` `provider`