Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.misc




% 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 A1A2 = Profit/Loss Short Sale A2A1 = 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 (A1A2)/A2 for the Long position and (A2A1)/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
Posted to microsoft.public.excel.misc




% 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 A1A2 = Profit/Loss Short Sale A2A1 = 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 (A1A2)/A2 for the Long position and (A2A1)/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 
Display Modes  


Similar Threads  
Thread  Forum  
Excel profit and loss help  New Users to Excel  
CALCULATE PROFIT/LOSS  Excel Worksheet Functions  
Excel Profit & Loss  Excel Programming  
profit/loss calculator  Excel Programming  
Profit and Loss Formula  Excel Worksheet Functions 