Support Board
Date/Time: Mon, 25 Nov 2024 07:45:08 +0000
Post From: Using getting an alert based off of volume and imbalance and certain price point
| [2024-03-27 14:54:41] |
| John - SC Support - Posts: 36238 |
|
Actually, this is not as hard as it seems, and you do not need two copies of the "Volume at Price Threshold Alert V2". We will not go into how you are getting the imbalance alert (if you need help with this, then let us know and we can go over it). Since you are using a Spreadsheet Study, you will first want to add a "Spreadsheet Formula" study to the chart and enter the following for the formula in the Spreadsheet Study to get the Total Volume at the level of the Imbalance: =VAP(IF(ID1.SG50 > 0, ID1.SG50, 0), 0) Where ID1 is the ID of the "Volume at Price Threshold Alert V2" and SG50 is the "Adjacent Alert Highlight Top". This gives you the total volume at the price of the top of the adjacent alerts. You can then use this in the Spreadsheet for your comparison. Note that this only gives the top of the first imbalance found. If you need to deal with multiple stacked imbalances, then you would need to modify the IF() statement to take this into account, depending on which one you want to get the information for. Refer to the following: Spreadsheet Formula For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |