Australia's largest stock trading and investment forum Australia's #1 stock forum

XAO

Click for more information

0.56%

8,612.6 all ordinaries

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

First 56 Last

Share
Profile

Follow
rick64

3,034 Posts.

25

15/01/19

12:22

Post #: 37118214
Share

Originally posted by ColonialCousin: ↑

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

Hi @ColonialCousin that formula worked beautiful for the first trade on ANO, but when I applied it to third trade on EMV it did not work for some reason.Maybe it has something to do with the trade fee set in cell E19
Also would this formula work the same way if my initial purchase was over $1000?See screen shot

Last edited by rick64: 15/01/19

XAO Value at posting: 5,852.3
1 Upvote

0 Great analysis

Reply

Top Stories

MIN

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

ACW

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

CXM

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

WC8

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

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

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

First 56 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