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
excel conversion of prro options
-
- There are more pages in this discussion • 4 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
Add IMM (ASX) to my watchlist
 (20min delay)
|
|||||
|
Last
42.0¢ |
Change
0.025(6.33%) |
Mkt cap ! $598.3M | |||
| Open | High | Low | Value | Volume |
| 39.5¢ | 42.0¢ | 39.5¢ | $890.1K | 2.163M |
Buyers (Bids)
| No. | Vol. | Price($) |
|---|---|---|
| 3 | 127863 | 41.5¢ |
Sellers (Offers)
| Price($) | Vol. | No. |
|---|---|---|
| 42.5¢ | 30850 | 2 |
View Market Depth
| Last trade - 16.10pm 21/06/2024 (20 minute delay) ? |
| IMM (ASX) Chart |