Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default % 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.




  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default % 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel profit and loss help Austen New Users to Excel 1 September 10th 10 07:32 PM
CALCULATE PROFIT/LOSS Tree Excel Worksheet Functions 6 May 13th 09 01:50 PM
Excel Profit & Loss Laird Excel Programming 2 December 13th 08 07:06 PM
profit/loss calculator franky[_2_] Excel Programming 6 December 17th 07 02:14 PM
Profit and Loss Formula carl Excel Worksheet Functions 1 January 25th 06 09:32 PM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"