Feeling stupid because I just cannot work it out, and wonder if anyone here can give me a hand?
Hiya Kate
OK, I'll give it a go! ;)
Assuming your spread sheet looks like this
A | B | |
---|---|---|
1 | Sell Lots | Sell Price |
2 | Buy Lots | Buy Price |
So in your example:
A | B | |
---|---|---|
1 | 8 | 12067 |
2 | 5 | 11979 |
Your calculation cell would be:
=B1-((B1-B2)/(A1+A2))*A2
So in your example, the breakeven would be 12033.15
I haven't checked it thoroughly so let me know if that doesn't work and I'll give it another shot :D
Cheers
Stu
So in your example, the breakeven would be 12033.15
Base on my calculations this is what I got 12012
12067-11979= 88
88x5= 440
88x8 = 704
704-440=264
8x33=264
88-33=55
55x8=440
12067 -55 =12012
So there you got the breakeven number
12012
Please be advise you said break even you didn't mention spread on pair
BE = 12213,67
It is wrong. at this price, both buy and sell have profit.
Ahh yes, that's what I get for trying maths problems too late at night :)
My equation is actually still correct, but the sell lots should have been negated (ie -8, not +8). You then get the BE of 12213.67. And as FT said, if lots are equal there is no BE and both his equation and mine will fail with a DIV 0 error. So you would need to also put a check in for that.
So if you have negative sell lots:
=IF(A1+A2=0,"No Breakeven Possible",B1-((B1-B2)/(A1+A2))*A2)Great team work :)
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
You agree to website policy and terms of use
Feeling stupid because I just cannot work it out, and wonder if anyone here can give me a hand?
I want to work out the following for a spreadsheet calculation
If the average of my shorts are 8 lots at 12067 price level
And the average of my longs are 5 lots at 11979 price level
What level is my break even?
*Calculation formula needed, as I have a lovely indicator that gives me this figure in realtime
on my charts, but I want to put the calculation on my spreadsheet for a projectory basis.
Just can't work it out, so any help very much appreciated.
Regards
Kate