Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Find what is the number, that will make 2 cells ABS equal [Closed]

Report
Posts
3
Registration date
Saturday December 24, 2016
Status
Member
Last seen
December 25, 2016
 -
Posts
14025
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
January 25, 2021
 -
Hey guys,

I will appreciate your help on this. I'm trading on CFD's and trying to build something that will help me calculate different scenarios.
As you can see on the file attached, I want to build a formula in B/E point cell the price of the asset that will make two trades equal in ABS value.

In this example, I took a first trade on 1.2360. The current price is 1.2670.
pip = the change in the fourth number after the dot. for example movement from 1.2360 to 1.2357 is 3 pips movement.
Pip value on the first trade I took is 16.22$. that means movement of 3 pips is 16.22x3=48.66$.

second trade I took was on 1.2600, current price 1.2670. the trade is in the same direction (GBP/USD low) the pip value is 32.44$. (higher than in the first trade. that means each pip movement in the asset price will be higher on this trade.

for example:
I'm trading LOW on GBP/USD. the price goes against me (High). moves from 1.2670 to 1.2674.
that means it moved 4 pips against me in both trades. On the first trade pip value is 16.22$ and on the second one 32.44$. movement of 4 pips will put me in lost of total: 16.22x4 + 32.44x4 = 194.64$.

Now.. I want to find the Break Even point. When the lost and the profit will create 0$ Net Profit. That meant that I want to find with a formula what is the price when the first trade and the second trade will bring to Break Even.

I will be grateful if someone can help, please.

Questions?

See more

1 reply

Answer 1 / 1
Posts
14025
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
January 25, 2021
 4
Hi.
You did not attach any file, you just attached a picture.
Do you know how to manually compute the Break Even point? Are you asking assistance about computing it, or about writing a formula to achieve that computation?
Do you mean that you want a formula returning the value of "1" causing "2"+"3"=0?
Report
Posts
3
Registration date
Saturday December 24, 2016
Status
Member
Last seen
December 25, 2016
Hi.

Thanks for the reply.

I can't attach an excel sheet.
about Break Even point... I want a formula that will calculate and return me the asset value\price which will balance lose and profit.
I need a formula to put in a cell that will calculate this break even point.


For example: Current price is : 1.2600. We trade GBP/USD low.
if the entrance point of the first was 1.2360, each pip value is 16.22$. I'm in a loss of 3892.80$.
and the entrance of the second is 1.2700, and in this trade only the pip value is 32.44$. I'm in a profit on this trade 3244$.
In total i'm in a loss of 648.8$.

Break even point for this example is 1.25866666666667.

Don't forget that on every move in your trade direction (LOW in this example) there is a change in the loss of the first trade and a change in the profit of the second one.
Report
Posts
14025
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
January 25, 2021
 4
Using your drawing, do you want a formula returning the value of "1" causing "2"+"3"=0?
It is easy to share an excel file : you simply publish it, and you share the link on this forum.
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!