|I'm sorry for the confusion. |
I am tracking the gain/loss on Buying and Short Selling Currency Pairs.
When a pair is 'bought' (Buy), the math is pretty simple, Exit Price - Entry Price = P/L. But with a Short Sell (listed on spread sheet as "Sell"), it needs to reflect Entry Price - Exit Price = P/L.
Column E holds the Entry Price, Column F holds the Exit Price, and Column P holds the word "Buy" or "Sell" depending on the type.
The calculation for P/L is in Column G. I add either *100 (JPY base pair) or *10000 (non-JPY base pair) to have the result display in a whole number.
I thought I would need to include whether the Entry Price was > or < the Exit Price, but maybe that isn't necessary.
The 4 possible scenarios I need to account for in a single repeatable formula are:
"Buy" (win) Entry<Exit.....Exit-Entry= Result positive
"Buy" (loss) Entry>Exit.....Exit-Entry= Result negative
"Sell" (win) Entry>Exit.....Entry-Exit= Result positive
"Sell" (loss) Entry<Exit.....Entry-Exit= Result negative
Do you see a pattern that simplifies the formula and will work?
Thanks so much for your time and patience -