Support Board
Date/Time: Wed, 27 Nov 2024 04:34:12 +0000
[User Discussion] - alert settings
View Count: 987
| [2014-07-16 20:17:18] |
| mayerrs - Posts: 70 |
|
hi, i would like to do this: i have some alert formula in color bar based on alert conditions. this formula is forking well. but i would like to this formula work only betwen 9:00 and 12:00. am i able to do this somehow? if needed i may put the formula alert in here. thanks all |
| [2014-07-16 21:33:51] |
| Sawtooth - Posts: 4120 |
|
Include something like this in the formula: =AND(BARTIME>TIMEVALUE("09:00:00"),BARTIME<TIMEVALUE("12:00:00")) |
| [2014-07-17 07:25:02] |
| mayerrs - Posts: 70 |
|
that works!! could you please help me with this, it is the same formula but i cannot make it as i want. i have this: =AND((AV-BV)>BV,V>((V[-1]+V[-2]+V[-3]+V[-4]+V[-5])/5)*1,BARTIME>TIMEVALUE("09:00:00"),BARTIME<TIMEVALUE("12:00:00")) now i prefer the volume part other way. i would like to higlight just the bars they have volume bigger then an average betwen 9:00 and 12:00. the reason why i use just 5last bars V>((V[-1]+V[-2]+V[-3]+V[-4]+V[-5])/5)*1 is because i dont know how to make this part of formula from 9:00 to 12:00. do you think there is chance to write this part? btw, this part about volume is also from you:-) thanks |
| [2014-07-17 13:29:54] |
| Sawtooth - Posts: 4120 |
|
It's not clear to me what you want to change. Please expand your explanation.
|
| [2014-07-17 13:51:36] |
| mayerrs - Posts: 70 |
|
i would like to change the part about volume: V>((V[-1]+V[-2]+V[-3]+V[-4]+V[-5])/5)*1 this mean the condition is on when volume is bigger then an averade of past 5 bars. and i would like to have the condition on when volume is bigger then an average of volume for all bars from 9:00 - it means from open. so volume on last bar needs to be compared with all bars from 9:00 till previous bar of the last bar. |
| [2014-07-18 14:27:57] |
| Sawtooth - Posts: 4120 |
|
This cannot be done with a Simple Alert formula. It could be done with a spreadsheet study.
|
To post a message in this thread, you need to log in with your Sierra Chart account: