Ok...will give it a try using drop-box.
The spreadsheet calculates what your paper profit will be if you sell some of your shares to cover the cost of converting the options.
The bits in yellow are auto calculated.
Data entry required which are the white fields is:
The number of shares you hold.
The average price of your shares.
The PRR SP at which you want to sell your shares to convert the options.
https://www.dropbox.com/s/jpgk6cmeymh3790/PRRO%20Options%20selling%20and%20SP.xls
Add to My Watchlist
What is My Watchlist?
 (20min delay)
|
|||||
|
Last
24.5¢ |
Change
-0.005(2.00%) |
Mkt cap ! $357.7M | |||
| Open | High | Low | Value | Volume |
| 25.0¢ | 25.0¢ | 24.0¢ | $419.2K | 1.737M |
Buyers (Bids)
| No. | Vol. | Price($) |
|---|---|---|
| 9 | 301706 | 24.0¢ |
Sellers (Offers)
| Price($) | Vol. | No. |
|---|---|---|
| 24.5¢ | 28117 | 2 |
View Market Depth
| Last trade - 16.10pm 04/07/2025 (20 minute delay) ? |
| IMM (ASX) Chart |