# Force Index

#### gagdeep

##### Member
Inputs: XLen2(3), FrceIdx(V*(C-C[1]));
Vars: Zero(0);

Plot2(XAverage(FrceIdx, XLen2), "Slow Avg");
Plot3(Zero, "Zero");

#### irving_freeman

##### Member
Thank you very much!

#### sandysudarshan

##### Member
Can anybody post the formula for Force Index , to be calculated on Excel Sheet, I am able to get 3 day ema, 13 day ema but unable to smooth this with 13 day ema

#### taza603

##### Member
anybody out there that can help, im having issues applying this in excel too!

#### Divz

##### Member
anybody out there that can help, im having issues applying this in excel too!

#### blancspa

##### Active member
By Alexander Elder

p 228 (go to google books)

or from MT4
FORCE INDEX (i) = VOLUME (i) * ((MA (ApPRICE, N, i) - MA (ApPRICE, N, i-1))

where:
FORCE INDEX (i) — Force Index of the current bar;
VOLUME (i) — volume of the current bar;
MA (ApPRICE, N, i) — any Moving Average of the current bar for N period:
Simple, Exponential, Weighted or Smoothed;
ApPRICE — applied price;
N — period of the smoothing;
MA (ApPRICE, N, i-1) — any Moving Average of the previous bar.

or

http://www.metastocktools.com/MetaStock/ForceIdx.txt

Last edited:

#### Gbase

##### Member
All greetings. Prompt please. Here this formula of an index of force you smoothed it by means of two day EMA. Or it in options should be smoothed???
And it is the formula from a disk of Elder???
In this text possible grammatic errors so I from Russia.