Manual English Others

## Simple Explanation on Repainting, Recalculating, and Static Algorithm in Technical Analysis

Below is the Text Only Excerpt automatically extracted From the Full PDF Article for Non PDF Viewer:

Simple Explanation on Repainting, Recalculating, and Static Algorithm in Technical Analysis for the Financial Trading

3 Feb 2018

Written By Young Ho Seo

• Market Profile (invented by J. Peter Stdidlmayer)
• Fractal indicator (invented by Bill Williams)
• Fourier transform and many other signal processing algorithm (invented by Joseph Fourier and many others)
• ZigZag indicator
• Fast moving average including many zero-lag or non-lag moving average family
• Harmonic Pattern (invented by H.M. Gartley, any many others later on)
• Other technical analysis algorithm
The above technical analysis and their algorithm are used by several millions of traders and scientists every day. If you are doubt, just google to look for the internet community using those technical analysis. If those technical analysis and their algorithms are repainting and bad, then why so many people are using them? Well, I think that this will remain as a myth to you until you can clear the misunderstanding about the repainting indicator.
What is really a repainting indicator?
Firstly, what does the repainting means? In the Cambridge dictionary, “repaint” is a verb with a meaning “to paint something again”. In Collins dictionary, “repaint” have a meaning “to apply a new or fresh coat of paint”. The meaning of repainting is almost identical in both dictionary. The example provided by the Cambridge dictionary is:
“The white walls were repainted in pastel shades.”
Two examples provided by the Collins dictionary are:
“Now they kill the crew, repaint and rename the ship, change the flag and papers and steal the cargo, and any other cargo they can find.” (Robert Wilson, INSTRUMENTS OF DARKNESS, 2002)
“But before that – in just an hour or two – a squad of men from the RASC were going to arrive to repaint the interior of the hospital.” (Aldiss Brian, SOMEWHERE EAST OF LIFE, 2002)
You can tell that the term “repainting” is often used to remove or to hide old colours or patterns on the surface by applying new fresh coat of paint. Based on this, in the repainting indicator, the indicator lines or values are repainted every time so that old indicator lines or values can not be found any longer. Is this the case for the above technical analysis algorithm?
Simple answer is no. The above algorithms have nothing to do with repainting. Above technical analysis algorithms keep the old indicator lines or values as they are. Just the latest values can change. For example, in the case of the daily market profile, except today’s market profile, all the past market profile will remain the same. It does not matter how many days you go back to the past, all the past market profile will remain the same. Then why the latest value or indicator line can change? It is because the algorithm is doing recalculation while the latest price is updating in the last candle bar.
The repainting indicator will not keep any old indicator lines or old values since repainting will override all the past values to something new. Literally, the repainting indicator is the random indicator due to some serious bugs or internal logic problem inside the indicator. When the repainting happens, 9 out of 10, it is due to some irritating bugs inside the algorithm.
However, there is also human problem too about the repainting indicator. It is because people use the term “repainting” and “recalculating” interchangeably on the net. This is incorrect and false information. It might start with one or few trader who do not have much experience in trading at the beginning. However, I can tell that this misunderstanding was growing and spreading fast like virus on the net last few years.
Now, if you can tell the difference between repainting and recalculating, then it is good. If not, still do not worry. We will tell you how to differentiate the repainting and recalculating indicators. The best way to differentiate between repainting and recalculating indicator is by asking this question “Does technical analysis algorithm keeps the old values (or old indicator lines) unchanged except the latest value?”  Now consider the simple moving average with the period of 10 as shown in Figure 1. The latest moving average value can change as the new price arrives. The rest of moving average value will stay the same. Likewise, in Figure 2, the latest fractal value can change as the new price arrives. However, except the first fractal, rest of fractals will not change. Likewise, in Figure 3, the first zigzag value can change as the new price arrives. However, except the first zigzag value, rest of zigzag will not change. The same goes for the market profile and other technical analysis algorithm.

Figure 1: Simple Moving average with the period 10 in EURUSD.

Figure 2: Fractal indicator in EURUSD.

Figure 3: Zigzag indicator in EURUSD.

Figure 4: Market profile indicator on EURUSD.

Why not avoiding recalculating?
Now one might ask. Can we avoid recalculating? Well, yes you can avoid the recalculating simply by not calculating your algorithm over the last candle bar or by not generating the last value of the indicator. This is called a static algorithm because they are not responsive to the latest price value. For example, simply imagine that if the indicator calculates your moving average values except the first candle bar, then you will get the static moving average indicator. Such a moving average indicator will not have any responsiveness to the new price arrivals. It is static. You can achieve the same by just using open price of the candle bar. Likewise, if you calculate the fractals from the second candle bar, then you will get the static fractal indicator too. For the fractal indicator, you cannot use open price because you need either high or low price of the candle bar. For some technical analysis algorithm, just ignoring the latest candle bar is not sufficient to turn the indicator to static. Some indicators like zig zag or market profile requires certain length of data to calculate one indicator value. In that case, you can simply skip to generate latest value and generate from the second values. For example, if you skip today’s market profile and generate the market profile from yesterday, then you will have the static market profile too. Likewise, you can generate your zigzag from second value too skipping to generate the first zigzag value. If your indicator or pattern detection scanner is using the zigzag indicator, you can also turn them into static one by using the zigzag values from second one (i.e. using the static zig zag).
With the static algorithm or static indicator, you can avoid recalculating. Well sounds easy and wonderful. However, you will experience a serious problem soon. The problem is that you are the only one looking at the lagging information whereas all the other traders are working with the decent latest information for more profits. For example, if you are looking at yesterday’s market profile alone, then you will not able to find what is happening today. All disciplined trader will work with yesterday’s market profile as well as today’s market profile. Likewise, if you detect harmonic patterns with the statics zigzag indicator, then you can only detect the patterns after many candle bars. In Figure 5, you can tell that you do not have any advantage of using the static zigzag indicator to detect harmonic patterns. Especially using the static zigzag indicator, your Reward/Risk ratio will be very poor. You can only detect the harmonic pattern after the price has moved too much in the direction using the static zigzag indicator. Recalculating zigzag indicator will report the appearance of harmonic pattern way faster than the static zigzag indicator. With recalculating zigzag indicator, you have a much better opportunity to enter the market while the sufficient profit is left for you. So do you still prefer the static indicator? Well the choice is entirely up to you.

Figure 5: Harmonic Pattern Detection timing using recalculating zigzag indicator and static zigzag indicator.

Figure 6: Harmonic Pattern Plus (Harmonic Pattern Scenario Planner) locking feature.

Figure 7: Price Breakout Pattern Scanner locking feature.
Link to Harmonic Pattern Plus (Harmonic Pattern Scenario Planner) and Price Breakout Pattern Scanners.

## Technical Indicator Library Excel Formula

Below is the Text Only Excerpt automatically extracted From the Full PDF Article for Non PDF Viewer:

Technical Indicator Library Excel formula

Below we list Excel formula to call technical indicator library from your Excel. All these technical indicator functions are located inside TechnicalAnlaysis.xll file. TechnicalAnalysis.xll files are free to use and free to share without any limitation. We have put some friendly Copy Right Notice on the bottom of this document to protect the developers and contributor. In general, this TechnicalAnalysis.xll file and Technical Indicator library inside the file can be used by anyone and it is free of charge. To use these functions from your Excel, you should load the TechnicalAnlaysis.xll add-in to your Excel first. For the paid users for Quant Strategy Inventor, the installation can be done automatically when you first load our Quant Strategy Inventor. For free users of this TechnicalAnlaysis.xll, please follow the simple installation steps below.

1. Install TechnicalAnalysis.xll file
To install TechnicalAnlaysis.xll file, go to Options in your Excel. Then select Add-ins.

When the Add-Ins manager pop up, click on Browse button and select the TechnicalAnalysis.xll file from your hard drive.

Once TechnicalAnalysis.xll files are loaded in your Excel. You can call any of User Defined Function below to build various trading strategies from your Excel. Above installation step can be skipped for paid users of our Quant Strategy Inventor. Below, we list the all the available Technical and Mathematical Function you can call with TechnicalAnalysis.xll file.
2. Example Usage of Functions

All the functions are array formula. Therefore, you have to enter these formula using “Ctrl +Shift+Enter” keys. You should include “=TA_” syntax before Function name.

For example, for following Bollinger Bands function below:

BBANDS – Bollinger Bands
upperband, middleband, lowerband = BBANDS(close, timeperiod=5, nbdevup=2, nbdevdn=2, matype=0)
You will enter “=TA_BBANDS(I7:I30, 12, 2, 2, 1)” to range L7:N30 assuming your price data are located at the range E6:K30.

We can take another example for CCI function as shown below.
CCI – Commodity Channel Index
real = CCI(high, low, close, timeperiod=14)
Here is how to put this CCI function in your worksheet. “=TA_CCI(G7:G30, H7:H30, I7:I30, 13)” to range L7:L30 assuming your price data are located at the range E6:K30.

3. Overlap Studies Functions

BBANDS – Bollinger Bands
upperband, middleband, lowerband = BBANDS(close, timeperiod=5, nbdevup=2, nbdevdn=2, matype=0)

DEMA – Double Exponential Moving Average
real = DEMA(close, timeperiod=30)

EMA – Exponential Moving Average
real = EMA(close, timeperiod=30)

HT_TRENDLINE – Hilbert Transform – Instantaneous Trendline
real = HT_TRENDLINE(close)

KAMA – Kaufman Adaptive Moving Average
real = KAMA(close, timeperiod=30)

MA – Moving average
real = MA(close, timeperiod=30, matype=0)

MAMA – MESA Adaptive Moving Average
mama, fama = MAMA(close, fastlimit=0, slowlimit=0)

MAVP – Moving average with variable period
real = MAVP(close, periods, minperiod=2, maxperiod=30, matype=0)

MIDPOINT – MidPoint over period
real = MIDPOINT(close, timeperiod=14)

MIDPRICE – Midpoint Price over period
real = MIDPRICE(high, low, timeperiod=14)

SAR – Parabolic SAR
real = SAR(high, low, acceleration=0, maximum=0)

SAREXT – Parabolic SAR – Extended
real = SAREXT(high, low, startvalue=0, offsetonreverse=0, accelerationinitlong=0, accelerationlong=0, accelerationmaxlong=0, accelerationinitshort=0, accelerationshort=0, accelerationmaxshort=0)

SMA – Simple Moving Average
real = SMA(close, timeperiod=30)

T3 – Triple Exponential Moving Average (T3)
real = T3(close, timeperiod=5, vfactor=0)

TEMA – Triple Exponential Moving Average
real = TEMA(close, timeperiod=30)

TRIMA – Triangular Moving Average
real = TRIMA(close, timeperiod=30)

WMA – Weighted Moving Average
real = WMA(close, timeperiod=30)

4. Oscillator Indicators

ADX – Average Directional Movement Index
real = ADX(high, low, close, timeperiod=14)

ADXR – Average Directional Movement Index Rating
real = ADXR(high, low, close, timeperiod=14)

APO – Absolute Price Oscillator
real = APO(close, fastperiod=12, slowperiod=26, matype=0)

AROON – Aroon
aroondown, aroonup = AROON(high, low, timeperiod=14)

AROONOSC – Aroon Oscillator
real = AROONOSC(high, low, timeperiod=14)

BOP – Balance Of Power
real = BOP(open, high, low, close)

CCI – Commodity Channel Index
real = CCI(high, low, close, timeperiod=14)

CMO – Chande Momentum Oscillator
real = CMO(close, timeperiod=14)

DX – Directional Movement Index
real = DX(high, low, close, timeperiod=14)

MACD – Moving Average Convergence/Divergence
macd, macdsignal, macdhist = MACD(close, fastperiod=12, slowperiod=26, signalperiod=9)

MACDEXT – MACD with controllable MA type
macd, macdsignal, macdhist = MACDEXT(close, fastperiod=12, fastmatype=0, slowperiod=26, slowmatype=0, signalperiod=9, signalmatype=0)

MACDFIX – Moving Average Convergence/Divergence Fix 12/26
macd, macdsignal, macdhist = MACDFIX(close, signalperiod=9)

MFI – Money Flow Index
real = MFI(high, low, close, volume, timeperiod=14)

MINUS_DI – Minus Directional Indicator
real = MINUS_DI(high, low, close, timeperiod=14)

MINUS_DM – Minus Directional Movement
real = MINUS_DM(high, low, timeperiod=14)

MOM – Momentum
real = MOM(close, timeperiod=10)

PLUS_DI – Plus Directional Indicator
real = PLUS_DI(high, low, close, timeperiod=14)

PLUS_DM – Plus Directional Movement
real = PLUS_DM(high, low, timeperiod=14)

PPO – Percentage Price Oscillator
real = PPO(close, fastperiod=12, slowperiod=26, matype=0)

ROC – Rate of change : ((price/prevPrice)-1)*100
real = ROC(close, timeperiod=10)

ROCP – Rate of change Percentage: (price-prevPrice)/prevPrice
real = ROCP(close, timeperiod=10)

ROCR – Rate of change ratio: (price/prevPrice)
real = ROCR(close, timeperiod=10)

ROCR100 – Rate of change ratio 100 scale: (price/prevPrice)*100
real = ROCR100(close, timeperiod=10)

RSI – Relative Strength Index
real = RSI(close, timeperiod=14)

STOCH – Stochastic
slowk, slowd = STOCH(high, low, close, fastk_period=5, slowk_period=3, slowk_matype=0, slowd_period=3, slowd_matype=0)

STOCHF – Stochastic Fast
fastk, fastd = STOCHF(high, low, close, fastk_period=5, fastd_period=3, fastd_matype=0)

STOCHRSI – Stochastic Relative Strength Index
fastk, fastd = STOCHRSI(close, timeperiod=14, fastk_period=5, fastd_period=3, fastd_matype=0)

TRIX – 1-day Rate-Of-Change (ROC) of a Triple Smooth EMA
real = TRIX(close, timeperiod=30)

ULTOSC – Ultimate Oscillator
real = ULTOSC(high, low, close, timeperiod1=7, timeperiod2=14, timeperiod3=28)

WILLR – Williams’ %R
real = WILLR(high, low, close, timeperiod=14)

5. Volume Indicators

real = AD(high, low, close, volume)

real = ADOSC(high, low, close, volume, fastperiod=3, slowperiod=10)

OBV – On Balance Volume
real = OBV(close, volume)

6. Volatility Indicators

ATR – Average True Range
real = ATR(high, low, close, timeperiod=14)

NATR – Normalized Average True Range
real = NATR(high, low, close, timeperiod=14)

TRANGE – True Range
real = TRANGE(high, low, close)

7. Price Transformation

AVGPRICE – Average Price
real = AVGPRICE(open, high, low, close)

MEDPRICE – Median Price
real = MEDPRICE(high, low)

TYPPRICE – Typical Price
real = TYPPRICE(high, low, close)

WCLPRICE – Weighted Close Price
real = WCLPRICE(high, low, close)

8. Cycle Indicator Functions

HT_DCPERIOD – Hilbert Transform – Dominant Cycle Period
real = HT_DCPERIOD(close)

HT_DCPHASE – Hilbert Transform – Dominant Cycle Phase
real = HT_DCPHASE(close)

HT_PHASOR – Hilbert Transform – Phasor Components

HT_SINE – Hilbert Transform – SineWave

HT_TRENDMODE – Hilbert Transform – Trend vs Cycle Mode
integer = HT_TRENDMODE(close)

9. Pattern Recognition Functions

CDL2CROWS – Two Crows
integer = CDL2CROWS(open, high, low, close)

CDL3BLACKCROWS – Three Black Crows
integer = CDL3BLACKCROWS(open, high, low, close)

CDL3INSIDE – Three Inside Up/Down
integer = CDL3INSIDE(open, high, low, close)

CDL3LINESTRIKE – Three-Line Strike
integer = CDL3LINESTRIKE(open, high, low, close)

CDL3OUTSIDE – Three Outside Up/Down
integer = CDL3OUTSIDE(open, high, low, close)

CDL3STARSINSOUTH – Three Stars In The South
integer = CDL3STARSINSOUTH(open, high, low, close)

CDL3WHITESOLDIERS – Three Advancing White Soldiers
integer = CDL3WHITESOLDIERS(open, high, low, close)

CDLABANDONEDBABY – Abandoned Baby
integer = CDLABANDONEDBABY(open, high, low, close, penetration=0)

integer = CDLADVANCEBLOCK(open, high, low, close)

CDLBELTHOLD – Belt-hold
integer = CDLBELTHOLD(open, high, low, close)

CDLBREAKAWAY – Breakaway
integer = CDLBREAKAWAY(open, high, low, close)

CDLCLOSINGMARUBOZU – Closing Marubozu
integer = CDLCLOSINGMARUBOZU(open, high, low, close)

CDLCONCEALBABYSWALL – Concealing Baby Swallow
integer = CDLCONCEALBABYSWALL(open, high, low, close)

CDLCOUNTERATTACK – Counterattack
integer = CDLCOUNTERATTACK(open, high, low, close)

CDLDARKCLOUDCOVER – Dark Cloud Cover
integer = CDLDARKCLOUDCOVER(open, high, low, close, penetration=0)

CDLDOJI – Doji
integer = CDLDOJI(open, high, low, close)

CDLDOJISTAR – Doji Star
integer = CDLDOJISTAR(open, high, low, close)

CDLDRAGONFLYDOJI – Dragonfly Doji
integer = CDLDRAGONFLYDOJI(open, high, low, close)

CDLENGULFING – Engulfing Pattern
integer = CDLENGULFING(open, high, low, close)

CDLEVENINGDOJISTAR – Evening Doji Star
integer = CDLEVENINGDOJISTAR(open, high, low, close, penetration=0)

CDLEVENINGSTAR – Evening Star
integer = CDLEVENINGSTAR(open, high, low, close, penetration=0)

CDLGAPSIDESIDEWHITE – Up/Down-gap side-by-side white lines

integer = CDLGAPSIDESIDEWHITE(open, high, low, close)

CDLGRAVESTONEDOJI – Gravestone Doji
integer = CDLGRAVESTONEDOJI(open, high, low, close)

CDLHAMMER – Hammer
integer = CDLHAMMER(open, high, low, close)

CDLHANGINGMAN – Hanging Man
integer = CDLHANGINGMAN(open, high, low, close)

CDLHARAMI – Harami Pattern
integer = CDLHARAMI(open, high, low, close)

CDLHARAMICROSS – Harami Cross Pattern
integer = CDLHARAMICROSS(open, high, low, close)

CDLHIGHWAVE – High-Wave Candle
integer = CDLHIGHWAVE(open, high, low, close)

CDLHIKKAKE – Hikkake Pattern
integer = CDLHIKKAKE(open, high, low, close)

CDLHIKKAKEMOD – Modified Hikkake Pattern
integer = CDLHIKKAKEMOD(open, high, low, close)

CDLHOMINGPIGEON – Homing Pigeon
integer = CDLHOMINGPIGEON(open, high, low, close)

CDLIDENTICAL3CROWS – Identical Three Crows
integer = CDLIDENTICAL3CROWS(open, high, low, close)

CDLINNECK – In-Neck Pattern
integer = CDLINNECK(open, high, low, close)

CDLINVERTEDHAMMER – Inverted Hammer
integer = CDLINVERTEDHAMMER(open, high, low, close)

CDLKICKING – Kicking
integer = CDLKICKING(open, high, low, close)

CDLKICKINGBYLENGTH – Kicking – bull/bear determined by the longer marubozu
integer = CDLKICKINGBYLENGTH(open, high, low, close)

integer = CDLLADDERBOTTOM(open, high, low, close)

CDLLONGLEGGEDDOJI – Long Legged Doji
integer = CDLLONGLEGGEDDOJI(open, high, low, close)

CDLLONGLINE – Long Line Candle
integer = CDLLONGLINE(open, high, low, close)

CDLMARUBOZU – Marubozu
integer = CDLMARUBOZU(open, high, low, close)

CDLMATCHINGLOW – Matching Low
integer = CDLMATCHINGLOW(open, high, low, close)

CDLMATHOLD – Mat Hold
integer = CDLMATHOLD(open, high, low, close, penetration=0)

CDLMORNINGDOJISTAR – Morning Doji Star
integer = CDLMORNINGDOJISTAR(open, high, low, close, penetration=0)

CDLMORNINGSTAR – Morning Star
integer = CDLMORNINGSTAR(open, high, low, close, penetration=0)

CDLONNECK – On-Neck Pattern
integer = CDLONNECK(open, high, low, close)

CDLPIERCING – Piercing Pattern
integer = CDLPIERCING(open, high, low, close)

CDLRICKSHAWMAN – Rickshaw Man
integer = CDLRICKSHAWMAN(open, high, low, close)

CDLRISEFALL3METHODS – Rising/Falling Three Methods
integer = CDLRISEFALL3METHODS(open, high, low, close)

CDLSEPARATINGLINES – Separating Lines
integer = CDLSEPARATINGLINES(open, high, low, close)

CDLSHOOTINGSTAR – Shooting Star
integer = CDLSHOOTINGSTAR(open, high, low, close)

CDLSHORTLINE – Short Line Candle
integer = CDLSHORTLINE(open, high, low, close)

CDLSPINNINGTOP – Spinning Top
integer = CDLSPINNINGTOP(open, high, low, close)

CDLSTALLEDPATTERN – Stalled Pattern
integer = CDLSTALLEDPATTERN(open, high, low, close)

CDLSTICKSANDWICH – Stick Sandwich
integer = CDLSTICKSANDWICH(open, high, low, close)

CDLTAKURI – Takuri (Dragonfly Doji with very long lower shadow)
integer = CDLTAKURI(open, high, low, close)

CDLTASUKIGAP – Tasuki Gap
integer = CDLTASUKIGAP(open, high, low, close)

CDLTHRUSTING – Thrusting Pattern
integer = CDLTHRUSTING(open, high, low, close)

CDLTRISTAR – Tristar Pattern
integer = CDLTRISTAR(open, high, low, close)

CDLUNIQUE3RIVER – Unique 3 River
integer = CDLUNIQUE3RIVER(open, high, low, close)

CDLUPSIDEGAP2CROWS – Upside Gap Two Crows
integer = CDLUPSIDEGAP2CROWS(open, high, low, close)

CDLXSIDEGAP3METHODS – Upside/Downside Gap Three Methods
integer = CDLXSIDEGAP3METHODS(open, high, low, close)

10. Statistics Functions

BETA – Beta
real = BETA(high, low, timeperiod=5)

CORREL – Pearson’s Correlation Coefficient (r)
real = CORREL(high, low, timeperiod=30)

LINEARREG – Linear Regression
real = LINEARREG(close, timeperiod=14)

LINEARREG_ANGLE – Linear Regression Angle
real = LINEARREG_ANGLE(close, timeperiod=14)

LINEARREG_INTERCEPT – Linear Regression Intercept
real = LINEARREG_INTERCEPT(close, timeperiod=14)

LINEARREG_SLOPE – Linear Regression Slope
real = LINEARREG_SLOPE(close, timeperiod=14)

STDDEV – Standard Deviation
real = STDDEV(close, timeperiod=5, nbdev=1)

TSF – Time Series Forecast
real = TSF(close, timeperiod=14)

VAR – Variance
real = VAR(close, timeperiod=5, nbdev=1)

11. Math Transform Functions

ACOS – Vector Trigonometric ACos
real = ACOS(close)

ASIN – Vector Trigonometric ASin
real = ASIN(close)

ATAN – Vector Trigonometric ATan
real = ATAN(close)

CEIL – Vector Ceil
real = CEIL(close)

COS – Vector Trigonometric Cos
real = COS(close)

COSH – Vector Trigonometric Cosh
real = COSH(close)

EXP – Vector Arithmetic Exp
real = EXP(close)

FLOOR – Vector Floor
real = FLOOR(close)

LN – Vector Log Natural
real = LN(close)

LOG10 – Vector Log10
real = LOG10(close)

SIN – Vector Trigonometric Sin
real = SIN(close)

SINH – Vector Trigonometric Sinh
real = SINH(close)

SQRT – Vector Square Root
real = SQRT(close)

TAN – Vector Trigonometric Tan
real = TAN(close)

TANH – Vector Trigonometric Tanh
real = TANH(close)

12. Math Operator Functions

DIV – Vector Arithmetic Div
real = DIV(high, low)

MAX – Highest value over a specified period
real = MAX(close, timeperiod=30)

MAXINDEX – Index of highest value over a specified period
integer = MAXINDEX(close, timeperiod=30)

MIN – Lowest value over a specified period
real = MIN(close, timeperiod=30)

MININDEX – Index of lowest value over a specified period
integer = MININDEX(close, timeperiod=30)

MINMAX – Lowest and highest values over a specified period
min, max = MINMAX(close, timeperiod=30)

MINMAXINDEX – Indexes of lowest and highest values over a specified period
minidx, maxidx = MINMAXINDEX(close, timeperiod=30)

MULT – Vector Arithmetic Mult
real = MULT(high, low)

SUB – Vector Arithmetic Substraction
real = SUB(high, low)

SUM – Summation
real = SUM(close, timeperiod=30)

TechnicalAnlaysis.xll file is free to use for everyone and redistributable without any limitation. To protect the developers and contributors, the following copyright notice should be included when this file is redistributed or when the file is used.
THIS SOFTWARE IS PROVIDED “AS IS” AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE DEVELOPERS AND CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

Instruction (Manual) Document

This part should be filled by author before your submission.

Your ID on our website ATI

2. Information for the submitted materials
Title of the submitted instruction or manual Technical Indicator Library Excel Formula
Language of Instruction English
Key words (at least 3) Forex, Stock, Investment, Trading, optimization, simulation, backtesting, technical analysis, economic analysis, Quantitative Trading
Date of Completion 21 October 2016
Version of this Document 1.0

3. If it is about any trading platform or any of our products (leave empty if you don’t use)
Name of Trading Platform Quant Strategy Inventor
Name of Product Quant Strategy Inventor
Product version 5.16R

## Basic Math and Statistics for Finance and Investment

Below is the Text Only Excerpt automatically extracted From the Full PDF Article for Non PDF Viewer:

Basic Math and Statistics for Finance and Investment

Following equations are partially applicable for the benefit of your Trading and Investment but not compulsory. Normally these equations are quite basic for solving many finance and investment problems in real world sense. “Introductory Statistics” and “Time value of Money” parts should be understood by all traders and investors before they trade on real live trading. It is our recommendation even though many traders skip these parts.

1. Introductory Statistics

N = number of observation

Mean,

Population variance,

Population standard deviation,

Population Covariance =

Sample variance,

Sample standard deviation,

Sample covariance =

Correlation Coefficient, r =   using sample covariance.

2. Time Value of Money

Rate of return (ROR)

Rate of return,
Where

C1 = realization of investment at the end of the year
C0 = investment at the beginning of the year

Future value of a single sum

Future value,

Where

PV = principal or present value of a single sum
r = interest rate
n = number of compounding periods

Present value of a single sum

Present value,

Where

FV = future value or cash flow at the end of period n
r = discount rate
n = number of compounding periods

Future value of a series of cash flows

Future value,

Where

Ct = Cash flow at the end of period n
r   = interest rate
n  = number of compounding periods

Present value of a series of cash flows
Present value,

Where

Ct = Cash flow the end of period n
r   = interest rate
n  = number of compounding periods

Net present value

Net present value,   if the capital outlay occurs only at the beginning of the project

Net present value,   if the capital outlay occurs in different years of the project

Where

CO = the capital outlays at the beginning of the project
COt = the capital outlays at end of period n
Ct = Cash flow the end of period n
r   = interest rate
n  = number of compounding periods

Present value of a perpetuity

Present value of a perpetuity,

Where

P   = the cash flow received/paid under annuity (i.e. periodic payment)
r    = the compound interest rate per period

Internal rate of return (IRR)

The internal rate of return is the discount rate that makes net present value equal to zero.

Where

Cn = Cash flow the end of period n
IRR = internal rate of return
n = period

3. Compounding Interest basics

Amount in compound interest
Amount,   or
Where
i = r/k = interest rate per period
n = kt = total number of conversion periods

Where
r = nominal interest rate per year
k = number of conversion periods per year
t = number of years (or term)

Present value in compound interest

Amount in continuous interest

Amount,

Where
e = natural base = 2.718281828

Present value in continuous interest

Present value,

4. Effective Interest Rate

Annual percentage rate (= nominal annual interest rate)

Annual percentage rate,

Where
i = rate per compounding period
n = number of compound periods in a year

Effective annual interest rate in compound interest transaction

Effective annual interest rate,

Where

r = nominal (= simple) interest rate per year (= APR)
k = number of conversions per year

Effective annual interest rate in continuous interest transaction

Effective annual interest,

Where

r = nominal (=simple) interest rate per year (=APR)

5. Annuity Equations

Future value of an ordinary annuity

Future value of an ordinary annuity,
Where

P   = the cash flow received/paid under the annuity (i.e. periodic payment)
n    = the number of cash flows that form the annuity
r    = the compound interest rate per period

Present value of an ordinary annuity

Present value of an ordinary annuity,

Where

P   = the cash flow received/paid under annuity (i.e. periodic payment)
n    = the number of cash flows that form the annuity
r    = the compound interest rate per period

Periodic payment into a sinking fund (=future value)

Periodic payment,

Where

FV = the future value to meet
n    = the number of cash flows that form the annuity
r    = the compound interest rate per period

Future value of an annuity due

Future value of an annuity due,

Where
P   = the cash flow received/paid under the annuity
n    = the number of cash flows that form the annuity
r    = the compound interest rate per period

Present value of an annuity due

Present value of an annuity due,
Where

P   = the cash flow received/paid under annuity (i.e. periodic payment)
n    = the number of cash flows that form the annuity
r    = the compound interest rate per period

Present value of a deferred annuity

Present value of a deferred annuity,

P   = the cash flow received/paid under annuity (i.e. periodic payment)
n    = the number of cash flows that form the annuity
r    = the compound interest rate per period
x   = the number of period before the first cash flow

Present value of a perpetuity

Present value of a perpetuity,

Where

P   = the cash flow received/paid under annuity (i.e. periodic payment)
r    = the compound interest rate per period

Instruction (Manual) Document

This part should be filled by author before your submission.

Your ID on our website ATI

2. Information for the submitted materials
Title of the submitted instruction or manual Basic Math and Statistics for Finance and Investment
Language of Instruction English
Key words (at least 3) Finance, Forex, Stock, Investment, Trading, Future
Date of Completion July 2016
Version of this Document 1.0

3. If it is about any trading platform or any of our products (leave empty if you don’t use)
Name of Trading Platform MS-Excel, SAS, SPSS
Name of Product
Product version

## ATI Registration Request Form for Training

Below is the Text Only Excerpt automatically extracted From the Full PDF Article for Non PDF Viewer:

• Install Mobile version of Meta Trader terminal to your Smart Phone
• From your mobile version of Meta Trader terminal, go to “Settings” >> Message >> obtain “Meta Quotes ID”. It is mixed letters and numbers like 9443BFF. Write down this ID to somewhere in your note for later use.

• Ok. Everything is done. If you are successful, then you will receive some notification with your Smart Phone when your EA send alerts using push notifications. Most of our products have the built in feature of Push Notifications.
Instruction (Manual) Document

This part should be filled by author before your submission.

Your ID on our website ATI

2. Information for the submitted materials
Title of the submitted instruction or manual Setting up Push Notification with Smart Phone from your MetaTrader
Language of Instruction English
Key words (at least 3) Forex, Investment, MetaTrader,
Date of Completion 11 May 2015
Version of this Document 1.0

3. If it is about any trading platform or any of our products (leave empty if you don’t use)