Login Page - Create Account

Support Board


Date/Time: Thu, 02 May 2024 00:17:28 +0000



BackTesting Using Spreadsheet System of Trading

View Count: 615

[2017-03-20 13:11:55]
User299392 - Posts: 216
I am trying to use limit buy orders but cannot figure how to get a buy limit order price since the only space to indicate that price is a cell in the J column and essentially, I wish to suggest the system to buy 2 ticks below the current prevailing bid at the time of condition fulfillment in column K3. I am fine with non-fills but in cases with fills; I wish to test my system. Please.

Please help!
[2017-03-20 13:40:09]
Sawtooth - Posts: 3987
Try this in J22:
=J12-J21*2
Also, J71 must be set to 'L'
Date Time Of Last Edit: 2017-03-20 16:57:07
[2017-03-20 17:34:01]
Sierra Chart Engineering - Posts: 104368
You can use a formula in these cells to set the limit order price:
http://www.sierrachart.com/index.php?page=doc/SpreadsheetSystemsAlertsAndAutomatedTrading.php#LimitPrices
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing

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

Login

Login Page - Create Account