Support Board
Date/Time: Wed, 04 Dec 2024 19:19:08 +0000
ADD NUMBERS BOTTOM DATA
View Count: 299
| [2024-06-07 04:55:08] |
| User709203 - Posts: 9 |
|
Could we please add percentage AskBid Diff Max to Close Diff and percentage AskBid Diff Min to Close Diff
|
| [2024-06-07 14:38:45] |
| John - SC Support - Posts: 36469 |
|
We believe that you are referencing the "Numbers Bars Calculated Values". There are existing subgraphs for the following: - Maximum Ask Bid Vol Diff to Closing Ask Bid Vol Diff - Minimum Ask Bid Vol Diff to Closing Ask Bid Vol Diff If this is not exactly what you are looking for, then there are other items that already exist that you can use to create the indicator you want. For instance, there are these two items that could be divided to get what you want: - Ask Volume Bid Volume Difference - Maximum Ask Volume Bid Volume Difference Refer to the following: Using the Basic Arithmetic Studies For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-11-24 03:49:24] |
| User709203 - Posts: 9 |
|
https://www.sierrachart.com/image.php?Image=1732418967107.png Please have a look at this chart, I want to display the minimum and maximum value from my numbers bars to numbers bottom. If I can be pay an extra fee for this I don't mind or if I can be able to solve it on my own please guide me on how I can go about it. It means a great deal for my chart studies. |
| [2024-11-25 15:15:10] |
| John - SC Support - Posts: 36469 |
|
You can do this using the built-in tools. Do the following: - Add the Numbers Bars study. - Set the Input for "Highlight Minimum Value In" to a particular column where you want to have the highlight - Set the Input for "Highlight Maximum Value In" to a particular column where you want to have the highlight - Set the Input for "Highlight Maximum/Minimum Value Based On" to "Bid Volume or Ask Volume" - Set the Input for "Ignore 0 Values for Minimum Highlight" to "Yes" With the above, the Numbers Bars subgraphs for "Price at Minimum Highlight" and "Price at Maximum Highlight" will have the price level for the Minimum/Maximum Bid or Ask. If you want the actual Minimum/Maximum numbers, then do the following: - Add two copies of the "Spreadsheet Formula" study to the chart. Enter the following formulas to get the maximum and minimum numbers (one each into each Spreadsheet Formula): =IF(AVAP(ID1.SG4, 0) <= BVAP(ID1.SG4, 0), AVAP(ID1.SG4, 0), BVAP(ID1.SG4, 0)) =IF(AVAP(ID1.SG5, 0) >= BVAP(ID1.SG5, 0), AVAP(ID1.SG5, 0), BVAP(ID1.SG5, 0)) Where ID1 is the ID of the Numbers Bars study, SG4 is the "Price at Minimum Highlight" subgraph, and SG5 is the "Price at Maximum Highlight". You can then use the "Numeric Information Reference" study to put those values into a numeric table (similar to the "Numbers Bars Calculated Values" study). Refer to the following: Numbers Bars: Highlight Minimum Value In Numbers Bars: Highlight Maximum Value In Numbers Bars: Highlight Maximum/Minimum Value Based On Numbers Bars: Ignore 0 Values for Minimum Highlight Spreadsheet Formula Study/Chart Alerts And Scanning: Special Functions Numeric Information Reference For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-11-25 18:16:44] |
| User709203 - Posts: 9 |
|
Hey John, thank you for getting back to me. I have been trying to apply the formula you have sent me but it does not produce the desired results. I want the maximum (ask vol-bid vol) and the minimum (ask vol-bid vol) be displayed similar to the "Numbers Bars Calculated Values" study and not the Bid vol or Ask vol. I have also noticed that when I add a study to my chart and then I click apply to load the added study onto the chart, the spread sheet values resets to zero. I would also really appreciate if you could help me on this. Thank you. |
| [2024-11-25 19:00:25] |
| User709203 - Posts: 9 |
|
Hey John,I have managed to display the minimimum and max delta on the spreadsheet formula.The only issue remaining is I cannot add another study onto the chart without my spreadsheet formula displaying zero. Attached below is an image of the results. https://www.sierrachart.com/image.php?Image=1732561142882.png |
| [2024-11-25 21:18:39] |
| John - SC Support - Posts: 36469 |
|
We are not understanding what you are wanting exactly. In your Numbers Bars Calculated Values you already have the Minimum and Maximum Delta. The formulas we gave you with the particular setup will only give you the price point of the Minimum and Maximum Bid or Ask. Taking the delta at those locations does not give the Minimum and/or Maximum delta in the bar. Let us know exactly what you are after and we can help you get there. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-11-27 15:58:06] |
| User709203 - Posts: 9 |
|
In the default spreadsheet study, we have column A with the input of Date and Time, how can I extract only the time in the format of Hour-Minute-Seconds e.g 09:30:00? Secondly, how can I sort data in a descending order with reference to time e.g if the highest volume so for the day has been at 9:36AM.
|
| [2024-11-27 18:46:52] |
| John - SC Support - Posts: 36469 |
|
To get just the Time portion of an item with date and time, use the FRACTIME() function. Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#FRACTIME_Function To display a cell in a Sierra Chart spreadsheet as a Time, you need to change the cell formatting. Refer to the following: Spreadsheet Menu: Spreadsheet >> Number Format There is not a way to sort data in the Sierra Chart spreadsheet studies, as the rows are all relative to the bars in the chart. But if you want to get the time of the highest volume for the day and have that displayed in row 3, then you would enter a formula like the following in an open column: =GETCORRESPONDINGMATCH($F$3:$F$35, 10369, 0, 0, 1, A$3:A$35, 0) Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#GetCorrespondingMatch_Function For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-11-27 20:58:18] |
| User709203 - Posts: 9 |
|
I have inserted this formula =FRACTIME(A3), am still not getting the time in the format I wanted. I just want basic time,not serial time. After inserting this formula =GETCORRESPONDINGMATCH($F$3:$F$35, 10369, 0, 0, 1, A$3:A$35, 0) as you instructed me I get #N/A
|
| [2024-11-27 21:22:17] |
| John - SC Support - Posts: 36469 |
|
As noted, when using "FRACTIME()", you need to set the cell Number Format to be "Time". Refer to the following: Spreadsheet Menu: Spreadsheet >> Number Format Sorry, I was doing some testing and did not give you the right formula. Here is what you would need: =GETCORRESPONDINGMATCH($F$3:$F$35, MAX($F$3:$F$35), 0, 0, 1, A$3:A$35, 0) In the above formula it is checking cells from Row 3 to Row 35. You would need to adjust these to test for the time period you are wanting. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-11-27 21:46:47] |
| User709203 - Posts: 9 |
|
Please give me an example for using when using "FRACTIME()",English is my 3rd language and most of the instructions I find it very computer technical.In this case I want to input the "FRACTIME()" formula in cell R3 Thank you for this formula =GETCORRESPONDINGMATCH($F$3:$F$35, MAX($F$3:$F$35), 0, 0, 1, A$3:A$35, 0),it works perfect. |
| [2024-12-02 16:14:08] |
| John - SC Support - Posts: 36469 |
|
What exactly do you want to see in cell R3? How do you want it displayed?
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: