Login Page - Create Account

Support Board


Date/Time: Sat, 20 Apr 2024 15:57:47 +0000



[Programming Help] - Spreadsheet question

View Count: 567

[2019-08-25 22:47:10]
User183724 - Posts: 183
I'm working with my first spreadsheet and I'm following along the following instruction page:

Spreadsheet Systems, Alerts and Automated Trading


Steps To Create a Trading System for Automated Trading

I'm using one sheet - I have the following checked

Auto trading enabled - Global

Auto trading enabled - Chart



Buy Entry in K3 =

=AND($J$8=0,AY3>0) J8 = 0 = no current order AY3 = 1 = buy condition valid

Buy Exit

=AND($J$8<>0,AY3=0) J8 <> 0 = have current order AY3 = 0 = buy condition not valid



Sell Entry

=AND($J$8=0, AW3>0) J8 0 = no current order AW3 = 1 = sell condition valid

Sell Exit (Buy)

=AND($J$8<>0,AW3=0) J8 <> 0 = have current order AW3=0 = sell condition not valid


the sheet is making trades correctly as best I can tell. when a valid condition exists, it trades using the Chart Mode IE...just like if I had taken a trade on the chart manually. the problem I'm having is it wont cancel a trade based on the Buy Exit or Sell Exit conditions. Don't know what to do?? Any assistance appreciated.
[2019-08-26 01:18:25]
User183724 - Posts: 183
update...figured it out...thanxs anyway

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account