Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 09:50:29 +0000



Spreadsheet study - missing date time info

View Count: 280

[2023-12-19 16:57:26]
User887126 - Posts: 66
Hello SC team,

Please review and advise my 3 question below regarding spreadsheet study.

1) If if based my spreadsheet study on main graph, i am able to see date/time information on the spreadsheet.

However, if i based it on number bars calculated value, i am not seeing the date/time information on the spreadsheet.

Is there a way to show it on there?

2) I want to see the just the spreadsheet but do not want actual graph of study in my chart. Is there a way to remove it?

3) What is the fastest way to export scss file to excel format?
[2023-12-19 19:30:03]
John - SC Support - Posts: 36286
1. Do not do this. You want to have the Spreadsheet Study "Based On" the Main Price Graph. Keep in mind that any other study that is on the chart will have the data in the spreadsheet starting at column AA (depending on the number of Calculation Columns you define in the Inputs). You can then reference the Numbers Bars Calculated Values from within the Spreadsheet using the IDx.SGy@# format. Refer to the following:
Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study

2. Set the "Spreadsheet Study" to hidden. Refer to the following:
Chart Studies: Settings and Inputs Tab >> Hide Study

3. Refer to the following and the section below it:
Working with Spreadsheets: Saving a Sheet in Text Format
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:

Login

Login Page - Create Account