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?
Wilder1626Connect With a Mentor Commented:
is that what you are asking for the percentage?

With cell in % format

Open in new window

or a little complicated but without the cell in % format

Open in new window

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

actually shows the profit or loss for 100 units?

unit profit would be

percentage profit would be

Actual profit would depend on the number of units traded.
frugalmuleAuthor 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.
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.

All Courses

From novice to tech pro — start learning today.