Support Board
Date/Time: Tue, 04 Nov 2025 15:27:30 +0000
[Programming Help] - Market vs Limit orders in a spreadsheet for trading
View Count: 401
| [2024-02-07 01:49:33] |
| User48838 - Posts: 128 |
|
While trading Live today the spreadsheet sent a market order instead of a limit order. I am using this formula in cell J71 (and J73), =if(aa3=0, "M", "L") AA3 contains [ID2] Trading: Position Quantity (C) I am trying to enter a Market order when I have no position and a Limit order when I am in a position. Is the formula above valid? Anything I might be missing using this formula? TY |
| [2024-02-07 15:32:46] |
| Sawtooth - Posts: 4285 |
|
Your formula is valid but I would use J8 instead: =IF(J8=0, "M", "L") Also, you need a formula in cells J22/J24 to return a price for the Limit order. Date Time Of Last Edit: 2024-02-07 16:20:02
|
To post a message in this thread, you need to log in with your Sierra Chart account: