Support Board
Date/Time: Sat, 21 Dec 2024 18:36:11 +0000
[User Discussion] - REQUEST - Spreadsheet for Trading -
View Count: 1191
| [2015-07-14 04:53:06] |
| djcurcio - Posts: 236 |
|
It would be very useful to have the ability to STOP Auto Trading when J11 Cumulative Closed P/L hits a certain number. For example: TradingStop=OR($J$11 >= 1000, $J$11 <= -200) It would also be very useful to have the ability to STOP Auto Trading when on has nn Consecutive loosing trades. Thanks |
| [2015-07-14 22:09:07] |
| Sawtooth - Posts: 4141 |
|
It would be very useful to have the ability to STOP Auto Trading when J11 Cumulative Closed P/L hits a certain number. For example: TradingStop=OR($J$11 >= 1000, $J$11 <= -200)
You can do this with a formula in J28, but you'll probably need to use a variation of this example that allows an exit:http://www.sawtoothtrade.com/example-4.html It would also be very useful to have the ability to STOP Auto Trading when on has nn Consecutive loosing trades.
Here's an example of how to do this:http://www.sawtoothtrade.com/example-1.html |
| [2015-07-14 23:22:23] |
| djcurcio - Posts: 236 |
|
I've been experimenting with this and there is a bit of a problem - J!! Cumulative Closed P/L is inaccurate and is NOT the same as the day's DRAWDOWN. So one can end up with a much larger loss than anticipated as positions are flattened. Sierra please add a DAY's DRAW DOWN field. Thanks |
| [2015-07-14 23:32:05] |
| Sawtooth - Posts: 4141 |
|
J11 is based on the number of days in the Trade Activity Log http://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#CellJ11 Use J45 for the Daily P/L http://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#CellJ45 |
To post a message in this thread, you need to log in with your Sierra Chart account: