Support Board
Date/Time: Sun, 22 Dec 2024 22:48:30 +0000
Post From: Orientation ??
| [2015-08-26 13:09:38] |
| Sawtooth - Posts: 4141 |
|
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. |