Support Board
Date/Time: Sun, 22 Dec 2024 05:42:50 +0000
Post From: Cell J23 when using column L for BuyExit and Stop
| [2015-07-14 06:05:09] |
| CMG - Posts: 179 |
|
Hi There, In a spreadsheet for trading I'm using cell L3 to exit a long position in two scenarios: when a profit target is reached or when losing, a stop price is reached. How do I "share" cell J23 for both scenarios if I want to exit with a limit order when there is a profit and a market order for the stop order. If I enter a formula (Eg: J14+0.25) to establish the limit price in J23 for when there is a profit (conditions met in L3), then this formula is also used when a stop is triggered by the conditions set in L3. I need to use a different formula in J23 for when the position is losing and a stop is triggered by the conditions in L3. I tried combining the two price exit formulas in J23 [ =OR(AND(J10>0,(J14+0.25)),AND(J10<0,J12)) ] and J72 set to L and this formula returns a TRUE or FALSE value and I noticed that the result is the same as leaving J23 blank and therefore "If the Limit or Stop price cell (J23) is set to 0 or is blank, then the Limit or Stop price will be set to the current Bid price." Attached orders are not an option as these require a fixed target and stop value and do not fit my strategy. The question is: How do I "share" cell J23 for both scenarios if I want to exit with a limit order when there is a profit and a market order for the stop order? Thanks |