Login Page - Create Account

Support Board


Date/Time: Wed, 12 Feb 2025 09:33:45 +0000



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

[2020-10-13 13:34:11]
Sawtooth - Posts: 4173
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.