Quote from RogerWilco:
ar1zona, do you need to identify pairs which converge/diverge within one day? If you're talking about regular Z distances (2.0 to track converging, <1.0 to track diverging) - there won't be much pairs like that for sure.
But if you intend to maximize your profits by checking divergence intraday - then you could put an Excel spreadsheet together which will be doing that.
However, I would advice to use it more for paper testing rather then for backtesting, otherwise it will take ages (i.e. approximately 400 times slower on a 1 min data) to back test a single pair.
hi roger, thank you for your reply
im not trying to max profits by taking/exit positions intraday, im sure the EOD results such as PTF are sufficient for swing trade pairs, and this is what i'd like to do once accumulated some capital first
for now what im trying to do is enter and exit positions within the same trading day (preferably not holding the same position from open to close). I agree its quite different for a 1.0 or 2.0 std dev to diverge and converge within a single day, so i want to backtest for a much much smaller divergence to play with. The question is how much Z to trigger a signal, for each pair.
I also agree about how backtesting those tick data will take ages. (I had actually done backtesting ticks in excel, for another strategy, but man that took too long for just a few stocks). Backtesting on minute data appears to be the only choice left, but im not sure how accurate the results will be, since intraday fluctuations within a minute kinda means a lot.. for intraday traders
I know Don Bright's traders do a lot of intraday pairs and they have a system of their own. But for an individual like me, its probably too much work to build an entire intraday backtesting sheet, it would be great if someone somewhere provide this service for a reasonable fee...