Support Board

Date/Time: Sun, 05 May 2024 14:51:53 +0000

Post From: Limit v Chase Market Orders using spreadsheet

[2019-06-10 18:11:30] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
In the Spreadsheet System for Trading study, columns K-N are order triggering columns: any non-zero is TRUE, and zero is FALSE. Entry prices are not set in these columns. Non-Market entry order type prices are set in cells J22/J24, and the entry order types are set in J71/J73. To place a Buy Limit order at the high of the previous bar, J71 should contain a text L and J22 should use a formula like this: =C4 To use Limit Chase, enable the Menu/M >> Orders >> Use Limit Chase Orders option on the Trade Window menu. Set the max chase using the Trade Window's Set tab's 'Max Chase for Chase Limit Orders' setting. The documentation says to set 'Use Chase Orders' to Yes in the spreadsheet study settings, and to use J46 to set the maximum chase amount. Spreadsheet Systems, Alerts and Automated Trading: Use Chase Orders However, using these settings does not override the Trade Window settings so they seem to be non-functional. You will also need a way to cancel an unfilled Limit entry, should that occur. Here are two examples of how to do this: Spreadsheet Example Formulas and Usage: Cancel an Unfilled Order After n Bars Date Time Of Last Edit: 2019-06-11 13:47:21