Support Board

Date/Time: Sat, 18 May 2024 12:40:38 +0000

Post From: ohlc levels

[2015-09-23 23:58:02] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
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.