Support Board
Date/Time: Wed, 14 May 2025 06:57:25 +0000
[Programming Help] - Arrows to plot above MA
View Count: 2052
| [2016-04-13 16:43:13] |
| User95787 - Posts: 18 |
|
Need help in trying to plot a Blue Arrow based on the following chart example..thanks in advance
|
 Blue MA Chart.jpg / V - Attached On 2016-04-13 16:41:39 UTC - Size: 158.71 KB - 441 views |
| [2016-04-13 17:18:01] |
| |
|
This can be done with the Color Bar Based on Alert Condition study: https://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s245 We do not provide formula programming help. 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 |
| [2016-04-13 19:44:58] |
| Sawtooth - Posts: 4214 |
|
Try this formula on the Color bar study's Alerts tab: =AND(C[-1]<O[-1],C[-1]<ID1.SG1[-1],L<L[-1],C>O,C>ID1.SG1) where ID1 is the MA; edit as needed. For an up arrow: Set the 'Output When Condition True' to 'Use Input Data' Set the 'Input Data' to 'Low' Set the Draw Style to Arrow Up. |
| [2016-04-13 19:56:16] |
| User95787 - Posts: 18 |
|
Did as you described Tom but the arrows are appearing elsewher but not on the where it needs to be. Attached is the updated screen Date Time Of Last Edit: 2016-04-13 20:10:36
|
| Blue MA Chart Tom1.jpg / V - Attached On 2016-04-13 20:10:21 UTC - Size: 206.28 KB - 483 views Attachment Deleted. |
| [2016-04-13 20:17:17] |
| User95787 - Posts: 18 |
|
Here is where the Blue Arrow shows
|
| Blue MA Chart Tom2.jpg / V - Attached On 2016-04-13 20:12:51 UTC - Size: 164.46 KB - 394 views |
| [2016-04-13 23:46:11] |
| Sawtooth - Posts: 4214 |
|
It works for me, so the formula is valid. Is the blue MA ID1? Are you using Renko bars? What is the Symbol? |
| [2016-04-14 00:31:33] |
| User95787 - Posts: 18 |
|
So I was able to correctly plot using the Low formula versus the Close as you can see on Chart 3 example but still not correctly plotting on Chart 4 example
|
| Blue MA Chart Tom3.jpg / V - Attached On 2016-04-14 00:30:18 UTC - Size: 279.04 KB - 407 views Blue MA Chart Tom4.jpg / V - Attached On 2016-04-14 00:30:32 UTC - Size: 197.92 KB - 407 views |
| [2016-04-14 02:20:16] |
| Sawtooth - Posts: 4214 |
|
You might try using H instead of C for up bars, and L instead of C for the down bars. To solve a problem like this, I would add the Spreadsheet Study study so that I could see the actual output values of everything, then use column A to find the bar where you're not getting the signal, and compare values in that row. It is likely going to be a Value Format issue, or a Tick Size issue. If the bars are Renko, you might use SG22, as described here: http://www.sierrachart.com/index.php?page=doc/doc_StudyChartAlertsAndScanning.php#BaseGraphIdentifiers |
| [2016-04-14 21:33:09] |
| User95787 - Posts: 18 |
|
Tried my hand on a spreadsheet study and tried to add another line of code for the Alert but still doesnt plot. Also tried your above method and no luck. Attached is the SS and chart to explain |
 Renko Arrow Up Down.scss - Attached On 2016-04-14 21:31:55 UTC - Size: 179.79 KB - 426 views Renko Chart1.jpg / V - Attached On 2016-04-14 21:32:07 UTC - Size: 79.77 KB - 415 views |
| [2016-04-14 23:14:17] |
| Sawtooth - Posts: 4214 |
|
I have found that this works better than the formula in post #3: =AND(C[-1]<O[-1],L[-1]<ID1.SG1[-1],L<L[-1],C>O,H>ID1.SG1) In order for me to help you further, I need a specific example. What is the DateTime in column A of the attached scss, of the missed arrow in the attached jpg? |
| [2016-04-14 23:29:39] |
| User95787 - Posts: 18 |
|
2016-04-13 09:26:21 is the Red Down Bar 2016-04-13 09:29:36 is the Green Up Bar Tried your recent formula and the arrow didnt plot, but it does work elesewhere |
| [2016-04-15 00:31:13] |
| Sawtooth - Posts: 4214 |
|
2016-04-13 09:26:21 is green up bar, based on B1221 and E1221. I can't find any missed arrows with this: =AND(ID0.SG23[-1]<ID0.SG22[-1],L[-1]<ID1.SG1[-1],L<L[-1],ID0.SG23>ID0.SG22,H>ID1.SG1) Use this for down arrows, in a separate instance of the Color bar study: =AND(ID0.SG23[-1]>ID0.SG22[-1],H[-1]>ID1.SG1[-1],H>H[-1],ID0.SG23<ID0.SG22,L<ID1.SG1) If these don't work for you, please send me your chartbook to tom@sawtoothtrade.com so I can work directly with it. |
| [2016-04-15 01:37:36] |
| User95787 - Posts: 18 |
|
That works perfectly now Tom...Thank You!!!
|
To post a message in this thread, you need to log in with your Sierra Chart account: