Remember Me?

Posted to microsoft.public.excel.misc
 Jack external usenet poster Posts: 3 % 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.

Posted to microsoft.public.excel.misc
 Jack external usenet poster Posts: 3 % 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

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Austen New Users to Excel 1 September 10th 10 07:32 PM Tree Excel Worksheet Functions 6 May 13th 09 01:50 PM Laird Excel Programming 2 December 13th 08 07:06 PM franky[_2_] Excel Programming 6 December 17th 07 02:14 PM carl Excel Worksheet Functions 1 January 25th 06 09:32 PM

All times are GMT +1. The time now is 12:02 AM. Copyright ©2004-2023 ExcelBanter.