Home >> Support Board

Support Board

Date/Time: Sun, 05 May 2024 01:39:32 +0000

How to Post a Message for Support

referencing previous bar time volume in alert

View Count: 751

[2020-01-04 12:21:14] #1 [Go To First Post]
User949539 - Posts: 4
I am trying to create alert with different studies that only occur if the 9:30 1 minute bar is a certain volume. Example: if 9:30 bar volume is greater than x, and current volume is y then show alert. I've tried: =AND(AND((V>5000),BARTIME >= TIME(09, 30, 00), BARTIME <= TIME(09, 30, 59)),V=1800) with no luck THE =AND((V>5000),BARTIME >= TIME(09, 30, 00), BARTIME <= TIME(09, 30, 59)) Formula works for showing alert for 9:30 but I cannot add it in to alerts for later in day. thank you

[2020-01-04 13:34:31] #2 [Go To First Post]
Sawtooth - Posts: 3993
You'll need to make the 9:30 bar's volume persistent all day so that you can compare it to each current bar as the day progresses. Try this: 1. Add the Spreadsheet Formula study, Use a formula like this in the Formula field: =IF(AND(MROUND(BARTIME,1/86400)=TIMEVALUE("09:30:00"),V>5000),V,ID1.SG1[-1]) where the Spreadsheet Formula study is ID1. This makes the 9:30 bar's volume persistent. 2. Add the Color Bar Based On Alert Condition study, Use a formula like this on the Alerts tab: =AND(ID1.SG1>5000,V>1800) where ID1 is the Spreadsheet Formula study.

[2020-01-04 14:25:43] #3 [Go To First Post]
User949539 - Posts: 4
I tried the spreadsheet formula and it still doesn't show alert at bar. I'm using a 1 minute chart and tried 1/1440 but stil.

[2020-01-04 14:46:57] #4 [Go To First Post]
Sawtooth - Posts: 3993
It works for me. The spreadsheet formula study's output will be the 9:30 bar's volume for the duration of the day. Then the color bar study compares it to the the volume of each bar. The color bar study is what will show the alert at each bar.

[2020-01-04 16:19:00] #5 [Go To First Post]
User949539 - Posts: 4
Thanks for the help, I might have explained it wrong, I did get the spreadsheet formula to show an alert but it doesnt work for multiple alerts. I have an alert with multiple studies such as (V>500,BV<200,id5.sg1>0.8,sum(av[-1:-5])>200) This alert works when Volume of the day is low but I want to use a different alert if volume is higher. I am using the volume of the 9:30 1 minute bar to determine which alert to use. So I want to incorporate the volume of the 9:30 bar in the alert

To post a message in this thread, you need to log in with your Sierra Chart account: