All Collections
Custom Functions
How to use =CS.TA custom function for quick technical analysis data
How to use =CS.TA custom function for quick technical analysis data

The shortest article you’ll ever read about Crypto Technical Analysis and how to get the data in Cryptosheets in seconds

C
Written by Chris Ware
Updated over a week ago

Overview

How fast can you pull multi-period SMA, volatility, percentage change and variance indicators — for any combination of crypto pairs at any exchanges?

What is Technical analysis (TA)?

Technical analysis (TA) indicators are transformations of underlying price series data. They are prolific in trading and with chart happy trolls. They’re also very difficult to actually get the raw data for. Not anymore.

The above example demonstrates how easy it is to use the most fundamental and powerful TA transformations in Cryptosheets (moving averages, volatility, period change, variance — upon which nearly all other TA indicators are built)

Examples

Using custom functions

From any cell in your spreadsheet type the following
=CS.TA() 

Example Scenario:

User wants to easily identify trending patterns or "crosses"  where longer term moving averages cross over or through shorter term averages.

(Possible) Data fields returned:

  • value | Price of the asset in USD

  • base | Symbol or symbols of the asset using csv (BTC)

  • quote | Query based off of a specific quote symbol

  • exchange | Query based off of a specific name or names for exchange

  • change1 | Percent Change for the trailing 1 periods (usually days)

  • change10 | Percent Change for the trailing 10 periods (usually days)

  • change180 | Percent Change for the trailing 180 periods (usually days)

  • change20 | Percent Change for the trailing 20 periods (usually days)

  • change30 | Percent Change for the trailing 30 periods (usually days)

  • change365 | Percent Change for the trailing 365 periods (usually days)

  • change5 | Percent Change for the trailing 5 periods (usually days)

  • change50 | Percent Change for the trailing 50 periods (usually days)

  • change7 | Percent Change for the trailing 7 periods (usually days)

  • change90 | Percent Change for the trailing 90 periods (usually days)

  • datetimeUTC | Date as the coordinated universal time (UTC) convention

  • sma10 | Simple moving average for the trailing 10 periods (usually days)

  • sma100 | Simple moving average for the trailing 100 periods (usually days)

  • sma20 | Simple moving average for the trailing 20 periods (usually days)

  • sma200 | Simple moving average for the trailing 200 periods (usually days)

  • sma30 | Simple moving average for the trailing 30 periods (usually days)

  • sma365 | Simple moving average for the trailing 365 periods (usually days)

  • sma5 | Simple moving average for the trailing 5 periods (usually days)

  • sma50 | Simple moving average for the trailing 50 periods (usually days)

  • sma7 | Simple moving average for the trailing 7 periods (usually days)

  • var10 | Variance for the trailing 10 periods (usually days)

  • var20 | Variance for the trailing 20 periods (usually days)

  • var30 | Variance for the trailing 30 periods (usually days)

  • var5 | Variance for the trailing 5 periods (usually days)

  • var50 | Variance for the trailing 50 periods (usually days)

  • var7 | Variance for the trailing 7 periods (usually days)

  • vol10 | Volatility for the trailing 10 periods (usually days)

  • vol20 | Volatility for the trailing 20 periods (usually days)

  • vol30 | Volatility for the trailing 30 periods (usually days)

  • vol5 | Volatility for the trailing 5 periods (usually days)

  • vol50 | Volatility for the trailing 50 periods (usually days)

  • vol7 | Volatility for the trailing 7 periods (usually days)

Using templates

Open the TA Indicators template from the side panel: https://app.cryptosheets.com/#/templates/191

Multi period technical analysis indicators for thousands of pairs across hundreds of exchanges

Best part?

it’s just a formula so you can change and refresh it whenever you want

Multi period technical analysis indicators for thousands of pairs across hundreds of exchanges

________________________________________________________________
TAGS: googlehseets, excel, technical analysis, indicators, TA, moving average, volatility, variance, percent change, roi, sma, ema

Did this answer your question?