Support Board
Date/Time: Sun, 24 Nov 2024 15:05:53 +0000
[User Discussion] - value at the end of a bar from another chart on a spreadsheet
View Count: 1462
| [2013-11-08 19:18:08] |
| mysteron - Posts: 14 |
|
Maybe I'm wrong, on a spreadsheet, it seems impossible to get the end of bar value from a different chart. Example, the spreadsheet is on a 5 ticks range bar chart and I want to get the value of a 500 ticks chart. Study price overlay is done. The way I think I can resolve that is by adding to this chart the tick remaining study. Then I want to get the value if there is less than 20 ticks left before the closing of the bar. The problem that I have now is that I get 0 on my spredsheet column dedicated to this remaining tick study even if I see the number on the 500 ticks chart. Thanks in advance. |
| [2013-11-08 23:32:30] |
| Sawtooth - Posts: 4118 |
|
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
|
| [2013-11-11 12:10:28] |
| mysteron - Posts: 14 |
|
Thanks again Tom for your support, I'll work on that. Dan |
| [2013-11-12 00:26:51] |
| mysteron - Posts: 14 |
|
Very professional work from this gentleman. I recommend you to subcontact to Tom. That's what I did today and work was done accordingly to my requirements. tom@sawtoothtrade.com |
To post a message in this thread, you need to log in with your Sierra Chart account: