Support Board
Date/Time: Tue, 04 Feb 2025 08:06:12 +0000
Post From: referencing previous bar time volume in alert
| [2020-01-04 13:34:31] |
| Sawtooth - Posts: 4166 |
|
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. |