Support Board

Date/Time: Wed, 12 Feb 2025 07:29:35 +0000

Post From: Backtesting issue. Time based indicator/ multiple charts and sheets.

[2020-10-06 12:58:26] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4173
It is recommended that you use one of the overlay studies to reference values on other sheets, instead of directly referencing the other sheets. Referencing Other Charts in Spreadsheet Study Formulas: Referencing Other Charts in Spreadsheet Study Formulas There is an easier way to find the previous close of a symbol, using the Spreadsheet Formula study, with a formula like this: =IF(ID1.SG1=100,C,ID2.SG1[-1]) - where ID1 is the Time Line study, and ID2 is the Spreadsheet Formula study. This will get the Close price at the time line and make it persistent until the following day. Then overlay this on the main chart using the Study/Price Overlay study. Then reference the overlay study in formulas on the main chart's spreadsheet study. You won't need to use spreadsheet studies on charts 2 and 3.