Overview
How fast can you pull multiperiod 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