Login Page - Create Account

Support Board


Date/Time: Sat, 12 Jul 2025 01:38:38 +0000



Post From: Market vs Limit orders in a spreadsheet for trading

[2024-02-07 01:49:33]
User48838 - Posts: 124
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