Support Board
Date/Time: Wed, 19 Mar 2025 23:46:49 +0000
Post From: Unable to reference LTP in Spreadsheet alert
| [2022-10-29 16:58:09] |
| Sawtooth - Posts: 4186 |
|
To find a price that is equal to a Close price, use a formula like this in row 3 of any Formula Column: =E3=X If there is one that is equal, it will return a 1. You don't need to use IF when the result is True/False. You do need to use IF when the result is a value. Each row of the spreadsheet is a chart bar. The current bar is in row 3, and previous bars are in rows below. (Except in columns H, I, J.) So to convert from Alert syntax to spreadsheet syntax: C is E3 C[-1] is E4 Row 1 is blank (except for A1 and D1) Row 2 is column labels Column A is the bar DateTime Columns B-E are the OHLC values Column F is volume Column G is # of trades Column H is blank Columns I and J are labels and spreadsheet inputs/outputs Columns K-Z...BR are Formula Columns (Depending on the Number of Formula Columns setting, 16-60.) - Each Formula Column is a subgraph of the spreadsheet study. - In the Spreadsheet System for Trading study, columns K-N are only for entry/exit signals. - All formulas in Formula Columns are entered in row 3 only. Columns to the right of Z...BR are study subgraph outputs. (Depending on the Number of Formula Columns setting, 16-60.) Date Time Of Last Edit: 2022-10-30 12:12:41
|