Support Board
Date/Time: Fri, 29 Nov 2024 18:39:28 +0000
Post From: Position size/MM using Simple Alerts
| [2023-01-06 21:00:28] |
| Sawtooth - Posts: 4122 |
|
There is a workaround to allow you to use Alert syntax for most of the system: 1. Use the Color Bar Based On Alert Condition study instead of the Trading System Based On Alert Condition study. 2. Add the Spreadsheet System for Trading study. (This study can see the TRUE signals of the color bar study.) (Trades will initiate using this study.) - Trade times are in cells J85-J87. - If you are using Teton Order Routing, acct balance is in cell J47. - If you are not using Teton, use any cell in column H to manually enter the day's initial balance. - Order Quantity is in cell J26. Use a formula referencing the column H cell, or J47, to find the difference from J45, to return the order quantity. - Use cell K3 for the buy entry formula, like this: =ID1.SG1@3>0 where ID1 is the buy entry color bar study. - Use cell M3 for the sell entry formula, like this: =ID2.SG1@3>0 where ID2 is the sell entry color bar study. Note: Since you are proficient at Alert syntax, the spreadsheet study should not intimidate you. It's just a matter of using a similar but different syntax, and understanding a few basic things about the Spreadsheet System for Trading study format: - Spreadsheet row 3 is the current bar, and earlier bars are in rows below. All formulas from columns K-Z are entered in row 3. - Columns AA and above are the outputs of added studies. - Columns K,L,M,N are the Buy Entry, Buy Exit, Sell Entry, Sell Exit columns, respectively. - Columns O-Z are for intermediate formulas, as needed. - Alert syntax ID1.SG1[0] is ID1.SG1@3 in spreadsheet syntax. - Alert syntax ID1.SG1[-1] is ID1.SG1@4 in spreadsheet syntax, etc. |