Support Board
Date/Time: Sat, 23 Nov 2024 21:02:58 +0000
Spreadsheet column autopopulate
View Count: 166
| [2024-07-29 09:27:30] |
| User299107 - Posts: 55 |
|
Hi guys, not sure what the issue is.. I've looked at the documentation and clearly I've missed something because the autofill of columns is not occurring. I have the same sheet Name and same sheet number as current studies. D1 says Formula. However, entering a new formula in Q3 fails to fill the column. So, if you could show me where I am missing something I would appreciate it. Thanks, Eliza |
| [2024-07-29 17:19:55] |
| John - SC Support - Posts: 36238 |
|
Select cell D1 and tell us what the entire cell states. In the upper left corner is the sheet name - what is the sheet name you are using for this chart? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-07-29 17:48:58] |
| User299107 - Posts: 55 |
|
D1 = Formula Source Sheet #6. Enter and modify formulas for this sheet on Sheet6 Sheet name is myNQIntra.scss |
| [2024-07-29 18:15:29] |
| John - SC Support - Posts: 36238 |
|
The sheet name should not be "myNQIntra.scss". That should be the Spreadsheet name itself that is entered on the Spreadsheet Study Settings Window. On the Spreadsheeet Study settings window, what are the following Inputs set to: - Chart Data Output Specification Type: - Chart Data Output Sheet Number: - Chart Data Output Sheet Name: - Formula Source Sheet Specification Type: - Formula Source Sheet Number: - Formula Source Sheet Name: Also, what is the Chart Number of the chart this spreadsheet study is added to? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2024-07-29 18:15:57
|
| [2024-07-30 13:51:23] |
| User299107 - Posts: 55 |
|
Chart Data Output Specification Type: = By Number - Chart Data Output Sheet Number: = Zero - Chart Data Output Sheet Name:+ Blank - Formula Source Sheet Specification Type: = By Number - Formula Source Sheet Number:= 6 - Formula Source Sheet Name:= Sheet 6 Refers to Chart #3 FYI the Spreadsheet already provides output to the Chart.. I'm just trying to add more |
| [2024-07-30 15:08:11] |
| John - SC Support - Posts: 36238 |
|
You have specifically set "Sheet 6" as the formula source for this chart. Since this chart is Chart #3, the actual sheet from which data will apply to this chart is from "Sheet 3", but in order to enter formulas and have them populate down, you need to enter your formulas on "Sheet 6". The use of a separate formula source sheet gets complicated and requires that you understand what it is doing. If you did not intend for this to occur, then we recommend starting over and not use a Formula Source Sheet. Otherwise, make sure you understand what this does and how it works. Refer to the following: Spreadsheet Study Inputs: Formula Source Sheet Number 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: