Solved

# Show profit/loss as a percentage.

Posted on 2015-01-24
94 Views
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.

0
Question by:frugalmule

LVL 18

Expert Comment

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

LVL 11

Accepted Solution

Wilder1626 earned 500 total points
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

Author Closing Comment

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

## Featured Post

### Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…