How to calculate the CHANGE value from MT5 toolbox trade/history

[Michael Macasil]

guys I ask you a favor to teach me on how to obtain the value from CHANGE column? jpeg attached for details.

[Werner Arthur Klehr]

Hi and good morning,

the formulars are looking like this:

for a BUY pos.: (ClosePrice / OpenPrice) * 100 - 100

for a SELL pos.: (OpenPice / ClosePrice) * 100 - 100

Example of Line 1 in your change1.jpg:

(1835.37 / 1835.04) * 100 - 100   =   1.0001798 * 100 - 100   =   100.01798 - 100   =   0.01798   ->   rounded = 0.02%

Example of the marked Line in your change1.jpg:

(49942.22 / 49935.29) * 100 - 100   =   1.0001387 * 100 - 100   =   100.01387 - 100   =   0.01387   ->   rounded = 0.01%

I hope, this will help you.

Best regards

[Michael Macasil]

werner.klehr:

Hi and good morning,

the formulars are looking like this:

for a BUY pos.: (ClosePrice / OpenPrice) * 100 - 100

for a SELL pos.: (OpenPice / ClosePrice) * 100 - 100

I hope, this will help you.

Best regards

PRECISELY.

two thumbs up

to you my friend. it helps me quickly. Problem Solve.

[Michael Macasil]

how to calculate the CHANGE PLEASE REFER ATTACHED file (RED COLOR)? please help.