Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 29 Apr 2024 09:28:08 +0000
Determining Slope or Direction. Cell Z3
View Count: 1619
| [2018-04-27 17:24:32] |
| User324443 - Posts: 18 |
|
I am trying to use the Formula that "matches the slope coloring of a study subgraph line". The example says to enter the formula in cell Z3. I have 2 Questions. How does cell Z3 know which Subgraph I want to refer to? When entering the formula in the Buy Entry cell or Sell Entry how do I refer this formula to a specific line - say a moving average ID2.SG1@3 ? Thanks, help will be appreciated. |
| [2018-04-27 18:28:42] |
| |
|
Where is that formula documented?
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 |
| [2018-04-27 18:53:35] |
| User324443 - Posts: 18 |
|
Spreadsheet Example Formulas and Usage - Common Formulas and Usage - Formula That Matches the Slope Coloring of a Study Graph Line
|
| [2018-04-27 21:02:49] |
| Sawtooth - Posts: 3982 |
|
How does cell Z3 know which Subgraph I want to refer to?
Leave the formula in column Z, and edit it to reference ID2 instead of ID1.When entering the formula in the Buy Entry cell or Sell Entry how do I refer this formula to a specific line - say a moving average ID2.SG1@3 ?
Leave the formula in column Z, and reference a slope change in your K3, M3 formulas, like this:K3: =AND(Z4=-1,Z3=1) M3: =AND(Z4=1,Z3=-1) |
| [2018-04-28 21:11:21] |
| User324443 - Posts: 18 |
|
OK, I have pasted the “Slope” condition to Z3 and it returns a “1” for the whole column. I have the “Crossover” formula in K3 - =CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@5,ID2.SG1@3:ID2.SG1@5) this works fine. However, as simple as it should be, I cannot add “=AND(Z4=-1,Z3=1)” and get anything but error messages. Obviously I am doing this incorrectly. Could I trouble you to show me how the CROSSFROMBELOW and the AND should be written as one formula. I have come a long, long way with this spreadsheet project but appear to be completely stymied at this last stage. All I need is the combined formula. I would prefer not to be sent on another hike round your manual and would be really appreciative if you could provide this final step and let me get to to trading which is what this is supposed to be about. Thank you for your attention in this matter. |
| [2018-04-28 21:33:48] |
| Sawtooth - Posts: 3982 |
|
I am not SC Support. I am just a user. OK, I have pasted the “Slope” condition to Z3 and it returns a “1” for the whole column.
The formula from the SC site will return a 1 for up slopes, and a -1 for down slopes.Maybe you've not edited it to reference ID2 instead of ID1. There are 12 ID1s that all need to be changed to ID2s. This assumes your ID2 is a moving average where there is only one subgraph of SG1. Once you've verified the Z3 formula, try this: =AND(CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@5,ID2.SG1@3:ID2.SG1@5),Z4=-1,Z3=1) I would prefer not to be sent on another hike round your manual
Don't be afraid of the documentation. It may seem daunting but it is comprehensive and will answer most questions.
|
| [2018-04-28 21:56:04] |
| User324443 - Posts: 18 |
|
No more error messages! Very many thanx. My family are grateful too!
|
| [2018-05-01 04:41:43] |
| |
|
The documentation has been improved for: Spreadsheet Example Formulas and Usage - Common Formulas and Usage - Formula that Matches the Slope Coloring of a Study Subgraph Line
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: