XAO 0.01% 8,699.1 all ordinaries

Hi @ColonialCousin that formula worked beautiful for the first...

  1. 3,034 Posts.
    lightbulb Created with Sketch. 25
    https://hotcopper.com.au/data/attachments/1407/1407978-cd650a76779e0f4f178eb669b192be14.jpg
    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
 
watchlist Created with Sketch. Add XAO (ASX) to my watchlist
(20min delay)
Last
8,699.1
Change
-0.900(0.01%)
Mkt cap ! n/a
Open High Low
8,700.0 8,700.0 8,649.0
XAO (ASX) Chart
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.