Support Board
Date/Time: Fri, 09 May 2025 23:25:22 +0000
Post From: Spreadsheet - can this be done
| [2015-12-09 23:52:21] |
| Sawtooth - Posts: 4214 |
|
The Trade Management by Study study needs a value, and the current value is in row 3 of a spreadsheet study, so the formula in row 3 needs to return the price where you want the stop moved to. There is no significant difference between moving the stop based on a MA or based on a new high or low, when using the Trade Management by Study study. If your system is flexible enough to use either of these, you might consider using an Attached Orders' trailing stop instead, which would not require any spreadsheet formulas, nor the use of the Trade Management by Study study. Each row in a spreadsheet study is a chart bar, with the most recent bar in row 3, and previous bars in rows below. To reference the current close price in a spreadsheet study use cell E3, so to compare it to the previous close, the formula would look like this: =E3>E4 Here are some basic spreadsheet study tips: http://www.sawtoothtrade.com/tip-1.html http://www.sawtoothtrade.com/tip-2.html |