Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 26 Apr 2024 21:11:52 +0000
[User Discussion] - Overlay ?
View Count: 1033
| [2015-09-01 05:26:00] |
| User713273 - Posts: 409 |
|
1. When I overlay the 1 min chart on to the 5 sec in the spreadsheet. A-G updates the 5 second prices however, I expected the 1 min to give me bar prices are the 55th second of the min. Some reason I get the minute data at the 30th second in the spreadsheet. What do I need to do to line up the 1 min bar with the 5 second bar. 2. When writing custom formula for a Spreadsheet Alert that has the 1 min overlayed on the 5 sec chart. In my custom formula I would like to take 5 sec close and subtract the prev 1 min close. However there are only prices for the 1 min every twelfth row. I know for the first if can use offet by 12 but what about the 11th, 10th etc? thx |
| [2015-09-01 17:32:56] |
| User713273 - Posts: 409 |
|
The 1 min bars need to be from 12:50:00 to 12:50:55 but they are showing 12:49:30 to 12:50:25 How do we get it to line up on the min which it does when we do not overlay the 1 min on the 5 sec? Thx, hope that clears it up... |
| [2015-09-01 21:59:33] |
| User713273 - Posts: 409 |
|
Ive attached a file contaning the issue at hand within a spreadsheet, assistance would be warranted.
|
 image (2).png / V - Attached On 2015-09-01 21:58:01 UTC - Size: 215.34 KB - 292 views |
| [2015-09-02 00:47:31] |
| |
|
We will be responding once we have a time to comprehensively review. Should be later today.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2015-09-02 04:03:41] |
| User713273 - Posts: 409 |
|
Thx, what would also work is being able to cross-refrence custom studies from 2 different charts as you can see the 1 minute custom study indicator isnt laying over on the 5 sec spreadsheet. time is shifted by 30 seconds.
|
| [2015-09-02 04:36:45] |
| User713273 - Posts: 409 |
|
Nm found the answer thx
|
| [2015-09-04 05:35:48] |
| |
|
Carefully review the documentation here for the Study/Price Overlay study. Because it does answer all of your questions: https://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s118 Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: