Support Board
Date/Time: Wed, 15 Jan 2025 16:26:45 +0000
Post From: Simple auto trading buy/sell crossover SMA
| [2017-08-08 14:46:15] |
| Turbo-Jammer - Posts: 14 |
|
Hi, Am trying to test a simple auto trading method using 2 simple moving averages using the spreadsheet. I want to buy when it crosses the above lower SMA and exit when it crosses below the higher SMA during uptrends and opposite in downtrends. I have following formulas in the respective cells for uptrend: Buy Entry K3: =CROSSFROMBELOW( ID0.SG4@3:ID0.SG4@4, ID2.SG1@3:ID2.SG1@4) Buy Exit L3: =CROSSFROMABOVE( ID0.SG4@3:ID0.SG4@4, ID3.SG1@3:ID3.SG1@4) Based on the above when a buy order is triggered a corresponding buy exit is suppose to close out the long position only. But am not seeing a one to one relationship on the attached chart. I only want 1 trade to trigger at a time, once a buy entry is triggered no new buy until the open trade is closed by the buy exit. As you can see from on the attached chart that's not happening, what am I doing wrong? |
 EUR-201709-GLOBEX [CV] 240 Min #1 2017-08-08 10_42_09.73.png / V - Attached On 2017-08-08 14:44:02 UTC - Size: 55.31 KB - 676 views ScreenShot292 _2017-08-08-10-06.png / V - Attached On 2017-08-08 14:44:28 UTC - Size: 27.92 KB - 428 views |