# Show profit/loss as a percentage.

Show profit/loss as a percentage.

J2 shows profit or loss and is a calculated field
K2 should show the profit or loss as a percentage.
Assistance is greatly appreciated.

###### Who is Participating?

Commented:
is that what you are asking for the percentage?

With cell in % format
``````=(H2-G2)/G2
``````

or a little complicated but without the cell in % format
``````=(H2-G2)/ABS(G2)*100
``````
0

Commented:
Maybe I've misunderstood your question or spreadsheet logic...

J2
=(H2-G2)*100
actually shows the profit or loss for 100 units?

unit profit would be
=H2-G2

percentage profit would be
=(H2-G2)/G2

Actual profit would depend on the number of units traded.
0

Author Commented:
From what I can tell, the correct answer was =(H2-G2), represented as a percentage format.

The number of units is irrelavent since an option contract always controls 100 shares of stock.  You could buy more than one contract, but that also is irrelavent regarding the percentage.

Thanks for all the help.

Continue to watch me trade.  This is exciting.  Thanks for the help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.