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
Ok...will give it a try using drop-box.The spreadsheet...
Add IMM (ASX) to my watchlist
 (20min delay)
|
|||||
|
Last
29.5¢ |
Change
0.005(1.72%) |
Mkt cap ! $428.5M | |||
| Open | High | Low | Value | Volume |
| 28.5¢ | 30.5¢ | 28.5¢ | $469.8K | 1.579M |
Buyers (Bids)
| No. | Vol. | Price($) |
|---|---|---|
| 9 | 297652 | 29.0¢ |
Sellers (Offers)
| Price($) | Vol. | No. |
|---|---|---|
| 30.0¢ | 7500 | 2 |
View Market Depth
| Last trade - 16.10pm 19/07/2024 (20 minute delay) ? |
| IMM (ASX) Chart |