Hello everyone.
Apologies for what I am sure is a simple question but I am far from an excel guru.
I am trying to create a formula that will optimise a data set I have to find the optimum place for a stop loss to maximise profit.
Below are two columns showing the price difference between the close and the open of an asset. The second column is how far the position went against me.
Does anyone have any idea what formula I would need to achieve this?
Many Regards
Joe
[TABLE="width: 174"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]C-O Pips[/TD]
[TD]Pip Risk If Long[/TD]
[/TR]
[TR]
[TD="align: right"]88.0[/TD]
[TD="align: right"]10.0[/TD]
[/TR]
[TR]
[TD="align: right"]-4.0[/TD]
[TD="align: right"]21.0[/TD]
[/TR]
[TR]
[TD="align: right"]58.0[/TD]
[TD="align: right"]9.0[/TD]
[/TR]
[TR]
[TD="align: right"]7.0[/TD]
[TD="align: right"]38.0[/TD]
[/TR]
[TR]
[TD="align: right"]214.2[/TD]
[TD="align: right"]13.1[/TD]
[/TR]
[TR]
[TD="align: right"]45.2[/TD]
[TD="align: right"]36.9[/TD]
[/TR]
[TR]
[TD="align: right"]73.3[/TD]
[TD="align: right"]14.7[/TD]
[/TR]
[TR]
[TD="align: right"]11.3[/TD]
[TD="align: right"]72.0[/TD]
[/TR]
[TR]
[TD="align: right"]-49.0[/TD]
[TD="align: right"]73.2[/TD]
[/TR]
[TR]
[TD="align: right"]35.4[/TD]
[TD="align: right"]26.8[/TD]
[/TR]
[TR]
[TD="align: right"]38.5[/TD]
[TD="align: right"]24.9[/TD]
[/TR]
</tbody>[/TABLE]
Apologies for what I am sure is a simple question but I am far from an excel guru.
I am trying to create a formula that will optimise a data set I have to find the optimum place for a stop loss to maximise profit.
Below are two columns showing the price difference between the close and the open of an asset. The second column is how far the position went against me.
Does anyone have any idea what formula I would need to achieve this?
Many Regards
Joe
[TABLE="width: 174"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]C-O Pips[/TD]
[TD]Pip Risk If Long[/TD]
[/TR]
[TR]
[TD="align: right"]88.0[/TD]
[TD="align: right"]10.0[/TD]
[/TR]
[TR]
[TD="align: right"]-4.0[/TD]
[TD="align: right"]21.0[/TD]
[/TR]
[TR]
[TD="align: right"]58.0[/TD]
[TD="align: right"]9.0[/TD]
[/TR]
[TR]
[TD="align: right"]7.0[/TD]
[TD="align: right"]38.0[/TD]
[/TR]
[TR]
[TD="align: right"]214.2[/TD]
[TD="align: right"]13.1[/TD]
[/TR]
[TR]
[TD="align: right"]45.2[/TD]
[TD="align: right"]36.9[/TD]
[/TR]
[TR]
[TD="align: right"]73.3[/TD]
[TD="align: right"]14.7[/TD]
[/TR]
[TR]
[TD="align: right"]11.3[/TD]
[TD="align: right"]72.0[/TD]
[/TR]
[TR]
[TD="align: right"]-49.0[/TD]
[TD="align: right"]73.2[/TD]
[/TR]
[TR]
[TD="align: right"]35.4[/TD]
[TD="align: right"]26.8[/TD]
[/TR]
[TR]
[TD="align: right"]38.5[/TD]
[TD="align: right"]24.9[/TD]
[/TR]
</tbody>[/TABLE]