Login Page - Create Account

Support Board


Date/Time: Tue, 28 May 2024 04:22:04 +0000



Spreadsheet auto populate formula isn't working

View Count: 871

[2022-03-01 14:38:18]
user_xyz - Posts: 384
I couldn't find any documentation on this.

I have one spreadsheet if I enter any formula in a cell, it auto populates down the column. On a second spreadsheet I enter a formula it does not populate down the column (just stays in the cell). Then you have to manually copy/paste the formulas down the column.

Is there a setting to turn this on/off?
Date Time Of Last Edit: 2022-03-01 14:38:43
[2022-03-01 17:42:14]
John - SC Support - Posts: 31885
The spreadsheet where the formula auto-populates down a column is one of the Spreadsheet Studies.

The spreadsheet where the formula does not auto-populate down a column is a regular spreadsheet (opened by selecting File >> New Spreadsheet).

This is just the way these different items work. There is no setting to control it.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-03-02 02:56:48]
Sawtooth - Posts: 4011
For the column to auto-populate, you must be on the sheet# that matches the spreadsheet study's Formula Source Sheet Number setting.
[2022-03-02 04:09:49]
user_xyz - Posts: 384
Tom - thank you very much Sheet # was the issue!
[2023-04-27 04:52:01]
Alex Q - Posts: 83
I'm having a similar problem. I renamed the sheet for the sake of organization, however it is no longer auto populating the cells in rows beneath. I've changed "Formula sheet specification type" to name, and then entered the name I have given the sheet, however it is no longer working.
[2023-04-27 14:23:41]
John - SC Support - Posts: 31885
In Cell D1 is information on what is being used for the Formula Sheet. What does this state in your sheet?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-04-28 05:36:26]
Alex Q - Posts: 83
Okay, so I have duplicated the chart that I was working on to a new chart book. I'm using this chart book to backtest, so wanted to make it as lean as possible, only duplicating the chart necessary. However, it will not seem to reference the specified sheet. The spreadsheet study wants to use spreadsheet 1. All of my progress is on spreadsheet 13. Is there a way to copy it all over? changing the "formula sheet number" to the sheet I'm working on seems to have no effect.
imageScreenshot 2023-04-27 at 10.33.28 PM.png / V - Attached On 2023-04-28 05:35:47 UTC - Size: 51.02 KB - 83 views
imageScreenshot 2023-04-27 at 10.34.00 PM.png / V - Attached On 2023-04-28 05:35:51 UTC - Size: 11.51 KB - 74 views
[2023-04-28 14:47:44]
John - SC Support - Posts: 31885
You do not want to have two different charts referencing the same sheet within the spreadsheet, or this will create issues and not give proper results. You can have the same Formula Source, but if you are going to be backtesting/replaying, then this will not work either.

Therefore, you should use a different sheet altogether and copy the formulas from the one sheet to the new one.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-04-28 19:44:51]
Alex Q - Posts: 83
Thanks John. Now, is there a way to duplicate the contents of an entire sheet?
[2023-04-28 20:10:34]
Alex Q - Posts: 83
Also, I'm finding that if I "rename" the sheet, auto-populate ceases to work. I have several sheets in this spreadsheet study, and I'd like to give them names for clarification. The data still shows up on the chart, but it will no longer auto-populate when I add data/formulas to row 3. To be clear there is only one chart referencing this sheet.
[2023-05-01 15:09:15]
John - SC Support - Posts: 31885
It does not work like you are thinking.

When you rename the sheet, it is actually renaming the sheet, but the Spreadsheet Study is still referencing the sheet by the number, so the system creates the new sheet, which is not associated with a study, so it is a "standard" sheet. Meanwhile, the Spreadsheet Study creates a new sheet for its purposes.

Basically you can not rename a sheet when using the Spreadsheet Study. The only way to do this would be to name the Formula Sheet prior to starting the Spreadsheet Study. 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
[2023-05-02 16:47:34]
Alex Q - Posts: 83
Ah, thank you John. I will keep that in mind going forward.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account