Support Board
Date/Time: Mon, 25 Nov 2024 05:34:44 +0000
Using getting an alert based off of volume and imbalance and certain price point
View Count: 352
| [2024-03-27 05:09:58] |
| aswade3451 - Posts: 19 |
|
I am attempting to make an automated strategy that goes long when a imbalance alert from one Volume at price threshold V2 and the total volume from that same pricepoint is greater than 100 or whatever current value. I was attempting to do this by using a second Volume at Price Threshold V2 for total volume at that pricepoint, however I cannot seem to create a spreadsheet code that allows me to compare the two alerts? Is there a way to do this? I know that it is a very complicated, thanks to all that are willing to help
|
| [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 |
| [2024-03-28 04:49:54] |
| aswade3451 - Posts: 19 |
|
Thanks you very much John. For anyone else viewing this, the formula has to be used with the Study.Subgraph format not the cell number- exactly how the prior post by John put it "=VAP(IF(ID1.SG50 > 0, ID1.SG50, 0), 0)"
|
| [2024-03-28 13:34:26] |
| John - SC Support - Posts: 36238 |
|
Yes, the "Spreadsheet Formula", despite it's name, uses the Alert Syntax, not the Spreadsheet Syntax, which are different.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: