All Collections
Custom Functions
Technical Indicators
Technical Indicator Custom Functions in Cryptosheets
Technical Indicator Custom Functions in Cryptosheets

Learn how to use dozens of powerful technical indicators on any crypto data with simple formulas in Excel & Googlesheets.

C
Written by Chris Ware
Updated over a week ago

OVERVIEW

Follow these steps to get started with Cryptosheets technical indicators

  1. Visit our dedicated Cryptosheets docs pages for technical indicator custom functions including examples & tutorials

  2. In cell A1 of a blank sheet in your workbook type the following to return the full list of 160+ technical indicators available to higher tier paid subscriptions

    Excel: =CS.TAMETADATA()
    Googlesheets: =CSTAMETADATA()

TAGS: =CS.ADD,=CS.DIV,=CS.MAX,=CS.MAXINDEX,=CS.MIN,=CS.MININDEX,=CS.MINMAX,=CS.MINMAXINDEX,=CS.MULT,=CS.SUB,=CS.SUM,=CS.ACOS,=CS.ASIN,=CS.ATAN,=CS.CEIL,=CS.COS,=CS.COSH,=CS.EXP,=CS.FLOOR,=CS.LN,=CS.LOG10,=CS.SIN,=CS.SINH,=CS.SQRT,=CS.TAN,=CS.TANH,=CS.ACCBANDS,=CS.BBANDS,=CS.DEMA,=CS.EMA,=CS.HT_TRENDLINE,=CS.KAMA,=CS.MA,=CS.MAMA,=CS.MAVP,=CS.MIDPOINT,=CS.MIDPRICE,=CS.SAR,=CS.SAREXT,=CS.SMA,=CS.T3,=CS.TEMA,=CS.TRIMA,=CS.WMA,=CS.ATR,=CS.NATR,=CS.TRANGE,=CS.ADX,=CS.ADXR,=CS.APO,=CS.AROON,=CS.AROONOSC,=CS.BOP,=CS.CCI,=CS.CMO,=CS.DX,=CS.IMI,=CS.MACD,=CS.MACDEXT,=CS.MACDFIX,=CS.MFI,=CS.MINUS_DI,=CS.MINUS_DM,=CS.MOM,=CS.PLUS_DI,=CS.PLUS_DM,=CS.PPO,=CS.ROC,=CS.ROCP,=CS.ROCR,=CS.ROCR100,=CS.RSI,=CS.STOCH,=CS.STOCHF,=CS.STOCHRSI,=CS.TRIX,=CS.ULTOSC,=CS.WILLR,=CS.HT_DCPERIOD,=CS.HT_DCPHASE,=CS.HT_PHASOR,=CS.HT_SINE,=CS.HT_TRENDMODE,=CS.AD,=CS.ADOSC,=CS.OBV,=CS.CDL2CROWS,=CS.CDL3BLACKCROWS,=CS.CDL3INSIDE,=CS.CDL3LINESTRIKE,=CS.CDL3OUTSIDE,=CS.CDL3STARSINSOUTH,=CS.CDL3WHITESOLDIERS,=CS.CDLABANDONEDBABY,=CS.CDLADVANCEBLOCK,=CS.CDLBELTHOLD,=CS.CDLBREAKAWAY,=CS.CDLCLOSINGMARUBOZU,=CS.CDLCONCEALBABYSWALL,=CS.CDLCOUNTERATTACK,=CS.CDLDARKCLOUDCOVER,=CS.CDLDOJI,=CS.CDLDOJISTAR,=CS.CDLDRAGONFLYDOJI,=CS.CDLENGULFING,=CS.CDLEVENINGDOJISTAR,=CS.CDLEVENINGSTAR,=CS.CDLGAPSIDESIDEWHITE,=CS.CDLGRAVESTONEDOJI,=CS.CDLHAMMER,=CS.CDLHANGINGMAN,=CS.CDLHARAMI,=CS.CDLHARAMICROSS,=CS.CDLHIGHWAVE,=CS.CDLHIKKAKE,=CS.CDLHIKKAKEMOD,=CS.CDLHOMINGPIGEON,=CS.CDLIDENTICAL3CROWS,=CS.CDLINNECK,=CS.CDLINVERTEDHAMMER,=CS.CDLKICKING,=CS.CDLKICKINGBYLENGTH,=CS.CDLLADDERBOTTOM,=CS.CDLLONGLEGGEDDOJI,=CS.CDLLONGLINE,=CS.CDLMARUBOZU,=CS.CDLMATCHINGLOW,=CS.CDLMATHOLD,=CS.CDLMORNINGDOJISTAR,=CS.CDLMORNINGSTAR,=CS.CDLONNECK,=CS.CDLPIERCING,=CS.CDLRICKSHAWMAN,=CS.CDLRISEFALL3METHODS,=CS.CDLSEPARATINGLINES,=CS.CDLSHOOTINGSTAR,=CS.CDLSHORTLINE,=CS.CDLSPINNINGTOP,=CS.CDLSTALLEDPATTERN,=CS.CDLSTICKSANDWICH,=CS.CDLTAKURI,=CS.CDLTASUKIGAP,=CS.CDLTHRUSTING,=CS.CDLTRISTAR,=CS.CDLUNIQUE3RIVER,=CS.CDLUPSIDEGAP2CROWS,=CS.CDLXSIDEGAP3METHODS,=CS.BETA,=CS.CORREL,=CS.LINEARREG,=CS.LINEARREG_ANGLE,=CS.LINEARREG_INTERCEPT,=CS.LINEARREG_SLOPE,=CS.STDDEV,=CS.TSF,=CS.VAR,=CS.AVGPRICE,=CS.AVGDEV,=CS.MEDPRICE,=CS.TYPPRICE,=CS.WCLPRICE

