Support Board
Date/Time: Sun, 24 Nov 2024 16:46:48 +0000
[User Discussion] - simple alert help
View Count: 1701
| [2013-11-25 01:01:04] |
| M5amhan - Posts: 468 |
|
in using a simple alert I am trying to highlight ranges of time and would be grateful if someone could provide an example of how to plot this.. for example: from February 2010-January 2011 is highlighted in red.. i just need the code for the alert edit: =AND(BARDATE >= (05/06/2009), BARDATE <= (06/06/2009)) this is where im at but nothing will plot and there is no errorappreciate any help Date Time Of Last Edit: 2013-11-25 01:18:09
|
| [2013-11-25 01:43:02] |
| Sawtooth - Posts: 4119 |
|
Use the DATEVALUE function: =AND(BARDATE>=DATEVALUE("05/06/2009"),BARDATE<=DATEVALUE("06/06/2009")) http://office.microsoft.com/en-us/excel-help/datevalue-HP005209044.aspx?CTT=5&origin=HP005204211 http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP005204211.aspx Date Time Of Last Edit: 2013-11-25 01:47:11
|
| [2013-11-25 01:49:54] |
| M5amhan - Posts: 468 |
|
perfect.. thanks a ton tom
|
To post a message in this thread, you need to log in with your Sierra Chart account: