Support Board
Date/Time: Sat, 12 Jul 2025 07:05:29 +0000
Post From: Steps To Create a Trading System for Automated Trading
| [2021-03-17 15:39:17] |
| User_007 - Posts: 2 |
|
Spreadsheet Systems, Alerts and Automated Trading: Steps To Create a Trading System for Automated Trading I was working through the basics of setting up an ATM. Your (very helpful) guide has at #25: "To Sell when the Last price crosses from above the moving average, type in cell M3 (labeled: Sell Entry): =CROSSFROMABOVE(ID0.SG4@3:ID0.SG4@4, ID2.SG1@3:ID2.SG1@4) Where ID0.SG4@3:ID0.SG4@4 refers to the current and previous last trade prices of the chart bars and ID2.SG1@3:ID2.SG1@4 refers to the current and previous Moving Average - Simple values which are located in column AA. You can also optionally use: =AND(CROSSFROMBELOW( ID0.SG4@3:ID0.SG4@4, ID2.SG1@3:ID2.SG1@4), $J$8=0)" Should the suggested formula be changed from: =AND(CROSSFROMBELOW( ID0.SG4@3:ID0.SG4@4, ID2.SG1@3:ID2.SG1@4), $J$8=0) to: =AND(CROSSFROMABOVE( ID0.SG4@3:ID0.SG4@4, ID2.SG1@3:ID2.SG1@4), $J$8=0) ?? Many thanks. |