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