Hi STT Traders,
Posted this on the Education Thread but that forum does not get much exposure.
Thought I may get some help here.
I basically need to change the brokerage from $10 to $19.95 if trade is worth over $1000, as that is what Commsec charge.
IE I buy 999 shares in ANO for $1.00 total is $999 plus $10 brokerage.
I sell 999 shares in ANO for $1.24 total is $1238.76 less brokerage of $19.95.
I somehow cannot get my sheet to reflect this change in brokerage costs.
This is the current formula for brokerage.
=IF(ISBLANK(E5)=TRUE,0,IF(F5="Open",$E$19,$E$19*2))
Can someone help me out here please?
I hope I have explained myself properly.
https://hotcopper.com.au/attachments/image-png.1415586/?temp_hash=b2264b28fd21b550cd977b187af3c249" target="_blank" rel="noreferrer noopener">
https://hotcopper.com.au/attachments/image-png.1415586/?temp_hash=b2264b28fd21b550cd977b187af3c249" alt="https://hotcopper.com.au/data/attachments/1407/1407840-11158122abf328741cc913b001f560a2.jpg" class="bbCodeImage LbImage">
Try this mate:
=IF(ISBLANK(E5)=TRUE,0,IF(F5="Open",IF(I5<1000,10,19.95),(IF(I5<1000,10,19.95)+IF(G5*L5<1000,10,19.95))))
You can reference to two separate cells for brokerage variation if you want to improve this.
Cheers
CC
(20min delay)
