=CS.TRADES

Use Case Scenarios

TRADES - Syntax

Function arguments

Function argume...

PARAMETERS - Ab...

TRADES - Examples

Troubleshooting


## =CS.TRADES

In its simplest form, the TRADES function says

```
=CS.TRADES(what base asset, what quoted asset, on what exchange, for what type of instrument)
```

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTRADES-syntax.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTRADES-autocomplete.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/google/functions/cstrades-autocomplete.png)

### Use Case Scenarios

`When you need maximum data granularity for specific historical trade activity for specific base, quote and exchange pairs or instrument types`

---

## TRADES - Syntax

### Function arguments

Arguments: `=CS.TRADES("base","quote","exchange","type","timeStart","timeEnd","args")`

Example Values: `=CS.TRADES("BTC","USD","Coinbase","SPOT","2/1/2020","2/2/2020","")`

### Function argument descriptions

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTRADES-syntax-autocomplete.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTRADES-syntax-example.gif)

- **base**: The cryptocurrency symbol of interest [string] required
- **quote**: Symbol of asset or currency to convert into [string] required
- **exchange**: Name of exchange [string] required
- **type**: Type of price ie spot or futures [string] required
- **timeStart**: Timeseries starting time in ISO 8601 [string] optional
- **timeEnd**: Timeseries ending time in ISO 8601 [string] optional
- **args**: Optional: Global arguments, ex. limit, fields [any] optional

### PARAMETERS - Absolute vs. Relative

**Absolute Parameter Values**

Formulas using **absolute values** for arguments with multiple parameters must be referenced inside an array using `{"curly_brackets"}` and will look like this:

`=CS.TRADES("BTC","USD","Coinbase","SPOT")`

**Relative Parameter Values**

Formulas using **referenced values** for arguments with multiple parameters must be referenced inside an array using a defined range and will look like this _(\*Note - `{"curly_brackets"}` are NOT required when using referenced values)_:

`=CS.TRADES("B1","B2","B3","B4","B5","B6","A8:B8")`

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTRADES-relative-cells.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTRADES-relative-example.gif)

<a
  href="https://app.cryptosheets.com/#/browse"
  rel="noopener noreferrer"
  target="_blank"
>
  Click here
</a> to search for data providers and endpoints

---

## TRADES - Examples

**TIP**: _Try copying + pasting the example formulas directly into your worksheet_

**Example 1:**

> `=CS.TRADES("btc","usd","coinbase","spot")`

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTRADES-example1.png)

**Example 2:**

> **`=CS.TRADES("btc","usd","bitmex","perp")`**

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTRADES-example2.png)

**Example 3:**

> **`=CS.TRADES("btc","usd","deribit","opt",,,{"optionExpirationTime",191025;"optionStrikePrice",7500;"optionType","P"})`**

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTRADES-example3.png)

### Troubleshooting

1. Check your formula syntax for carefully, different functions for the same data may have slightly different required syntax
2. Check the **required arguments** for your function vs the **optional arguments**
3. Check your data & API quotas and limits
4. Check your formulas carefully
5. Check your relative references
6. Use Excels **error checking tools**


Use the TRADES function to get historical transactions from specific symbol, returned in time ascending order.

How to use TRADES in Excel & Googlesheets

TRADES