Support Board
Date/Time: Sun, 19 Jan 2025 22:01:53 +0000
Post From: If Condition is met, then enter position if other condition is met
| [2018-05-06 04:03:40] |
| User172040 - Posts: 70 |
|
Hey @tomgilb, your input is invaluable - so thank you. I've gone through most of the spreadsheet study documentation now. I guess, I'll still post here regularly :), but I am learning as I am doing the spreadsheets. I think my header is misleading. I'm going to rephrase: Let's say, for test purposes, I have 2 buying conditions BA1 (price under volume value area low) and BA2 (5MA crossing 9MA). IF BA1 = TRUE, then I only want to enter a position if BA2 = TRUE. The problem is, by the time BA2 = TRUE, BA1 might not be TRUE anymore (price was under volume value area low but now with the MA crossover, price is above the volume value area low). But I don't care about that. BA1 WAS true just a few bars ago and now that BA2 is true, I want to enter. I only want to enter on the 1st crossover of MA's after BA1 was true - not subsequent crossovers thereafter. Does that make it a bit more clear? If I use the =AND() function, the formula will look for conditions where BOTH are TRUE at the same time. But as mentioned, that might not be the case by the time BA2 = TRUE. Thanks for your guidance Date Time Of Last Edit: 2018-05-06 04:04:00
|