Support Board
Date/Time: Mon, 15 Dec 2025 19:55:59 +0000
Post From: ohlc levels
| [2015-09-23 23:58:02] |
| Sawtooth - Posts: 4299 |
|
You could workaround the 60 column limit with multiple instances of the spreadsheet study, but there are at least two other limitations, if you are using it in real time: 1) The lookback is directly related to the bar period and the Number of Rows setting, and a high number would cause lag in real time. 2) The formulas would require a INDEX(...MATCH( function combination which is not efficient in the New Spreadsheets, and would cause lag in real time, even with a low Number of Rows setting. The Old Spreadsheets version would work much better with this, but they will soon no longer be included in updated SC versions. |