Support Board

Date/Time: Tue, 14 May 2024 10:49:19 +0000

Post From: Shortcut for Alert Requiring Multipe Prior Bars in MAX Formula

[2016-09-07 14:47:50] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3996
I have never been able to successfully use the spreadsheet study function without a severe performance issue Significant performance improvements were made to New Spreadsheets in v1358. If you haven't tried them since before this version, you should give them another try when you need the additional functionality. As Support says, you can minimize performance impact by keeping the Number of Rows to a minimum. If you need to see further into the past than the Number of Rows setting, you can scroll the chart into the past and start a Replay Chart, then pause it. You could use one same-named spreadsheet for all charts in a chartbook, since by default each chart will output to its own sheet. In this scenario, the Chart Data Output Sheet Number needs to be set to 0. If the formulas are the same for some or all sheets, you can have one sheet set as the master. This is done with the Formula Source Sheet Number setting. Otherwise, the Formula Source Sheet Number should be set to match the chart #. If you have multiple chartbooks open concurrently, the spreadsheet name needs to be unique to each chartbook.