Support Board
Date/Time: Sun, 11 May 2025 04:53:48 +0000
Post From: Double Cloud overlap question
| [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
|