Support Board
Date/Time: Mon, 17 Mar 2025 18:17:47 +0000
number bar study in spreadsheet formula
View Count: 813
| [2022-09-09 00:36:48] |
| User486817 - Posts: 83 |
|
hello, 1) is it possible to reference "column 1 number bars text (ln:16)" using the spreadsheet formula study? because these are not SGs, i cannot figure out how to reference that specific data. 2) in the number bars study, if i have the volume display multiplier set to 0.000001, when referencing these numbers, should i use the number as if the multiplier was set to 1 or should i use the actual number visible on the screen which is smaller due to the multiplier? kindest regards, |
| [2022-09-09 14:25:53] |
| John - SC Support - Posts: 38711 |
|
1. The Bid Volume and Ask Volume data is not directly available. The best way to access that information is by creating a custom study. It can kind of be done using the Spreadsheet Formula, since there are special functions for referencing that data for an alert. Refer to the following: Study/Chart Alerts And Scanning: Special Functions The tough part is that if you want to have access to all the numbers, you would have to add a Spreadsheet Formula study for each price level that the bar covers, not to mention one set of studies for the Bid and another for the Ask. If you are just wanting to see if a value is above a certain level, then you could use an IF statement and something like the following: =IF(BVAP(L, 0) > x, BVAP(L, 0), (IF(BVAP(L+TICKSIZE*1, 0) > x, BVAP(L+TICKSIZE*1, 0), (IF(BVAP(L+TICKSIZE*2, 0) > x, BVAP(L+TICKSIZE*2, 0), ...)))) 2. It depends on what you want to do with the data and whether you want to use the actual number or the modified number. We really can not say what you need to do, as it depends on what you are doing and how you want to view the information. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-09-12 01:41:13] |
| User486817 - Posts: 83 |
|
hello john, 1. thank you for your reply. i understand what you mean. i'm not knowledgeable enough at this point with coding to make a custom study, but based on your answer i might be able to do what i need to do using a spreadsheet formula IF statement. i have column 1 of the number bar study set to total volume -- all i need to do is have a formula for the total volume at that price be less than a certain value which i can set. is this possible? would you kindly help me with that formula code? 2. given the context now, would i need to input the "real" volume number or the number after the multiplier? kindest regards, |
| [2022-09-12 09:12:51] |
| Sierra_Chart Engineering - Posts: 18809 |
|
1. You have to be able to access this data in the Spreadsheet. You can but we do not know how easy it would be to work with from formulas. However, refer to this Input setting: Spreadsheet Study Inputs: Output Volume at Price Data 2. The number after the multiplier. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-09-12 15:15:03] |
| John - SC Support - Posts: 38711 |
|
Your formula would look like the following: =IF(VAP(L, 0) < x, VAP(L, 0), (IF(VAP(L+TICKSIZE*1, 0) < x, VAP(L+TICKSIZE*1, 0), (IF(VAP(L+TICKSIZE*2, 0) < x, VAP(L+TICKSIZE*2, 0), ...)))) Keep in mind the ... above is for you to continue to write out the IF formulas to cover the entire height of the bars. You may also need to put in a special check against 0 values, such as: IF(AND(VAP(L, 0) < x, VAP(L, 0) > 0), VAP(L, 0), IF(AND... It can get quite complicated. Also, as noted above, since you are dealing with Total Volume and not individual Bid/Ask volumes, you could use the Spreadsheet Study instead. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-09-13 02:46:18] |
| User486817 - Posts: 83 |
|
hello john, thank you for the reply. i appreciate the formula. i will do my best to implement it into my studies. thank you for your replies and you can consider this issue closed. kindest regards, |
To post a message in this thread, you need to log in with your Sierra Chart account: