Login Page - Create Account

Support Board


Date/Time: Mon, 16 Sep 2024 19:05:23 +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.