# Support Board

Date/Time: Sat, 22 Feb 2020 05:55:31 +0000

## [Programming Help] - Automated Trading

 [2019-09-06 22:57:07] #1 Bubba - Posts: 16 | Ending Date: 2019-08-29 [Expired] Hello and Thank You for any light you can shine on this. I trying to use these codes in my auto trading system, for some reason that I hope you can help with K3 & M3 most of the time don’t work, hit and miss spreadsheet show give off the arrows up or down, MA 34 crosses the MA 55 which is what my ID3.SG1 & ID4.SG1 are indicating doesn’t function most of the time. The column M3 seems to work the most rarely will K3 work. Q3 I’m guessing but I think the comparison of P3 which I don’t ever see numbers in isn’t the correct sell, if not then for some other reason numbers aren’t showing, from what I can tell it’s looking for a 1. If so then Q3 will never work because the comparison of price to a single digit would never turn it on. Of course it is also very likely I am completely work. Any help would be greatly appreciated Thanks Mark Column K3 = CROSSFROMBELOW(ID3.SG1@3:ID3.SG1@4,ID4.SG1@3:ID4.SG1@4) Column M3 = CROSSFROMABOVE(ID3.SG1@3:ID3.SG1@4,ID4.SG1@3:ID4.SG1@4) Column Q3 =AND(P3,E4>ID3.SG1@4,E3
 [2019-09-06 23:57:14] #2 tomgilb - Posts: 2378 | Ending Date: 2020-02-29 Some questions: 1. What Bar Period are the chart bars? 2. Is 'Signal Only On Bar Close' set to Yes or No? 3. What is the formula in P3? 4. Q3 and P3 are not referenced in K3/M3, so what are you expecting P3/Q3 to do?
 [2019-09-07 00:31:47] #3 Bubba - Posts: 16 | Ending Date: 2019-08-29 [Expired] Hello 1 Bar Period is Flex Renko bar size trend off rev off. 2 Its set at 0, No. 3 After the cross of the 34 and 55 with a gap between them, then the code in Q3 would open a trade when price retraces and touches the 34. 4 Yes and because it is checking the the comparison thought it would work. So it should be checking the open price and the closes price, would that be correct. Mark Date Time Of Last Edit: 2019-09-07 00:42:58
 [2019-09-07 01:10:37] #4 tomgilb - Posts: 2378 | Ending Date: 2020-02-29 User334484 asked the same question. Was that you?: https://www.sierrachart.com/SupportBoard.php?ThreadID=45204 I edited that post with an updated Q3 formula, and added a K3 formula. Go there to see an example. -The crossover with a 2 tick offset is in the P3 formula, made persistent. -The pullback to the 34EMA is in the Q3 formula, made persistent. -The K3 formula looks for the transition in Q3, which is the first pullback since the 34/55 cross.
 [2019-09-11 20:27:06] #5 Bubba - Posts: 16 | Ending Date: 2019-08-29 [Expired] Hello again I've been trying everything I can think of and can't get this to work.Everything seems to be working according to the spreadsheet once code is entered there are zeros in the column, which change to 1's like it should (or how I think it should), but no trades being made Also I have a few question if you don't mind. On the cross if I use a displacement value on one of the ID#, does that make a difference. Using the displacement, it does make for the higher MA to cross before the a lower one.