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

First 55 Last

Share
Profile

Follow
Trees

33,305 Posts.

13

15/01/19

12:14

Post #: 37118079
Share

Originally posted by ColonialCousin ↑

https://hotcopper.com.au/posts/37116798">Originally posted by rick64
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

Expand

nice

better to reference a cell than hard code the numbers as brokerage (cost) or change in brokerage levels (thus cost) may change

XAO Value at posting: 5,852.2
2 Upvote

0 Great analysis

Reply

Top Stories

History-making uranium sample grades and an imminent drill run. Infini Resources is poised to transform in 2025

ACW

This biotech stock raised $11M in a risk-off environment. Its Alzheimer's drug could change the game

WC8

Pan Asia rebranding to 'clear confusion' after bagging $35M for Chile projects

CXM

'Taking money from the market': Garbage giant cleans up as this week's Hot Stock tip

MIN

MinRes's Ellison knows he screwed up – for that reason, hunt for new Chair to be sped up

There are more pages in this discussion • 114 more messages in this thread...

First 55 Last

Add XAO (ASX) to my watchlist

(20min delay)
Last 8,612.6		Change -48.600(0.56%)		Mkt cap ! n/a

Open	High	Low
8,661.2	8,682.0	8,606.8

XAO (ASX) Chart

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

Top Stories

History-making uranium sample grades and an imminent drill run. Infini Resources is poised to transform in 2025

This biotech stock raised $11M in a risk-off environment. Its Alzheimer's drug could change the game

Pan Asia rebranding to 'clear confusion' after bagging $35M for Chile projects

'Taking money from the market': Garbage giant cleans up as this week's Hot Stock tip

MinRes's Ellison knows he screwed up – for that reason, hunt for new Chair to be sped up