Disliked{quote} Hey Lookin, If I do that then things start becoming tricky because lot sizes will have to start getting involved which in turn brings in pips and more.... a bit messy. During the weekend I connected the spread sheet to my live results. I use the P/L column from my other sheet that has commission already deducted. We could also assume perhaps that the 2:1 trades already take the comm. into consideration with a little extra profit and a little less loss (it's how I trade anyway heh). Cheers, Matt.Ignored
Your right though, it would require some more coding. I have a "monster excel" that i run all my forecasting/monte carlo through that i've slowly added to over the years. it has all the variation in spreads, variation in entries/exits, variation in slippage. In the end i find formulas are to restrictive. You're probably gonna have get into some VBA coding to get the job done properly. It's rather easy once you get the syntaxes down.