ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   % Profit Loss Formula (https://www.excelbanter.com/excel-discussion-misc-queries/453065-%25-profit-loss-formula.html)

Jack

% Profit Loss Formula
 
In my Excel spreadsheet I have these values:

A1= 0.0001473
A2= 0.0001620

I want to find the difference when I have a Long Sale and the Difference
when I have a Short Sale. I then want to calculate the % Profit/Loss for
a Short Sale and a Long Sale.

In a long position If my entry price is A1 and my Exit Price is A2, I am
using these two formulas:I

Long Sale A1-A2 = Profit/Loss
Short Sale A2-A1 = Profit/Loss

If I have a Stop Loss of 10% on my Entry amount I calculate these values
for a Long and Short position:

Long Stop Loss 0.0001620
Short Stop Loss 0.0001326

What is the formula to calculate my profit or loss for a Long and Short
position based on the values in cells A1 and A2?

I'm currently using (A1-A2)/A2 for the Long position

and

(A2-A1)/A1 for the Short position, but if I get stopped out at exactly
my 10% value above, I would expect to have a 10% loss. The formulas
above are not returning a 10% value.

Any help would be appreciated.





Jack

% Profit Loss Formula
 
On 1/16/2017 5:04 PM, Jack wrote:
In my Excel spreadsheet I have these values:

A1= 0.0001473
A2= 0.0001620

I want to find the difference when I have a Long Sale and the Difference
when I have a Short Sale. I then want to calculate the % Profit/Loss for
a Short Sale and a Long Sale.

In a long position If my entry price is A1 and my Exit Price is A2, I am
using these two formulas:I

Long Sale A1-A2 = Profit/Loss
Short Sale A2-A1 = Profit/Loss

If I have a Stop Loss of 10% on my Entry amount I calculate these values
for a Long and Short position:

Long Stop Loss 0.0001620
Short Stop Loss 0.0001326

What is the formula to calculate my profit or loss for a Long and Short
position based on the values in cells A1 and A2?

I'm currently using (A1-A2)/A2 for the Long position

and

(A2-A1)/A1 for the Short position, but if I get stopped out at exactly
my 10% value above, I would expect to have a 10% loss. The formulas
above are not returning a 10% value.

Any help would be appreciated.



In the example above I meant to say:

Short Stop Loss 0.0001620
Long Stop Loss 0.0001326





All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com