Support Board
Date/Time: Sat, 08 Feb 2025 02:44:05 +0000
Post From: Spreadsheet System - Capture a value for later use?
| [2020-06-20 22:03:14] |
| Sawtooth - Posts: 4173 |
|
1. If you want to wait intrabar for the TMS to move the stop, the only way I can think of is to do it by referencing a formula on the spreadsheet. 2. You could compare J41 with J93 or J95. You'll also need to reference J4 in your J27 formula. Here's an example for minutes across bars instead of seconds intrabar: Spreadsheet Example Formulas and Usage: Cancel Unfilled Working Order n Minutes After Entry Note: Using intrabar entries instead of close of bar entries will always create difficulties and complexities. For example: - Arrows only show what occurred at close of bar. - Signals that occur intrabar will not be marked by an arrow. - Troubleshooting unexpected occurrences is much more difficult. - Intrabar signals are always the first occurrence; you can't exclude the first occurrence and use a subsequent occurrence instead. - Intrabar values cannot be made persistent unless they endure until close of bar. - Intrabar entries usually require the use of J column values that are not persistent, not even intrabar in some cases. IMO, there are plenty of disadvantages and usually no advantage to using an intrabar entry. You can often just use close-of-bar entries on a shorter timeframe chart instead. |