Support Board
Date/Time: Sun, 24 Nov 2024 02:52:39 +0000
Post From: Long Entry and Short Exit | Short Entry and Long Exit
| [2024-06-29 08:33:04] |
| User471063 - Posts: 7 |
|
Hello SC Engineers, Testing NQTV stocks with spreadsheet Trading system. Reversal:yes, Allow Opposite Entry: yes. Is there any way dynamically trigger K to M and M to K ? if I isolated each entry into K, L, M, N then Reversal not working correctly. Validating just Long Entry and Short Exit Signal I can find up arrow for Long and buy triggered correctly but no Arrow for short since it was triggered from Column K buying it again instead of exit. Can you please guide me to accomplish or do you have any test formula that help my testing more efficiently and appreciate your help. Example: Column K: Long Entry and Short Exit Signal =IF(AND(ID0.SG4@3 > ID0.SG1@3, ID0.SG5@3 > AVERAGE(ID0.SG5@4:ID0.SG5@23) * 1.5, ID4.SG1@3 > AVERAGE(ID4.SG1@4:ID4.SG1@23), ID5.SG1@3 > ID6.SG1@3, K@2 = 0, M@2 = 0), 1, IF(AND(M@2 = 1, ID0.SG4@3 <= ID0.SG1@3 * 0.94), 1, 0)) Column M: Short Entry and Long Exit Signal =IF(AND(ID0.SG4@3 < ID0.SG1@3, ID0.SG5@3 > AVERAGE(ID0.SG5@4:ID0.SG5@23) * 1.5, ID4.SG1@3 > AVERAGE(ID4.SG1@4:ID4.SG1@23), ID5.SG1@3 < ID6.SG1@3, K@2 = 0, M@2 = 0), 1, IF(AND(K@2 = 1, ID0.SG4@3 >= ID0.SG1@3 * 1.05), 1, 0)) Ref: ID0 //A DATE TIME ID0.SG1 //B //OPEN ID0.SG2 //C HIGH ID0.SG3 //D LOW ID0.SG4 // LAST ID0.SG5 // VOLUME ID0.SG6 // # OF TRADES K // LONG ENTRY M // SHORT ENTRY STUDY ID: ID1.SG1 // TRADING SYSTEM BUY ENTRY ARROW UP ID1.SG3 // TRADING SYSTEM SELL ENTRY ARROW DOWN ID2.SG1 // ROCP LAST 14 ID4.SG1 // ATR LAST 14 ID5.SG1 // EMA LAST 10 ID6.SG1 // EMA LAST 20 Thanks for help Abdul |
Private File Attachment Deleted. |