# Support Board

Date/Time: Sun, 26 May 2019 20:27:54 +0000

## Need Ratio in Number bars calculated values

Support Request:
 [2017-08-17 13:15:40] #1 traderacademie - Posts: 38 Hi, I need a ratio of 2 numbers derived from the number bars studies for 2 cases (up bar or down bar). When it's an up bar: second lowest bid/lowest bid When it's a down bar: second highest offer/highest offer In case the divisor is 0, just use 1. Is this possible to do? Rgds Will
 [2017-08-17 13:37:15] #2 binaryduke - Posts: 166 http://www.emojitrading.com/bar-ratio/
 [2017-08-17 14:55:35] #3 traderacademie - Posts: 38 Thanks, but I'm not interested in commercial indicators, also it's a very simple thing
 [2017-08-17 18:42:03] #4 Sierra Chart Engineering - Posts: 72161 When it's an up bar: second lowest bid/lowest bid When it's a down bar: second highest offer/highest offer In case the divisor is 0, just use 1. What exactly do you mean by "lowest bid". Are you referring to prices or volumes? Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
 [2017-08-17 19:24:13] #5 User590848 - Posts: 13 he means something like BVAP(LOW+TICKSIZE,0)/BVAP(LOW,0) AVAP(HIGH-TICKSIZE,0)/AVAP(HIGH,0) yes.. its simple, but not possible without programming your own study :/ unfortunately.. Alert condition gives you only True/False and spreadsheet study doesnt have acces to special functions like BVAP.. Could be really nice have some study.. where we can put some calculation formula and return result like this example. Date Time Of Last Edit: 2017-08-17 19:25:28
 [2017-08-17 20:03:34] #6 traderacademie - Posts: 38 Hi, I am referring to the volumes. I'm not sure what User590848 means. Rgds Will
 [2017-08-18 18:28:57] #7 Sierra Chart Engineering - Posts: 72161 We will add these calculations into the next release. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
 [2017-08-21 08:16:14] #8 traderacademie - Posts: 38 Thanks for implementing this! I guess it's not possible to put the decimal point?
 [2017-08-21 13:12:39] #9 Sierra Chart Engineering - Posts: 72161 Yes, we will add two decimal places for these percentages. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
 [2017-08-22 04:33:54] #10 traderacademie - Posts: 38 Yeah I saw the two decimal numbers in the prelease, but what I meant to ask is whether or not the decimal POINT is possible to display or not
 [2017-08-22 12:54:06] #11 Sierra Chart Engineering - Posts: 72161 The Value Format for individual rows of the Numbers Bars Calculated Values study are either hardcoded or dependent upon the study Value Format. We will make sure this is documented for each of them. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
 [2017-08-22 13:56:13] #12 Sierra Chart Engineering - Posts: 72161 For the two new percentage subgraphs we will change the number of decimal places to 0 by default. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.