Support Board
Date/Time: Sun, 11 May 2025 04:16:19 +0000
Double Cloud overlap question
View Count: 321
| [2024-08-26 17:04:21] |
| K-1 - Posts: 16 |
|
Greetings Support Gurus! I'm hoping to get some assistance setting up a study. I used 2 x "Study Subgraphs Reference" to create 2 separate clouds, one cloud for the 9 and 24 SMAs and one for the 90 and 240 SMAs and I wish to keep both of these clouds hidden. However, I am looking to create a cloud only visible during the overlap/intersection of these two clouds and I'm spinning my wheels on trying to create it. Any help would be much appreciated. Thanks! D |
| [2024-08-26 20:38:48] |
| John - SC Support - Posts: 39699 |
|
This requires the use of Set Theory, as you are wanting all members of Set A (9 and 24 SMAs) that are also in Set B (90 and 240 SMAs). We are not sure of a way to do this directly in Sierra Chart. We need to think on it a bit. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-08-26 20:57:18] |
| K-1 - Posts: 16 |
|
thanks for getting back to me. even if the third (combined) cloud isn't visible, is there a way to have an alert, signal, something pop up when there is some overlap of the to sets? That's just as good for me. A little bubble above price, a vertical stripe....
|
| [2024-08-26 21:31:21] |
| John - SC Support - Posts: 39699 |
|
I just can not think of a way to do this with the built-in studies off the top of my head, and it is not something anyone has asked for in the past several years, so I have not tried to come up with a solution previously. I need to think if there is a way to do this, but I just do not have time to delve deep into it at the moment. I have set this to follow up for myself, but if you do not hear from me in a week, please post back and remind me. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-08-27 11:48:15] |
| K-1 - Posts: 16 |
|
Awesome, thanks for the follow up. Just for context, I'd use this on a 50 tick chart. When the 9/24 cloud enters the 90/240 cloud, i find it to be indicative of chop and thus use it as a signal for commencing reversion trades. I use 5/9 and 50/90 SMA clouds for entries on the same 50tk chart thus me not wanting to have too have the 9/24 and 90/240 clouds visible as it would be just too much junk on the chart. These clouds are only important to me when they overlap, which is about 60-70% of the time. Thanks for the help! |
| [2024-08-27 16:14:11] |
| Sawtooth - Posts: 4214 |
|
John and K-1: This can be done with the Spreadsheet Study study. The concept: 1. Use a formula in K3 like this: =AND(MIN(ID1.SG1@3,ID1.SG2@3)>MIN(ID2.SG1@3,ID2.SG2@3),MAX(ID1.SG1@3,ID1.SG2@3)<MAX(ID2.SG1@3,ID2.SG2@3)) -where ID1 is the fast cloud and ID2 is the slow cloud. (Two Moving Averages studies were used in my example.) This goes TRUE when the entire fast cloud is inside the slow cloud. To go TRUE when the edges of the fast cloud are inside the slow cloud, use a formula like this instead: =AND(MAX(ID1.SG1@3,ID1.SG2@3)>MIN(ID2.SG1@3,ID2.SG2@3),MIN(ID1.SG1@3,ID1.SG2@3)<MAX(ID2.SG1@3,ID2.SG2@3)) 2. Use 2 adjacent Formula Columns, one pair for each of the clouds. Create the visible clouds with these subgraphs by using formulas like these: L3: =IF(K3=1,ID1.SG1@3,0) M3: =IF(K3=1,ID1.SG2@3,0) N3: =IF(K3=1,ID2.SG1@3,0) O3: =IF(K3=1,ID2.SG2@3,0) -refer to above for which each ID# is what. These formulas will only display the MAs when the fast cloud is inside the slow cloud. Adjacent columns can be used with Fill Top/Fill Bottom draw styles to create a cloud. 3. Hide or Remove the studies used to create the full clouds. Date Time Of Last Edit: 2024-08-27 18:22:17
|
| [2024-08-27 17:25:08] |
| John - SC Support - Posts: 39699 |
|
Thank you Sawtooth.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-08-28 12:03:07] |
| K-1 - Posts: 16 |
|
Nice! I'll give it a shot! Thanks all |
| [2024-08-31 11:21:45] |
| K-1 - Posts: 16 |
|
hey all, I'm trying to get this to input but Im a bit lost. It's my first time using code and I've tried looking at it with fresh eyes a few times but no dice. So a couple questions, I have my SMAs on my "Studies to Graph" as ID:12 ID:13 ID:14 and ID:17 (with colons) In the second option of the code to go true when the edges of the fast cloud are inside the slow: =AND(MIN(ID1.SG1@3,ID1.SG2@3)>MIN(ID2.SG1@3,ID2.SG2@3),MAX(ID1.SG1@3,ID1.SG2@3)<MAX(ID2.SG1@3,ID2.SG2@3)) It is my understanding is that I should do this: =AND(MIN(ID12.SG1@3,ID13.SG2@3)>MIN(ID14.SG1@3,ID17.SG2@3),MAX(ID12.SG1@3,ID13.SG2@3)<MAX(ID14.SG1@3,ID17.SG2@3)) Then for Part #2 L3 =IF(K3=1,ID12.SG1@3,0) M3 =IF(K3=1,ID13.SG1@3,0) N3 =IF(K3=1,ID14.SG1@3,0) O3 =IF(K3=1,ID17.SG1@3,0) when i do this, see attachment for a screenshot of the errors I get. Thanks all, sorry for being a pest and thanks in advance for the help! |
 Screenshot 2024-08-31 061812.png / V - Attached On 2024-08-31 11:18:31 UTC - Size: 45.63 KB - 65 views |
| [2024-08-31 14:44:18] |
| Sawtooth - Posts: 4214 |
|
when i do this, see attachment for a screenshot of the errors I get.
There are no #SYNTAX? errors so your formulas look good, assuming ID12 and ID13 are the fast cloud, and ID14 and ID17 are the slow cloud.Something else is wrong. See this for possibly why: Working with Spreadsheets: Spreadsheet Errors So that the slow cloud is behind the fast cloud, formulas in L3/M3 and N3/O3 need to be swapped: L3 =IF(K3=1,ID14.SG1@3,0) M3 =IF(K3=1,ID17.SG1@3,0) N3 =IF(K3=1,ID12.SG1@3,0) O3 =IF(K3=1,ID13.SG1@3,0) This works for me. See attached pic. Date Time Of Last Edit: 2024-08-31 21:38:22
|
| 2 Clouds.PNG / V - Attached On 2024-08-31 21:38:17 UTC - Size: 19.29 KB - 54 views |
To post a message in this thread, you need to log in with your Sierra Chart account: