=CS.TA

Use Case Scenarios

TA - Syntax

Function arguments

Function argume...

PARAMETERS - Ab...

TA - Examples

Troubleshooting

Additional Reso...



## =CS.TA

In its simplest form, the TA function says

```
=CS.TA(what base asset, what quoted asset, what exchange or data provider)
```

> **REMINDER** Using Cryptosheets custom functions in Excel vs Googlesheets is almost exactly the same with a few very slight differences. **The most important one** is that in **Excel there is a "." (period) between the CS and the function name** so `=CS.TA()`. In **Googlesheets **there is NO "." (period) after the CS\*\* so the formula is simply `=CSTA()`

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

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

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

### Use Case Scenarios

`When you need to quickly pull in precalculated multi period returns, volatility or averages without manually calculating each one`

---

## TA - Syntax

### Function arguments

Arguments: `=CS.TA("base","quote","exchange","args")`

Example Values: `=CS.TA("BTC","USD","Coinbase","")`

### Function argument descriptions

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

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

- **base**: The crypto asset symbol of interest [string] optional
- **quote**: Symbol of asset or currency to convert into [string] optional
- **exchange**: Name of exchange [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.TA("BTC","USD","Coinbase","")`

**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.TA("A1","A2","A3")`

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

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTA-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

---

## TA - Examples

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

**Example 1:**

> `=CS.TA()`

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

**Example 2:**

> **`=CS.TA("BTC")`**

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

**Example 3:**

> **`=CS.TA("BTC","USD","Coinbase")`**

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTA-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**
7. <a
     href="https://support.office.com/en-us/article/function-arguments-65b29fb5-ec7b-4c0b-a54b-a67923571519"
     rel="noopener noreferrer"
     target="_blank"
   >
     Check Excels help sections
   </a>
8. Error Response Codes Reference

   - **#N/A** OK – Everything worked as expected
   - **#BUSY** Heavy query and/or unauthorized – Your User/Password API Keys are incorrect
   - **#LIMIT** Forbidden – You are not subscribed to the data feed requested
   - **Other** Something else? Reach out to us directly

## Additional Resources

_For Microsoft Excel_

- <a
    href="https://docs.microsoft.com/en-us/office/dev/add-ins/concepts/browsers-used-by-office-web-add-ins"
    rel="noopener noreferrer"
    target="_blank"
  >
    Web browsers used by add-ins
  </a>
- <a
    href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets"
    rel="noopener noreferrer"
    target="_blank"
  >
    Office versions and requirement sets
  </a>
- <a
    href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets#how-to-check-your-office-version"
    rel="noopener noreferrer"
    target="_blank"
  >
    How to check your Office version
  </a>
- <a
    href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/install-latest-office-version"
    rel="noopener noreferrer"
    target="_blank"
  >
    Install the latest version of Office
  </a>
- <a
    href="https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture"
    rel="noopener noreferrer"
    target="_blank"
  >
    Custom Function Requirements
  </a>

_For Googlesheets_

- <a
    href="https://developers.google.com/apps-script/guides/services/quotas"
    rel="noopener noreferrer"
    target="_blank"
  >
    Throughput Quotas & Limits
  </a>


Use the TA function to get multi period returns, volatility, moving averages and variance for any pair and exchange.

How to use TA in Excel & Googlesheets