Support Board
Date/Time: Mon, 23 Dec 2024 07:02:47 +0000
Post From: User Questions
| [2014-12-29 14:34:53] |
| User53474 - Posts: 19 |
|
I've read that documentation before but I do not see anything that would explain why under certain conditions rows are being skipped. I have created the simplest of examples. I have a flex renko chart for tfz4 (I’m using ATCharts from Infinity Brokers) with 8-7-0 as the bar period. I have 1 study, the swing high and low study with settings “3 2 No”. The results of the Swing High and Low Study are in columns AA and AB. I have 1 simple formula in cell $ad$3 that checks for a swing high: =IF(AND($AA$6>0,$AA$6<>$AA$7),$AA$6,$AD$3). Since the length parameter is set to 2, the swing hi is not confirmed until bar 6 which is why I am checking for a value in cell AA6. If everything works properly, the latest swing high value will be displayed in cell AD3. But at random times a swing high is skipped. If you replay the chart for tfz4 on 12/18/2014 you can see this happen for the swing highs around 10:48:49 11:00:39, and 11:02:16. Even though the swing high arrow displays on the chart and the value is in column AA, cell AD3 will not pickup those 2 swing highs. For some reason the swing high value never was processed when it was in row 6. Obviously this value had to be in row 6 before it could get to row 7 or higher but the calculation in cell AD3 was not done correctly. This happens many times over the course of a week or month. You can easily recreate the two examples above or I can send you any other documentation you might require. |