Login Page - Create Account

Support Board


Date/Time: Tue, 01 Jul 2025 07:34:16 +0000



Post From: Spreadsheet study: Direct A3 result alignment between two sheets

[2020-10-13 13:34:11]
Sawtooth - Posts: 4231
Try this:

On the 15min chart:
- Add the Spreadsheet Formula study, with a formula like this in the Formula field:
=ID1.SG5
where ID1 is the spreadsheet study, and SG5 is column O.

On the 1TickRange chart:
- Add the Study/Price Overlay study, set the Study to Overlay to the Spreadsheet Formula study on the 15min chart.
- On Sheet2 of the spreadsheet, in a Formula Column, use a formula like this:
=ID2.SG1@3
where ID2 is the Study/Price Overlay study.