Examples

Scenario inform...

Related scenari...

Resources

>  Get Total Value locked metrics for a given asset including TVL vs MarketCap ratio and TVL vs fully diluted valuation FDV. TVL is often Capital deposited into the platform in the form of loan collateral or liquidity trading pool.

[![button](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/scenarios/try-it-now.png)](https://app.cryptosheets.com/#/browse/CoinGecko/Coins%20Details?scenarioId=522)

**Tags:** `defi,fdv,tvl,locked,diluted,staking,supply,capitilization`

![IMG](https://res.cloudinary.com/cryptosheets/image/upload/l_logos:coingecko-300x300,w_0.2,fl_relative,co_black,e_shadow:90,c_thumb,g_north_east,x_25,y_25,o_90/l_text:twitter.otf_125:Total%20Value%20Locked%20Metrics%20TVL%20vs%20MarketCap%20&%20TVL%20vs%20FDV,co_rgb:006630,e_shadow:40,c_fit,g_west,x_100,h_400,w_1300,g_south_west,x_25,y_250,g_north_west,x_25,y_150/l_text:twitter.otf_60_light:Get%20Total%20Value%20locked%20metrics%20for%20a%20given%20asset%20including%20TVL%20vs%20MarketCap%20ratio%20and%20TVL%20vs%20fully%20diluted%20valuation%20FDV.%20TVL%20is%20often%20Capital%20deposited%20into%20the%20platform%20in%20the%20form%20of%20loan%20collateral%20or%20liquidity%20trading%20pool.,co_black,c_fit,g_west,x_100,h_400,w_1500,g_south_west,x_25,y_50/twitter/twitter-base-scenario4.png)


### Examples

Try the click + copy + paste spreadsheet formulas below: 

**Excel:**

<inline-code functionvalue='=CS.QUERY("CoinGecko","Coins Details",{"_path","{tvl:market_data.total_value_locked,mcapTvlRatio:market_data.mcap_to_tvl_ratio,fdvTvlRatio:market_data.fdv_to_tvl_ratio}";"id","uniswap";"market_data",""})'> =CS.QUERY("CoinGecko","Coins Details",{"_path","{tvl:market_data.total_value_locked,mcapTvlRatio:market_data.mcap_to_tvl_ratio,fdvTvlRatio:market_data.fdv_to_tvl_ratio}";"id","uniswap";"market_data",""})</inline-code>

**Google Sheets:**

<inline-code functionvalue='=CSQUERY("CoinGecko","Coins Details",{"_path","{tvl:market_data.total_value_locked,mcapTvlRatio:market_data.mcap_to_tvl_ratio,fdvTvlRatio:market_data.fdv_to_tvl_ratio}";"id","uniswap";"market_data",""})'> =CSQUERY("CoinGecko","Coins Details",{"_path","{tvl:market_data.total_value_locked,mcapTvlRatio:market_data.mcap_to_tvl_ratio,fdvTvlRatio:market_data.fdv_to_tvl_ratio}";"id","uniswap";"market_data",""})</inline-code>




### Scenario information

**Provider:** [CoinGecko](https://app.cryptosheets.com/#/browse/CoinGecko) **Endpoint:** [Coins Details](https://docs.cryptosheets.com/providers/coingecko) 

**Category:** `current` **Type:** `metrics`

**Last Updated:** 2021-05-06 15:03:35.3930000 | **ScenarioId:** 522 | **Parameters:** 3

### Related scenarios & content

  - Browse all of our scenarios **[WebApp](https://app.cryptosheets.com/#/browse)**  |  **[Docs Portal](https://docs.cryptosheets.com/scenarios/)**
  - Browse other endpoints from [CoinGecko](https://app.cryptosheets.com/#/browse/CoinGecko) **[WebApp](https://app.cryptosheets.com/#/browse/CoinGecko)**  |  **[Docs Portal](https://docs.cryptosheets.com/providers/coingecko)**

### Resources

Cryptosheets scenarios are dynamic combinations of pre-configured queries, transformations and filters easily searchable & accessible with one click. Scenarios are a gamechanger for the way you access and use crypto data inside a spreadsheet. Start saving time today and explore our tutorials, examples  & other resources below.

- [**How to use Cryptosheets Scenarios**](https://medium.com/cryptosheets/introducing-cryptosheets-scenarios-6a69d9e19886)
- [**Help Center**](https://intercom.help/cryptosheets/en/)
- [**Scenario Guides**](https://intercom.help/cryptosheets/en/articles/4571225-how-to-use-cryptosheets-scenarios)
- [**Scenario Tutorial Blog**](https://medium.com/cryptosheets/introducing-cryptosheets-scenarios-6a69d9e19886)
- [**Scenario YouTube Examples**](https://www.youtube.com/channel/UCReKkrBSlgKgNJlWHLASiPQ)

Example tutorials for using the Total Value Locked Metrics TVL vs MarketCap & TVL vs FDV spreadsheet scenario in Excel and Google Sheets