Home >> Support Board

Support Board

Date/Time: Sat, 20 Apr 2024 08:22:33 +0000

How to Post a Message for Support

[Programming Help] - draw volume profile

View Count: 2715

[2021-05-18 23:14:23] #1 [Go To First Post]
User586297 - Posts: 31
Hi there, I have question on the volume profile interactive drawing tool. When I drag from one point to the other, let say 12 seven minute candles. All i want to see is the bid minus the ask number on top right , green or red. Can you please help.Thanks

[2021-05-19 13:41:53] #2 [Go To First Post]
John - SC Support - Posts: 30976
Refer to the information here: Volume By Price Study: Step by Step Instructions to Configure the Draw Volume Profile Tool For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-04-18 18:45:33] #3 [Go To First Post]
User586297 - Posts: 31
Hi, I have the color background based on alert condition =C>=L[-1] Also have the ask/v bid/v difference in text. How may I get the sum only on the alert condition. Tried the study subgraph Add and others. May you help. Thank you , Have a awesome day.

[2022-04-18 20:32:56] #4 [Go To First Post]
John - SC Support - Posts: 30976
If you are wanting to get some piece of information based on a criteria, then it is easiest to use either the Spreadsheet Study or the Spreadsheet Formula study. In either case, you will use an IF() statement to get what you want. For example, if you want to sum the volume of the two bars when the Close of the current bar is greater than the Low of the previous bar, then you would write the following for the Spreadsheet Formula: = IF(C > L[-1], V + V[-1], 0) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-04-19 19:41:48] #5 [Go To First Post]
User586297 - Posts: 31
Hi, Tried the spreadsheet formula with IF() statement. Put it chart region one and a line is placed. Went into draw style and changed it to text, custom text, and others and change the scale as well. Didn't get the sum of alert function. May you help. Thank you sir. OR IS THERE A WAY TO USE THE DRAWING VOLUME PROFILE AUTOMATICLY WITH ALERT CONDITION. =C>=L[-1]

[2022-04-20 14:05:47] #6 [Go To First Post]
John - SC Support - Posts: 30976
We are not understanding exactly what you are wanting to do. Please give us the end point of what you want so we can help you get there. Are you wanting an Alert, or the sum of the alerts and if the sum then based on what criteria? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-04-20 17:10:51] #7 [Go To First Post]
User586297 - Posts: 31
Hi, I have the color background based on alert condition =C>=L[-1] Also have the ask/v bid/v difference in text. How may I get the sum only on the alert condition of =C>=L[-1] in text form. Thank you, Sir

[2022-04-20 17:43:07] #8 [Go To First Post]
John - SC Support - Posts: 30976
If you want the sum of the alerts for the Color Background Based on Alert Condition, that is the number of bars for which this condition is true, then you would have to use the Color Bar Based on Alert Condition and set the Color Bar subgraph to Background. Then you have access to the Sum of Alerts subgraph from that study. Refer to the information here: Color Bar Based on Alert Condition: Using the Sum of Alerts Subgraph But we are still not sure what this has to do with the Ask Volume Bid Volume Difference in Text study. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-04-20 21:55:02] #9 [Go To First Post]
User586297 - Posts: 31
Hi, Tried what you suggested, that's not it. I have the color background based on alert condition =C>=L[-1] Also have the ask/v bid/v difference text on the chart. How may I get the sum of ask/v - bid/v difference on the alert condition of =C>=L[-1] in text form. Thank you, Sir #########################################################################A/B Difference ___________________ _______________ ______________ _____________=C>=L[-1] Color Background SUM SUM SUM SUM

[2022-04-21 14:17:09] #10 [Go To First Post]
John - SC Support - Posts: 30976
It looks like the only piece you are missing is placing the Sum of Alerts on your chart. To do this, use the Study Subgraph Above/Below Bar as Text and reference the Sum of Alerts subgraph to display it. Refer to the following: Study Subgraph Above/Below Bar as Text For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-04-21 23:43:35] #11 [Go To First Post]
User586297 - Posts: 31
Hi, Tried the color bar based on alert condition. Changed the scale. Use input data. Color bar to background. Sum of alerts to text. On alerts used, = IF(C > L[-1], V + V[-1], 0) =AND(ID1.SG1 > 0 , C > ID8.SG1) = IF(C > L[-1], AV + BV[-1], 0) The background prints but no sum of ask/v bid/v difference. Using the wrong formula? Please help, thanks.

