Support Board
Date/Time: Mon, 24 Feb 2025 18:08:30 +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. |