Support Board
Date/Time: Tue, 26 Nov 2024 13:42:53 +0000
Spreadsheet
View Count: 249
| [2023-11-22 18:20:25] |
| User175868ZZA - Posts: 21 |
|
How do I see the bid volume and ask volume in this spreadsheet. As I have added the bid and ask studies? Also how can I add a filter to this spreadsheet in picture? Also, how can I export this all as a excel? Date Time Of Last Edit: 2023-11-22 18:23:08
|
Private File |
| [2023-11-22 20:06:55] |
| John - SC Support - Posts: 36286 |
|
Which Bid/Ask volumes are you wanting to see. The actual traded data or the Market Depth data? In terms of added studies, the data for the studies will start in column AA, as long as you have not changed the default Input for the Spreadsheet Study for "Number of Formula Columns". Otherwise, the data will show in the first column after the number of Formula columns. There is not a way to export this to Excel. You would either need to select all the cells and then copy the data to Excel, or you could develop a custom study to take the data and put it in Excel. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-11-22 20:36:08] |
| User175868ZZA - Posts: 21 |
|
I would like to see both - actual traded data & the Market Depth data. & how is a custom study developed & do you how in this spreadsheet, a filter can be added or if you can arrange columns largest to smallest? Date Time Of Last Edit: 2023-11-22 20:36:30
|
| [2023-11-22 20:50:10] |
| John - SC Support - Posts: 36286 |
|
The Market Depth data can be viewed by using the "Depth of Market Data" study. Refer to the information here: Depth of Market Data The actual traded Bid/Ask data, such as what is shown in the Numbers Bars study, is too dense, therefore there is not a way to view it in the Spreadsheet. The only way to access this information is to create a custom study. Refer to the following: Advanced Custom Study Interface and Language (ACSIL) You will also find a list of programmers that you can contact at the following link: List of Third Party Sierra Chart Study and System Programmers There are no filters in the Sierra Chart spreadsheets, but you can "sort" if you are using a standard Spreadsheet and not one of the Spreadsheet Studies. The spreadsheet studies are special, as they contain the data for each bar, so the order is defined by the bars. To sort a column of a standard spreadsheet, have that spreadsheet as the active window and then select "Spreadsheet >> Sort". 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: