Excel Forecast Function for FOREX

 

Anyone knows how to convert this excel function into an MT4 indicator

See image

Been using it manually and pretty accurate

 

This is a linear regression.

Linear linear_regression_value_-_tsf.mq4

Nonlinear and adapting version I can recomment you b_regression_analysis.mq4

It's quite similar to Center of Gravity (COG). Beware of useing it only in ranging markets, otherwise you loose, because it's repainting by nature.

 

Just one addition : unless it is used in a form of a linear regression channel, linear regression value is not recalculating (ie: linear regression value is a non-recalculating indicator, since the linear regression value is a sort of end-pointed linear regression)

 
krelian99:
This is a linear regression.

Linear linear_regression_value_-_tsf.mq4

Nonlinear and adapting version I can recomment you b_regression_analysis.mq4

It's quite similar to Center of Gravity (COG). Beware of useing it only in ranging markets, otherwise you loose, because it's repainting by nature.

Its not the same formula. If someone could translate the formula I could code it then

 

Excel is powerful and easily available tool. I had used excel earlier to keep the record and details if transactions. But provided liner formula seems helpful. I will give it a try. Thanks