Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 17:40:22 +0000



Post From: value at the end of a bar from another chart on a spreadsheet

[2013-11-08 23:32:30]
Sawtooth - Posts: 4119
The Countdown Timer study does not output its value to the spreadsheet studies. And the overlaid 500 tick bars will be based on the destination chart's bars, not the tick chart bars. So you'll need to add the same-named spreadsheet study to the 500 tick chart and calculate the remaining #trades using cells G3 and J37 on its sheet.

Put this in H1 (or any non-advancing cell)
=J37-G3

Then you can reference cell H1 from the other Sheet#:
=Sheet2!H1

where Sheet2 is the 500 tick chart's sheet.
Date Time Of Last Edit: 2013-11-08 23:42:04