Support Board
Date/Time: Thu, 02 Jan 2025 16:41:11 +0000
Post From: Crossover Exit not registering on spreadsheet nor chart
| [2024-10-28 19:32:56] |
| User522425 - Posts: 15 |
|
Hello! I put the formulas in columns "U" and "V" on the spreadsheet. At 1:05 PM Eastern Standard Time, on the 5-minute candle chart, there is a sell entry at 1:00 PM Eastern Standard Time that should have resulted in a sell exit at 1:05 PM Eastern Standard Time when the high of the candle at 1:05 Eastern Standard Time registered above the 8 period moving average from cell column AC. In column V, where the formula "=C3>AC3" resides, there is a "1" clearly displayed. However, on the sell exit column "N" there is not a 1 displayed. I am typing this now, at 3:30 PM Eastern Standard Time, looking at the chart, and the entries I'm talking about appear in rows 33 and 32 respectively for 1:00 PM and 1:05 PM. I also set the condition "C3>AC3" in the sell exit formula as "V3=1" instead, and it still doesn't show a "1" in column N for that cell where in column V it does show. This doesn't always happen this way. But, this is the first instance that I've seen that it has happened. At other times, when V column says "1", so does column N say 1 as well. Everything else is the same. ^^ to clarify what I just wrote, this is on the security named "6EZ24". Date Time Of Last Edit: 2024-10-29 16:43:08
|