Short Term Trading Week Starting: 14 Jan, page-45

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.