Support Board
Date/Time: Mon, 03 Feb 2025 19:45:02 +0000
Post From: Spreadsheet
| [2019-06-26 17:54:00] |
| AndreyPoroshin - Posts: 105 |
|
Thank you for support! I will try not to be too intrusive and try to figure it out myself. But with some things I can not figure out, I ask you. 1. There is a formula in the column Z = SLOPE (E3: E15, A3: A15) determining the slope of the price. The question seems to be simple, but I can not find the answer. How can I send information to the K and M columns that the slope has changed and goes up to the K buy entry bell and, accordingly, when the slope changes and goes down to the M sell entry column? The only thing that I could realize is = AND (Z3> Z4> Z5> Z6) for K and = AND (Z3 <Z4 <Z5 <Z6) for M. But I don’t think it should be so. If this is correct, then the question is closed. 2. J28 = AND (J8 = 0, OR (FRACTIME (J41) <TIMEVALUE ("08:29:00"), FRACTIME (J41)> TIMEVALUE ("10:30:00")), OR ($ J $ 11 + $ J $ 10> = 1100)) closing by the condition of time and profit J29 = AND (J8 = 0, OR (FRACTIME (J41) <TIMEVALUE ("08:29:00"), FRACTIME (J41)> TIMEVALUE ("10:30:00")), OR ($ J $ 11 + $ J $ 10> = 1100)) closing by the condition of time and profit The formulas work, but until J8 = -1 +1, the alignment of positions and the disconnection of autotrading does not occur until the position encounters a stop order. Naturally becomes J8 = 0 and the formulas work. I have to make the formula work instantly when one of the conditions is reached and close the trade and positions. What am I doing wrong? |