Support Board
Date/Time: Mon, 23 Dec 2024 16:27:40 +0000
[User Discussion] - overlay data from other chart
View Count: 831
[2015-09-17 16:58:27] |
User293865 - Posts: 13 |
Its possible to overlay data from other chart at the time a specific condition is met, with spreadsheet or acsil?
|
[2015-09-17 19:41:38] |
Sierra Chart Engineering - Posts: 104368 |
Not exactly like this. There is a method of overlaying studies and the main price graph from another chart and this is documented here: http://www.sierrachart.com/index.php?page=doc/helpdetails28.html 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-17 21:36:39] |
Sawtooth - Posts: 4141 |
You can do this with a spreadsheets study. On the destination chart, hide the overlay study, add a spreadsheet study, then use a formula like this on the spreadsheet: =IF(YourConditions,AA3,0) where column AA is the overlay study's output. If the overlay study uses a Draw Style of Line, use Line-SkipZeros instead of Line for the Draw Style of the spreadsheet subgraph. |
[2015-09-17 22:45:01] |
User293865 - Posts: 13 |
thank you tom only tell me if i can Locking the TRUE state of a condition, ie only if the condition is met(true), and not changes cell if the condition is false |
[2015-09-17 23:43:37] |
Sawtooth - Posts: 4141 |
For this you'd want to use a double IF statement in a formula column, e.g. in cell P3: =IF(ConditionsToBeginTrue,TRUE,IF(ConditionsToEndTrue,FALSE,P4)) You would then reference P3 in row 3 of the column that is drawing the overlaid study: =IF(P3,AA3,0) |
[2015-10-02 20:30:10] |
User293865 - Posts: 13 |
thank you tom for the help only one other question if the condition doesnt met and i have an empyte cell , am i need to fill the blank cell with the last previous value? i think that sc studies skip zeros! if yes how could i do thats? |
[2015-10-03 01:07:19] |
Sawtooth - Posts: 4141 |
OK, I don't understand what you want to do. Please give more details
|
To post a message in this thread, you need to log in with your Sierra Chart account: