Home >> Support Board

Support Board

Date/Time: Mon, 06 May 2024 17:59:07 +0000

How to Post a Message for Support

Spreadsheet format question

View Count: 725

[2019-07-05 11:14:44] #1 [Go To First Post]
grantx - Posts: 244
See screenshot: 1. Why do I get this red tag on my formulas? 2. Column I containing fixed data. How do I remove the gaps so that information is compressed.at the top? I am quite enjoying the spreadsheet functionality. Way easier than the SQL Ive been using.


2019-07-05_12-07-30.png / V - Attached On 2019-07-05 11:11:11 UTC - Size: 121.48 KB - 253 views

[2019-07-08 14:43:57] #2 [Go To First Post]
John - SC Support - Posts: 31401
1. The red tag just means that there is a formula in the cell, rather than just static data. Refer to this section of the documentation that states this: Working with Spreadsheets: Formulas 2. It is not possible to change the data in columns J and I. These are fixed by the program. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2019-07-08 15:45:30] #3 [Go To First Post]
bradh - Posts: 854
It is not possible to change the data in columns J and I. These are fixed by the program. I think you are saying you cannot change the cell functions in J and I, so you cannot remove spaces or change the location of these cells, as they are "special" system functions. The cells in Column J marked "Read/Write" in Column I can have their values changed. For example, J26 controls Order Size. It is normally 1 unless a positive value is saved in the cell. Only the cells labeled "Read-Only" cannot have their values changed. Date Time Of Last Edit: 2019-07-08 15:47:59

[2019-07-08 16:38:16] #4 [Go To First Post]
grantx - Posts: 244
Another question. Im struggling to understand the Formula Source Sheet functionality. On my spreadsheet, it says: 'Formula Source Sheet #1. Enter and modify formulas for this sheet on Sheet1' So I go to sheet 1 and enter a formula into column K (=C3-D3) I then go back to my charts spreadsheet and notice that the formula hasn't copied over. I have a bunch of different sheets. The formula has not copied across to any of them. I am trying to understand this help file but Im not getting it. Spreadsheet Study Inputs: Formula Source Sheet Number Date Time Of Last Edit: 2019-07-08 16:41:04


Gold_Spreadsheet_Study_Settings.png / V - Attached On 2019-07-08 16:38:06 UTC - Size: 59.8 KB - 244 views Gold_Spreadhseet_Study.png / V - Attached On 2019-07-08 16:40:08 UTC - Size: 51.93 KB - 238 views Sheet1_study_Settings.png / V - Attached On 2019-07-08 16:41:01 UTC - Size: 17.24 KB - 248 views

[2019-07-08 21:29:55] #5 [Go To First Post]
John - SC Support - Posts: 31401
With respect to Post #3, you are correct. I was stating that you cannot change the order of the data in those rows - in other words, you cannot delete the empty rows. They are fixed by the program. As stated in that post, you can modify any data in column I that is Read/Write. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2019-07-08 22:09:20] #6 [Go To First Post]
John - SC Support - Posts: 31401
With respect to post #4: What you are doing should work. Can you please attach your Chartbook that contains the charts you are working with this post following these instructions: Support Board Posting Information: Providing Chartbook with Only a Single Chart For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2019-07-09 07:22:42] #7 [Go To First Post]
grantx - Posts: 244
Files attached. Date Time Of Last Edit: 2019-07-09 07:23:17


Private File Private File

[2019-07-09 23:01:43] #8 [Go To First Post]
John - SC Support - Posts: 31401
The problem was that when using a Named Sheet along with a Formula Sheet Number, the Formula Sheet Number was the same as the Chart Number, which resulted in the data not copying over. This will be fixed in the next release. In the meantime, you can work around the issue by simply changing the Formula Source Sheet Number to something other than 1 in this particular case. 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: