Excel

Google Sheets

> access Serum DEX data and other crypto market analytics.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Bonfida">Bonfida</a>** endpoint using **Cryptosheets** through:

- `side panel console`
- `custom functions` (Excel & Googlesheets)
- `templates`

## Excel

<div class="markdown">

| App Url                                                                                 | Docs Url                                                                                 | Name                        | Example                                             | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | --------   | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20All%20Pairs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-all-pairs) | **Get All Pairs** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get All Pairs")'>=CS.QUERY("Bonfida","Get All Pairs")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get All Pairs")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Recent%20Trades%20by%20Market%20Name" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-recent-trades-by-market-name) | **Get Recent Trades by Market Name** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get Recent Trades by Market Name",{"marketName","ETHUSDT"})'>=CS.QUERY("Bonfida","Get Recent Trades by Market Name")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get Recent Trades by Market Name")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Recent%20Trades%20by%20Market%20Address" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-recent-trades-by-market-address) | **Get Recent Trades by Market Address** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get Recent Trades by Market Address",{"marketAddress","5abZGhrELnUnfM9ZUnvK6XJPoBU5eShZwfFPkdhAC7o"})'>=CS.QUERY("Bonfida","Get Recent Trades by Market Address")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get Recent Trades by Market Address")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20All%20Recent%20Trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-all-recent-trades) | **Get All Recent Trades** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get All Recent Trades")'>=CS.QUERY("Bonfida","Get All Recent Trades")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get All Recent Trades")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Volume" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-volume) | **Get Volume** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get Volume",{"marketName","ETHUSDT"})'>=CS.QUERY("Bonfida","Get Volume")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get Volume")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Orderbook" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-orderbook) | **Get Orderbook** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get Orderbook",{"marketName","ETHUSDT"})'>=CS.QUERY("Bonfida","Get Orderbook")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get Orderbook")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Historical%20Prices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-historical-prices) | **Get Historical Prices** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get Historical Prices",{"marketName","ETHUSDT";"resolution","3600"})'>=CS.QUERY("Bonfida","Get Historical Prices")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get Historical Prices")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20All%20Pools" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-all-pools) | **Get All Pools** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get All Pools")'>=CS.QUERY("Bonfida","Get All Pools")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get All Pools")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20All%20Pools%20Recent" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-all-pools-recent) | **Get All Pools Recent** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get All Pools Recent")'>=CS.QUERY("Bonfida","Get All Pools Recent")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get All Pools Recent")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Pool" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-pool) | **Get Pool** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get Pool",{"mintA","BQcdHdAQW1hczDbBi9hiegXAR7A98Q9jx3X3iBBBDiq4";"mintB","SRMuApVNdxXokk5GT7XD5cUUgXMBCoAz2LHeuAoKWRt"})'>=CS.QUERY("Bonfida","Get Pool")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get Pool")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Pool%20Trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-pool-trades) | **Get Pool Trades** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get Pool Trades")'>=CS.QUERY("Bonfida","Get Pool Trades")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get Pool Trades")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Pools%20Last%2024h%20Volume" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-pools-last-24h-volume) | **Get Pools Last 24h Volume** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get Pools Last 24h Volume")'>=CS.QUERY("Bonfida","Get Pools Last 24h Volume")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get Pools Last 24h Volume")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Pools%20Historical%20Volume" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-pools-historical-volume) | **Get Pools Historical Volume** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get Pools Historical Volume",{"mintA","BQcdHdAQW1hczDbBi9hiegXAR7A98Q9jx3X3iBBBDiq4";"mintB","SRMuApVNdxXokk5GT7XD5cUUgXMBCoAz2LHeuAoKWRt"})'>=CS.QUERY("Bonfida","Get Pools Historical Volume")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get Pools Historical Volume")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Pools%20HIstorical%20Liquidity" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-pools-historical-liquidity) | **Get Pools HIstorical Liquidity** | <inline-code functionvalue='=CS.QUERY("Bonfida","Get Pools HIstorical Liquidity",{"mintA","BQcdHdAQW1hczDbBi9hiegXAR7A98Q9jx3X3iBBBDiq4";"mintB","SRMuApVNdxXokk5GT7XD5cUUgXMBCoAz2LHeuAoKWRt"})'>=CS.QUERY("Bonfida","Get Pools HIstorical Liquidity")</inline-code> | <inline-code>=CS.PARAMETERS("Bonfida","Get Pools HIstorical Liquidity")</inline-code> | 5 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20All%20Pairs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-all-pairs) | **Get All Pairs** | <inline-code functionvalue='=CSQUERY("Bonfida","Get All Pairs")'>=CSQUERY("Bonfida","Get All Pairs")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get All Pairs")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Recent%20Trades%20by%20Market%20Name" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-recent-trades-by-market-name) | **Get Recent Trades by Market Name** | <inline-code functionvalue='=CSQUERY("Bonfida","Get Recent Trades by Market Name",{"marketName","ETHUSDT"})'>=CSQUERY("Bonfida","Get Recent Trades by Market Name")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get Recent Trades by Market Name")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Recent%20Trades%20by%20Market%20Address" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-recent-trades-by-market-address) | **Get Recent Trades by Market Address** | <inline-code functionvalue='=CSQUERY("Bonfida","Get Recent Trades by Market Address",{"marketAddress","5abZGhrELnUnfM9ZUnvK6XJPoBU5eShZwfFPkdhAC7o"})'>=CSQUERY("Bonfida","Get Recent Trades by Market Address")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get Recent Trades by Market Address")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20All%20Recent%20Trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-all-recent-trades) | **Get All Recent Trades** | <inline-code functionvalue='=CSQUERY("Bonfida","Get All Recent Trades")'>=CSQUERY("Bonfida","Get All Recent Trades")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get All Recent Trades")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Volume" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-volume) | **Get Volume** | <inline-code functionvalue='=CSQUERY("Bonfida","Get Volume",{"marketName","ETHUSDT"})'>=CSQUERY("Bonfida","Get Volume")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get Volume")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Orderbook" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-orderbook) | **Get Orderbook** | <inline-code functionvalue='=CSQUERY("Bonfida","Get Orderbook",{"marketName","ETHUSDT"})'>=CSQUERY("Bonfida","Get Orderbook")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get Orderbook")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Historical%20Prices" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-historical-prices) | **Get Historical Prices** | <inline-code functionvalue='=CSQUERY("Bonfida","Get Historical Prices",{"marketName","ETHUSDT";"resolution","3600"})'>=CSQUERY("Bonfida","Get Historical Prices")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get Historical Prices")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20All%20Pools" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-all-pools) | **Get All Pools** | <inline-code functionvalue='=CSQUERY("Bonfida","Get All Pools")'>=CSQUERY("Bonfida","Get All Pools")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get All Pools")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20All%20Pools%20Recent" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-all-pools-recent) | **Get All Pools Recent** | <inline-code functionvalue='=CSQUERY("Bonfida","Get All Pools Recent")'>=CSQUERY("Bonfida","Get All Pools Recent")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get All Pools Recent")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Pool" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-pool) | **Get Pool** | <inline-code functionvalue='=CSQUERY("Bonfida","Get Pool",{"mintA","BQcdHdAQW1hczDbBi9hiegXAR7A98Q9jx3X3iBBBDiq4";"mintB","SRMuApVNdxXokk5GT7XD5cUUgXMBCoAz2LHeuAoKWRt"})'>=CSQUERY("Bonfida","Get Pool")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get Pool")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Pool%20Trades" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-pool-trades) | **Get Pool Trades** | <inline-code functionvalue='=CSQUERY("Bonfida","Get Pool Trades")'>=CSQUERY("Bonfida","Get Pool Trades")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get Pool Trades")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Pools%20Last%2024h%20Volume" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-pools-last-24h-volume) | **Get Pools Last 24h Volume** | <inline-code functionvalue='=CSQUERY("Bonfida","Get Pools Last 24h Volume")'>=CSQUERY("Bonfida","Get Pools Last 24h Volume")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get Pools Last 24h Volume")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Pools%20Historical%20Volume" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-pools-historical-volume) | **Get Pools Historical Volume** | <inline-code functionvalue='=CSQUERY("Bonfida","Get Pools Historical Volume",{"mintA","BQcdHdAQW1hczDbBi9hiegXAR7A98Q9jx3X3iBBBDiq4";"mintB","SRMuApVNdxXokk5GT7XD5cUUgXMBCoAz2LHeuAoKWRt"})'>=CSQUERY("Bonfida","Get Pools Historical Volume")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get Pools Historical Volume")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Bonfida/Get%20Pools%20HIstorical%20Liquidity" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bonfida/get-pools-historical-liquidity) | **Get Pools HIstorical Liquidity** | <inline-code functionvalue='=CSQUERY("Bonfida","Get Pools HIstorical Liquidity",{"mintA","BQcdHdAQW1hczDbBi9hiegXAR7A98Q9jx3X3iBBBDiq4";"mintB","SRMuApVNdxXokk5GT7XD5cUUgXMBCoAz2LHeuAoKWRt"})'>=CSQUERY("Bonfida","Get Pools HIstorical Liquidity")</inline-code> | <inline-code>=CSPARAMETERS("Bonfida","Get Pools HIstorical Liquidity")</inline-code> | 5 |

</div>

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less

**<a href="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=docs-Bonfida">Get Cryptosheets for Microsoft Excel</a>**

**<a href="https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?hl=en&pann=sheets_addon_widget?src=docs-Bonfida">Get Cryptosheets for Googlesheets</a>**

\*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

**<a href="https://bonfida.com/">Click here</a>** for additional documentation from Bonfida

Learn more [here](https://intercom.help/cryptosheets/en/)

---

Tags: `Bonfida` `provider` 


How to pull Bonfida data into Excel and Google Sheets