Support Board
Date/Time: Wed, 19 Mar 2025 07:35:51 +0000
Volume at Price threshold SG1 column missing from spreadsheet - FIX REQUIRED
View Count: 546
| [2022-10-12 12:27:16] |
| User350416 - Posts: 43 |
|
Hi, I need to use the "Volume at Price threshold V2" study in a spreadsheet system for trading. However the column SG1 Trigger 0 is not listed in the spreadhseet, so the very first alert gets missed. Subsequent alerts are listed but not the very first alert Also in the spreadsheet, the subgraph "count of alerts" does not count the very first alert so there is no work around this missing column. Please see screenshot of spreadsheet attached: - The column ID2.SG1 (trigger 0) is missing as a result Count of Alerts SG59 is 0 when it should show 1 when the first alert is triggered by SG1 - The Count of alerts SG59 also doesn't seem to work correcly as it displays 1 or 2 alert when no value is scored in the trigger columns Could you please fix this issue? Many thanks |
Private File Attachment Deleted. |
| [2022-10-12 15:16:29] |
| John - SC Support - Posts: 38782 |
|
We just did a few tests and we are not able to reproduce what you have occurring in your Spreadsheet. For us the first Subgraph (Trigger 0) is showing properly and the Count of Alerts is showing the correct values. Please change the Input on the Spreadsheet Study for Blank Columns After Each Study to 2 and see if this corrects the information in the spreadsheet. Also, make sure the Spreadsheet Study is the lowest in the list of studies on the Chart Studies window. Otherwise, you would have to try removing the Volume at Price Threshold Alert V2 study and adding it back to the chart and see if it comes in correctly that way. If that does not work, then try a new chart with a new Spreadsheet Study and the Volume at Price Threshold Alert V2 and make sure that shows properly. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-10-12 20:50:16] |
| User350416 - Posts: 43 |
|
Thank you very much for your quick answer. By recreating everything from scratch it works and I have now SG1 listed. However when the SG1 trigger 0 lists a value it lists 0 as Count of alerts SG59, and when the coutn of alerts lists a value there is no value under SG1 ... When looking at it further, the alert actually prints correctly in the Count of alerts under the correct time BUT the spreadsheet prints une line below (under the worng time) the SG1. For instance for a numbers bar chart on which we run the threshold study with the following parameters : vol thresohold 20 and additional vol 0 it returns an alert at 22:26:00 BUT on the spreasheet at 22:26 there is no SG1 value whereas the Count of alerts SG59 list 1, and the SG1 value is listed at 22:24, which is incorrect as the alert was triggered at 22:26. So there is a mismatch between the alert count and the SG1 value at one candlestick time bar separation. Can you please fix this or let me know if it is a parameter I'm getting wrong? Screenshot and spreadsheet to follow on next message Many thanks |
| [2022-10-12 20:52:59] |
| User350416 - Posts: 43 |
|
https://www.sierrachart.com/image.php?Image=1665607959832.png
|
Private File |
| [2022-10-12 21:09:42] |
| User350416 - Posts: 43 |
|
I just answered my own question : th eright triangle marker was displaced at -1 which was getting me the wrong time at SG1... Many thanks for your help, we can close this post. Have a nice end of day |
To post a message in this thread, you need to log in with your Sierra Chart account: