The following table outlines the study syntax that can be used within the Grid. The table uses Daily as its example, but the following are available:
=DAILY
=WEEKLY
= MONTHLY
=INTRADAY(<Interval>,<StudySyntax>)
Adaptive Moving Average | |
Default Parameters | =DAILY(AMA(<Symbol>)) |
Custom Parameters | =DAILY(AMA(<Symbol>,9,2,30)) |
Adaptive Moving Average 2 | |
Default Parameters | =DAILY(AMA2(<Symbol>)) |
Custom Parameters | =DAILY(AMA2(<Symbol>,9,2,30)) |
Advance Decline Ratio | |
Custom Parameters | =DAILY(ADR('$ADV','$DECL')) |
A/D Line | |
Default Parameters | =DAILY(ADL()) |
Custom Parameters | =DAILY(ADL(NASDAQ)) |
Average Directional Index | |
Default Parameters | =DAILY(ADX(<Symbol>)) |
Custom Parameters | =DAILY(ADX(<Symbol>,14)) |
Average True Range | |
Default Parameters | =DAILY(ATR(<Symbol>)) |
Custom Parameters | =DAILY(ATR(<Symbol>,14)) |
Bearish Divergence | |
Default Parameters | =DAILY(BEAR(<Symbol>)) |
Custom Parameters | =DAILY(BEAR(<Symbol>,9,0,RSI)) |
Bollinger Bands | |
Default Paramters (Hi) | =DAILY(BOLL(<Symbol>).Hi) |
Default Paramters (MA | =DAILY(BOLL(<Symbol>).Ma) |
Default Paramters (Lo) | =DAILY(BOLL(<Symbol>).Lo) |
Custom Parameters (Hi) | =DAILY(BOLL(<Symbol>,20,2.0).Hi) |
Custom Parameters (MA) | =DAILY(BOLL(<Symbol>,20,2.0).Ma) |
Custom Parameters (Lo) | =DAILY(BOLL(<Symbol>,20,2.0).Lo) |
Bollinger Bands %B | |
Default Paramters | =DAILY(PCNTB(<Symbol>)) |
Custom Parameters | =DAILY(PCNTB(<Symbol>,20,2.0)) |
Bullish Divergence | |
Default Paramters | =DAILY(BULL(<Symbol>)) |
Custom Parameters | =DAILY(BULL(<Symbol>,9,0,RSI)) |
Composite Index | |
Default Paramters | =DAILY(CBCI(<Symbol>)) |
Custom Parameters | =DAILY(CBCI(<Symbol>,13,33)) |
Delta Oscillator | |
Default Paramters | =DAILY(CBOE(<Symbol>)) |
Custom Parameters | =DAILY(CBOE(<Symbol>,20,50)) |
Commodity Channel Index | |
Default Paramters | =DAILY(CCI(<Symbol>)) |
Custom Parameters | =DAILY(CCI(<Symbol>,20)) |
Choppines | |
Default Parameters | =DAILY(CHOP(<Symbol>)) |
Custom Parameters | =DAILY(CHOP(<Symbol>,14)) |
Correlation | |
Custom Parameters | =DAILY(CORR(<Symbol1>,<Symbol2>)) |
Directional Index | |
Default Parameters | =DAILY(DX(<Symbol>)) |
Custom Parameters | =DAILY(DX(<Symbol>,14)) |
Directional Movement Index | |
Default Parameters | =DAILY(DMI(<Symbol>)) |
Custom Parameters | =DAILY(DMI(<Symbol>,14)) |
Displaced Moving Average | |
Default Parameters | =DAILY(DMA(<Symbol>)) |
Custom Parameters | =DAILY(DMA(<Symbol>,9,10)) |
Displaced Weighted Moving Average | |
Default Parameters | =DAILY(DWMA(<Symbol>)) |
Custom Parameters | =DAILY(DWMA(<Symbol>,9)) |
Envelope | |
Default Parameters | =DAILY(ENV(<Symbol>)) |
Custom Parameters | =DAILY(ENV(<Symbol>,10,1.0)) |
Exponential Moving Average | |
Default Parameters | =DAILY(EMA(<Symbol>)) |
Custom Parameters | =DAILY(EMA(<Symbol>,9)) |
Exponential Oscillator | |
Default Parameters | =DAILY(EOSC(<Symbol>)) |
Custom Parameters | =DAILY(EOSC(<Symbol>,5,10)) |
Highest High Lowest Low | |
Default Paramters (Hi) | =DAILY(HHLL(<Symbol>).High) |
Default Paramters (Low) | =DAILY(HHLL(<Symbol>).Low) |
Custom Paramters (Hi) | =DAILY(HHLL(<Symbol>,10,10).High) |
Custom Paramters (Low) | =DAILY(HHLL(<Symbol>,10,10).Low) |
High Low Moving Average | |
Default Paramters (Hi) | =DAILY(HLMA(<Symbol>).High) |
Default Paramters (Low) | =DAILY(HLMA(<Symbol>).Low) |
Custom Paramters (Hi) | =DAILY(HLMA(<Symbol>,10,10).High) |
Custom Paramters (Low) | =DAILY(HLMA(<Symbol>,10,10).Low) |
Historic Volatility | |
Default Paramters | =DAILY(HV(<Symbol>)) |
Custom Paramters | =DAILY(HV(<Symbol>,20)) |
Ichimoku | |
Default Paramters (1) | =DAILY(ICH1(<Symbol>)) |
Default Paramters (2) | =DAILY(ICH2(<Symbol>)) |
Default Paramters (3) | =DAILY(ICH3(<Symbol>)) |
Keltner Channel | |
Default Parameters | =DAILY(KC(<Symbol>)) |
Custom Parameters | =DAILY(KC(<Symbol>,10)) |
Line Oscillator | |
Default Parameters (MA) | =DAILY(LOSC(<Symbol>).MA) |
Default Parameters (OSC) | =DAILY(LOSC(<Symbol>).OSC) |
Custom Parameters (MA) | =DAILY(LOSC(<Symbol>,6,21,6).MA) |
Custom Parameters (OSC) | =DAILY(LOSC(<Symbol>,6,21,6).OSC) |
MACD | |
Default Parameters (MA) | =DAILY(MACD(<Symbol>).OSC) |
Default Parameters (OSC) | =DAILY(MACD(<Symbol>).EMA) |
Default Parameters (OSC) | =DAILY(MACD(<Symbol>).DIF) |
Custom Parameters (MA) | =DAILY(MACD(<Symbol>,12,26,9).OSC) |
Custom Parameters (OSC) | =DAILY(MACD(<Symbol>,12,26,9).EMA) |
Custom Parameters (OSC) | =DAILY(MACD(<Symbol>,12,26,9).DIF) |
Mean Price | |
Default Parameters | =DAILY(MP(<Symbol>)) |
Momentum | |
Default Parameters | =DAILY(MOM(<Symbol>)) |
Custom Parameters | =DAILY(MOM(<Symbol>,10)) |
Money Flow Index | |
Default Parameters | =DAILY(MFI(<Symbol>)) |
Custom Parameters | =DAILY(MFI(<Symbol>,14)) |
Moving Average | |
Default Parameters | =DAILY(MA(<Symbol>)) |
Custom Parameters | =DAILY(MA(<Symbol>,20)) |
Moving Standard Deviation | |
Default Parameters | =DAILY(MSD(<Symbol>)) |
Custom Parameters | =DAILY(MSD(<Symbol>,20)) |
On Balance Volume | |
Default Parameters | =DAILY(OBV(<Symbol>)) |
Open Price | |
Default Parameters | =DAILY(OP(<Symbol>)) |
Oscillator | |
Default Parameters | =DAILY(OSC(<Symbol>)) |
Custom Parameters | =DAILY(OSC(<Symbol>,5,10)) |
Over Bought Over Sold | |
Default Parameters | =DAILY(OBOS(<Symbol>)) |
Custom Parameters | =DAILY(OBOS(<Symbol>,14)) |
Pivot Points | |
Default Parameters (Pivot) | =DAILY(Pivot(<Symbol>).PIVOT) |
Default Parameters (S1) | =DAILY(Pivot(<Symbol>).S1) |
Default Parameters (S2) | =DAILY(Pivot(<Symbol>).S2) |
Default Parameters (R1) | =DAILY(Pivot(<Symbol>).r1) |
Default Parameters (R2) | =DAILY(Pivot(<Symbol>).r2) |
Custom Parameters (Pivot) | =DAILY(Pivot(<Symbol>,1).PIVOT) |
Custom Parameters (S1) | =DAILY(Pivot(<Symbol>,1).S1) |
Custom Parameters (S2) | =DAILY(Pivot(<Symbol>,1).S2) |
Custom Parameters (R1) | =DAILY(Pivot(<Symbol>,1).r1) |
Custom Parameters (R2) | =DAILY(Pivot(<Symbol>,1).r2) |
Pivot Points Moving Average | |
Default Parameters (Pivot) | =DAILY('Pivot-MA'(<Symbol>).PIVOT) |
Default Parameters (S1) | =DAILY('Pivot-ma'(<Symbol>).S1) |
Default Parameters (S2) | =DAILY('Pivot-ma'(<Symbol>).S2) |
Default Parameters (R1) | =DAILY('Pivot-ma'(<Symbol>).r1) |
Default Parameters (R2) | =DAILY('Pivot-ma'(<Symbol>).r2) |
Custom Parameters (Pivot) | =DAILY('Pivot-ma'(<Symbol>,3,1).PIVOT) |
Custom Parameters (S1) | =DAILY('Pivot-ma'(<Symbol>,3,1).S1) |
Custom Parameters (S2) | =DAILY('Pivot-ma'(<Symbol>,3,1).S2) |
Custom Parameters (R1) | =DAILY('Pivot-ma'(<Symbol>,3,1).r1) |
Custom Parameters (R2) | =DAILY('Pivot-ma'(<Symbol>,3,1).r2) |
Price Channel | |
Default Parameters (Upper) | =DAILY(PrCh(<Symbol>).'Upper Channel') |
Default Parameters (Center)) | =DAILY(PrCh(<Symbol>).CENTERLINE) |
Default Parameters (Lower) | =DAILY(PrCh(<Symbol>).'Lower Channel') |
Custom Parameters (Upper) | =DAILY(PrCh(<Symbol>,20).'Upper Channel') |
Custom Parameters (Center) | =DAILY(PrCh(<Symbol>,20).CENTERLINE) |
Custom Parameters (Lower) | =DAILY(PrCh(<Symbol>,20).'Lower Channel') |
Rate of Change | |
Default Parameters | =DAILY(ROC(<Symbol>)) |
Custom Parameters | =DAILY(ROC(<Symbol>,10)) |
Relative Strength Index | |
Default Parameters | =DAILY(RSI(<Symbol>)) |
Custom Parameters | =DAILY(RSI(<Symbol>,14)) |
Rolling Moving Average | |
Default Parameters | =DAILY(RMA(<Symbol>)) |
Custom Parameters | =DAILY(RMA(<Symbol>,9)) |
Slow Stochastic | |
Default Parameters (K) | =DAILY(SSTOC(<Symbol>).'%K') |
Default Parameters (D) | =DAILY(SSTOC(<Symbol>).'%D') |
Custom Parameters (K) | =DAILY(SSTOC(<Symbol>,14,3,3).'%K') |
Custom Parameters (D) | =DAILY(SSTOC(<Symbol>,14,3,3).'%D') |
Smoothed Moving Average | |
Default Parameters | =DAILY(SMA(<Symbol>)) |
Custom Parameters | =DAILY(SMA(<Symbol>,9)) |
Smoothed Oscillator | |
Default Parameters | =DAILY(SOSC(<Symbol>)) |
Custom Parameters | =DAILY(SOSC(<Symbol>,5,10)) |
Stochastic | |
Default Parameters (K) | =DAILY(STOC(<Symbol>).'%K') |
Default Parameters (D) | =DAILY(STOC(<Symbol>).'%D') |
Custom Parameters (K) | =DAILY(STOC(<Symbol>,14,3).'%K') |
Custom Parameters (D) | =DAILY(STOC(<Symbol>,14,3).'%D') |
TEMA | |
Default Parameters | =DAILY(TEMA(<Symbol>)) |
Custom Parameters | =DAILY(TEMA(<Symbol>,30)) |
TRIX | |
Default Parameters | =DAILY(TRIx(<Symbol>)) |
Custom Parameters | =DAILY(TRIX(<Symbol>,30)) |
Triangular Moving Average | |
Default Parameters | =DAILY(TMA(<Symbol>)) |
Custom Parameters | =DAILY(TMA(<Symbol>,9)) |
Ultimate Oscillator | |
Default Parameters | =DAILY(UltOsc(<Symbol>)) |
Custom Parameters | =DAILY(UltOsc(<Symbol>,14,21,28)) |
Variable Moving Average | |
Default Parameters (VMA1) | =DAILY(VMA(<Symbol>).'VMA1') |
Default Parameters (VMA2) | =DAILY(VMA(<Symbol>).'VMA2') |
Default Parameters (VMA3) | =DAILY(VMA(<Symbol>).'VMA3') |
Custom Parameters (VMA1) | =DAILY(VMA(<Symbol>,10).'VMA1') |
Custom Parameters (VMA2) | =DAILY(VMA(<Symbol>,10).'VMA2') |
Custom Parameters (VMA3) | =DAILY(VMA(<Symbol>,10).'VMA3') |
Weighted Close | |
Default Parameters | =DAILY(WTCL(<Symbol>)) |
Weighted Moving Average | |
Default Parameters | =DAILY(WMA(<Symbol>)) |
Custom Parameters | =DAILY(WMA(<Symbol>,9)) |
Williams Accum/Dist | |
Default Parameters | =DAILY(AD(<Symbol>)) |
Williams %R | |
Default Parameters | =DAILY(%R(<Symbol>)) |
Custom Parameters | =DAILY(%R(<Symbol>,10)) |