Support Board
Date/Time: Sat, 18 Jan 2025 19:40:57 +0000
Post From: spreadsheet trading question
| [2018-02-17 00:21:32] |
| Sawtooth - Posts: 4154 |
|
To place Limit entries 5 ticks below/above Close price at the signal of a MA crossover in K3 or M3, try this: 1. Find the MA crossover in K3 and M3, and use it for the entry signals: =CROSSFROMBELOW(ID1.SG1@3:ID1.SG1@4,ID2.SG1@3:ID2.SG1@4) =CROSSFROMABOVE(ID1.SG1@3:ID1.SG1@4,ID2.SG1@3:ID2.SG1@4) where the ID#s of the MAs are ID1 and ID2, and ID1 is the faster MA; edit as needed. 2. Return the Close price of the faster MA at the crossover: -Put this in J22: =IF(K3,ID1.SG1@4-5*J21,0) Put this in J24: =IF(M3,ID1.SG1@4+5*J21,0) -Set J71 and J73 to L |