Support Board
Date/Time: Wed, 27 Nov 2024 06:38:56 +0000
Post From: Exploring the Reverse Function In Spreadsheet Trading
| [2014-08-05 13:55:49] |
| Sawtooth - Posts: 4120 |
|
OK. Please see attached - I copied the formula from your posting. You can see the repeated "true" conditions that show multiple entries each time a bar is created. This is only a 10 second chart (I set it this way for effect).
You get arrows on every bar when you are in a trade because the second half of the formula is active, the first is not. When flat, only the first half of the formula is active.It should be noted that when I flatten manually, and then reload and recalculate, everything looks as it should - the repeated historical fills go away, and the system waits for the next trade. As soon as I get into a trade, the signals start coming through each bar. Let me know what I might have out of order. Thanks again It should be noted that historical arrows, when flat, are based on the Close only. What happened intrabar is not revealed by the arrows. If you want to show the first-half-of-the-formula historical arrows when the second-half-of-the-formula is active, you'll need to use two other formula columns for the arrows, and set the Draw Style of the K(SG1) and M(SG3) to Hidden: O3 for up arrows: =IF(CROSSFROMBELOW(E3:E4,AA3:AA4),D3,0) P3 for down arrows: =IF(CROSSFROMABOVE(E3:E4,AA3:AA4),C3,0) Set the Draw Styles of O(SG5) and P(SG6) to Arrow Up and Arrow Down, respectively. Date Time Of Last Edit: 2014-08-05 14:09:12
|