Vector Arithmetic Add,Vector Arithmetic Div,Highest value over a specified period,Index of highest value over a specified period,Lowest value over a specified period,Index of lowest value over a specified period,Lowest and highest values over a specified period,Indexes of lowest and highest values over a specified period,Vector Arithmetic Mult,Vector Arithmetic Substraction,Summation,Vector Trigonometric ACos,Vector Trigonometric ASin,Vector Trigonometric ATan,Vector Ceil,Vector Trigonometric Cos,Vector Trigonometric Cosh,Vector Arithmetic Exp,Vector Floor,Vector Log Natural,Vector Log10,Vector Trigonometric Sin,Vector Trigonometric Sinh,Vector Square Root,Vector Trigonometric Tan,Vector Trigonometric Tanh,Acceleration Bands,Bollinger Bands,Double Exponential Moving Average,Exponential Moving Average,Hilbert Transform - Instantaneous Trendline,Kaufman Adaptive Moving Average,Moving average,MESA Adaptive Moving Average,Moving average with variable period,MidPoint over period,Midpoint Price over period,Parabolic SAR,Parabolic SAR - Extended,Simple Moving Average,Triple Exponential Moving Average (T3),Triple Exponential Moving Average,Triangular Moving Average,Weighted Moving Average,Average True Range,Normalized Average True Range,True Range,Average Directional Movement Index,Average Directional Movement Index Rating,Absolute Price Oscillator,Aroon,Aroon Oscillator,Balance Of Power,Commodity Channel Index,Chande Momentum Oscillator,Directional Movement Index,Intraday Momentum Index,Moving Average Convergence/Divergence,MACD with controllable MA type,Moving Average Convergence/Divergence Fix 12/26,Money Flow Index,Minus Directional Indicator,Minus Directional Movement,Momentum,Plus Directional Indicator,Plus Directional Movement,Percentage Price Oscillator,Rate of change : ((price/prevPrice)-1)*100,Rate of change Percentage: (price-prevPrice)/prevPrice,Rate of change ratio: (price/prevPrice),Rate of change ratio 100 scale: (price/prevPrice)*100,Relative Strength Index,Stochastic,Stochastic Fast,Stochastic Relative Strength Index,1-day Rate-Of-Change (ROC) of a Triple Smooth EMA,Ultimate Oscillator,Williams' %R,Hilbert Transform - Dominant Cycle Period,Hilbert Transform - Dominant Cycle Phase,Hilbert Transform - Phasor Components,Hilbert Transform - SineWave,Hilbert Transform - Trend vs Cycle Mode,Chaikin A/D Line,Chaikin A/D Oscillator,On Balance Volume,Two Crows,Three Black Crows,Three Inside Up/Down,Three-Line Strike ,Three Outside Up/Down,Three Stars In The South,Three Advancing White Soldiers,Abandoned Baby,Advance Block,Belt-hold,Breakaway,Closing Marubozu,Concealing Baby Swallow,Counterattack,Dark Cloud Cover,Doji,Doji Star,Dragonfly Doji,Engulfing Pattern,Evening Doji Star,Evening Star,Up/Down-gap side-by-side white lines,Gravestone Doji,Hammer,Hanging Man,Harami Pattern,Harami Cross Pattern,High-Wave Candle,Hikkake Pattern,Modified Hikkake Pattern,Homing Pigeon,Identical Three Crows,In-Neck Pattern,Inverted Hammer,Kicking,Kicking - bull/bear determined by the longer marubozu,Ladder Bottom,Long Legged Doji,Long Line Candle,Marubozu,Matching Low,Mat Hold,Morning Doji Star,Morning Star,On-Neck Pattern,Piercing Pattern,Rickshaw Man,Rising/Falling Three Methods,Separating Lines,Shooting Star,Short Line Candle,Spinning Top,Stalled Pattern,Stick Sandwich,Takuri (Dragonfly Doji with very long lower shadow),Tasuki Gap,Thrusting Pattern,Tristar Pattern,Unique 3 River,Upside Gap Two Crows,Upside/Downside Gap Three Methods,Beta,Pearson's Correlation Coefficient (r),Linear Regression,Linear Regression Angle,Linear Regression Intercept,Linear Regression Slope,Standard Deviation,Time Series Forecast,Variance,Average Price,Average Deviation,Median Price,Typical Price,Weighted Close Price

Did this answer your question?