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?
Related:
Find what is the number, that will make 2 cells ABS equal
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?
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.
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.
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.
- Posts
-
17787
- Registration date
- Sunday June 8, 2008
- Status
- Contributor
- Last seen
- December 8, 2021
5It is easy to share an excel file : you simply publish it, and you share the link on this forum.