[2022-04-22 14:10:41] #12 [Go To First Post]
John - SC Support - Posts: 30976
Can you please give us an image of the chart you are trying to create. Refer to the following for how to take a screenshot: https://www.sierrachart.com/index.php?page=PostingInformation.php#PostingAnImage In terms of the Alert formulas, although the IF statement will work, the Color Bar Based on Alert Condition is only using a True/False condition, where 0 is false and any other number if true. So you do not need to add the volumes, as that information is not going to be used. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-04-22 17:33:25] #13 [Go To First Post]
User586297 - Posts: 31
Hi, https://www.sierrachart.com/image.php?Image=165064820272.png please help, Thank You

[2022-04-22 20:05:28] #14 [Go To First Post]
John - SC Support - Posts: 30976
We understand the alert condition you are wanting - Close is greater than or equal to the Low of the previous bar. But we are still a little confused on what number you are wanting to see when this condition is met. Are you wanting the sum of the Ask/Bid Difference from the current and previous bars? Or something else? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-04-22 20:50:17] #15 [Go To First Post]
User586297 - Posts: 31
Hi, The sum of A/B on the colored background. Thanks.

[2022-04-22 21:51:39] #16 [Go To First Post]
John - SC Support - Posts: 30976
We have attached a Study Collection that does what you are looking for. Note that you will want to put this onto a separate chart first, as we have the Ask/Bid Difference and Color Background in here to show you have it is all put together. In particular, the main calculation for your sum is done by a hidden Spreadsheet Formula. Refer to the following for how to use a Study Collection provided by Sierra Chart: Study Collections: Using a Study Collection Provided by Sierra Chart Support For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing


SumDeltaBasedOnAlert.StdyCollct - Attached On 2022-04-22 21:51:35 UTC - Size: 62.06 KB - 121 views

[2022-04-24 04:49:44] #17 [Go To First Post]
User586297 - Posts: 31
Hi, This works, I really do appreciate your help with figuring out the formulas. May it be tweaked a bit? The study Subgraph Above/Below as Text, may it print the numbers vertically instead of horizontally. Like 4 5 7 And the color background, may it be a box from low to high?

[2022-04-25 14:31:34] #18 [Go To First Post]
John - SC Support - Posts: 30976
There is not an option to print the data horizontally. As to the color background, this could be done, but it would require at least a combination of Study Subgraphs Reference and the Color Bar Based on Alert Condition studies. This is something that you would have to work out. Be sure to understand how to fill an area by reviewing this information: Chart Studies: Filling the Area Between Two Study Subgraphs within Same Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-04-25 20:02:31] #19 [Go To First Post]
User586297 - Posts: 31
Hi, Been at it for a bit now. Sending a pic to make sure were on the same page. https://www.sierrachart.com/image.php?Image=1650916500816.png Thank you.

[2022-04-25 21:27:35] #20 [Go To First Post]
John - SC Support - Posts: 30976
What we had suggested previously would only give you the box around each candle, not the box around the set of candles that met the original criteria. Doing what you want is more complicated and would require finding the High and Low over the range of the bars and using that to create the fill area. It might be doable, but we do not know how to put it together offhand. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-04-26 18:21:08] #21 [Go To First Post]
User586297 - Posts: 31
Hi, SumDeltaBasedOnAlert that you provided. On the study subgraph above/below bar as text. Is there a way to have the current and previous number to print? Or just the current number. Thank you.

[2022-04-27 13:27:48] #22 [Go To First Post]
John - SC Support - Posts: 30976
We assume by "Previous Number" that you mean the number from the previous bar. To do this, you would need another pair of Spreadsheet Formula and Study Subgraph Above/Below Bar as Text studies. In the new Spreadsheet Formula, you would reference the data from the first Spreadsheet Formula for one bar back. To do this you would use a formula like the following: =ID2.SG1[-1] Where ID2 is the ID of the first Spreadsheet Formula and SG1 is the Subgraph from the second Spreadsheet Formula. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-04-29 19:43:47] #23 [Go To First Post]
User586297 - Posts: 31
Hi, Sending a pic to clarify. http://www.sierrachart.com/image.php?Image=1651261251136.png

[2022-04-29 21:27:27] #24 [Go To First Post]
John - SC Support - Posts: 30976
The only thing we can think of is to try and use the Spreadsheet Study to do what you want rather than the Spreadsheet Formula. In this case, you would have to add some kind of additional test to see if there only 2 data points available and then zero out everything before those 2. This is not something that we can help further with, as it is getting into more complex programming that is beyond the scope of our support. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-05-24 19:28:51] #25 [Go To First Post]
User586297 - Posts: 31
Hi there, Just refilled Sierra Charts and have transact account. Am still getting delayed info. May you help.

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