Support Board

Date/Time: Mon, 29 Apr 2024 03:26:21 +0000

Post From: Orientation ??

[2015-08-26 13:09:38] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3982
1) With the spreadsheet studies, only columns K-Z...BR will auto-populate from row 3, depending on the Number of Formula Columns setting (16 to 60). These should auto-populate in the New Spreadsheets version, but in the Old Spreadsheets version you can force it to recalculate by going to Chart >> Recalculate. 2) Since the spreadsheet study is added to the chart, scroll the chart into the past, and go to Chart >> Replay Chart. If the spreadsheet data is not following the chart data, you may be looking at the wrong sheet#. By default, the chart# will output to its respective sheet#. 3) Each spreadsheet row is a chart bar. The current bar is in row 3; previous bars are rows below. For the previous bar, reference row 4 in your row 3 formula.