Support Board
Date/Time: Sun, 22 Dec 2024 20:46:21 +0000
[User Discussion] - Color Bar Based on Alert Condition study - Number of bars
View Count: 1639
| [2015-06-08 10:38:05] |
| nicktrader - Posts: 715 |
|
I am using the study: "Color Bar Based on Alert Condition" and I'd like to see the last 3 triggered bars only. But it do not work because there is no automatically refresh. What I have to do? Many thanks |
 Color Bar Based on Alert Condition - Number of bars.png / V - Attached On 2015-06-08 10:34:25 UTC - Size: 33.93 KB - 462 views |
| [2015-06-08 17:38:08] |
| |
|
This is not supported or possible.
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-06-08 20:07:29] |
| Sawtooth - Posts: 4141 |
|
I think this could be done with the Spreadsheet Study study.
|
| [2015-06-09 02:31:06] |
| nicktrader - Posts: 715 |
|
@tomgilb Many thanks but I do not have any experiences with spreadsheets study. |
| [2015-06-09 15:48:33] |
| SgtJ - Posts: 154 |
|
As great as sierra is, without knowing how to use spreadshetts or more importantly acsil, your missing out on its greatest strengths (imho).
|
| [2015-06-09 19:37:13] |
| Sawtooth - Posts: 4141 |
|
@nicktrader If you are willing to share your trigger conditions, I'll put something together for you. |
| [2015-06-09 21:23:34] |
| nicktrader - Posts: 715 |
|
@tomgilb Many thanks for your support. There are two little formulas. For "green bar": =AND(C[-1] >O[-1], H>H[-1]) and if triggered a green point on low and for the "red bar": =AND(C[-1] <O[-1], L<L[-1]) with a red point on high if triggered. After 3 triggered bars the dot should disapear. That's it. It is only a little visual help if triggered. Tom as I told you. My knowledges concernin spreadsheets are running close to zero. I was "playing" a little with the "Depth of Market Data" Study in connection with a spreedsheet study but after I while I gave up. The problem for me was the 10 digits DOM. After 10 digits I did not get any values. What do you think. Could you help me to put something together? If yes I would open a new thread. Many thanks for your help. |
| [2015-06-09 23:08:45] |
| Sawtooth - Posts: 4141 |
|
-Put both of the attached files in your Sierra Chart \Data folder. -Go to Analysis >> 3trigger- -When asked 'Clear Existing Studies On Chart?', choose No. This study will calculate all of the triggers but will only paint the 3 most recent triggered dots, counting the green and red combined. You don't need to interact with the spreadsheet; you may minimize it. This is for New Spreadsheets versions only. |
 3trigger.scss - Attached On 2015-06-09 23:05:22 UTC - Size: 47.08 KB - 440 views 3trigger-.StdyCollct - Attached On 2015-06-09 23:05:29 UTC - Size: 9.39 KB - 476 views |
| [2015-06-10 03:50:34] |
| nicktrader - Posts: 715 |
|
@tomgilb Many thanks for your help. I test it but there were more than 3 dots for each. But no problem. I made a "Quick& Dirty" solution. I changed the "number of rows" to the minimum of 10. Your Spreadsheet and Study Collection is a good base to study it. Very helpful to get in touch with spreadsheets. |
| [2015-06-10 04:30:37] |
| nicktrader - Posts: 715 |
|
@tomgilb I "played" a little with the spreadsheet and 3trigger study and I do not know why but now it works as it should. After 3 dots the previous disapear. Date Time Of Last Edit: 2015-06-10 04:31:15
|
| [2015-06-10 20:05:25] |
| nicktrader - Posts: 715 |
|
@tomgilb I open a new thread. Maybe you find time to take a look on it and give me a helping hand. Depth of Market Data study in connection with a Spreadsheet Many thanks |
To post a message in this thread, you need to log in with your Sierra Chart account: