@Zestfulmocha
I have not thoroughly read all the above, but I have read stuff from bellnuit before and it is pretty helpful, ........anyway
the anz stuff you talk about tends to be, in general terms, first in first out type recording ......so can be of limited value (depending on your record keeping) ...so may not be such a great loss not to have it.
Off topic for trader ....
On the Investor topic of your last paragraph (so off topic as 50% discount is NOT trader related) ....... your investor formula must also be able to deal with losses before the application of the 50% ...your formula does not appear to do that ....so may give an incorrect taxable profit/loss position for investors (unless this calculation is carried out elsewhere in your spreadsheet and what you typed was just a quick sample extract).
