Login Page - Create Account

Support Board


Date/Time: Sat, 22 Jun 2024 12:19:16 +0000



Spreadsheet study glitch - Data not being dragged across rows

View Count: 303

[2023-01-16 14:03:34]
User140688 - Posts: 13
While using spreadsheet study, I am entering a formula in row L3, and the formula is not getting dragged across the entire column L, e.g the change made in formula in cell L3 is not being transferred to L4 and to fix this I have to restart sierra everytime, Kindly help or give an easier way to do so
[2023-01-16 18:06:17]
John - SC Support - Posts: 32515
Are you definitely using a Spreadsheet Study and not just a regular spreadsheet? The regular spreadsheets do not have the "Calculation Columns" that copy the formula all the way down the column.

If you have a proper Spreadsheet Study, then check the Input for Number of Formula Columns and ensure this is at least 2. It is set to 16 by default, making the formula columns from K through Z. It would need to be at least 2 to make the L column a formula column.

If the above do not do it, then we would need to see the spreadsheet and the chart in its own chartbook in order to take a look. Refer to the following 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
[2023-01-20 13:10:31]
User140688 - Posts: 13
Kindly check this screenshot, I believe the settings are just fine
imageMicrosoftTeams-image (1).png / V - Attached On 2023-01-20 13:09:50 UTC - Size: 176.29 KB - 72 views
Attachment Deleted.
[2023-01-20 13:40:21]
Sierra_Chart Engineering - Posts: 15034
Formula Source Sheet Number input is set to 2. It needs to be set to 1.

Refer to:
Spreadsheet Study Inputs: Formula Source Sheet Number
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-01-23 12:32:49]
User140688 - Posts: 13
Why are the other columns being dragged with this setting and not just the sell one?
[2023-01-23 14:52:29]
Sierra_Chart Engineering - Posts: 15034
This is not clear for us. What other columns are you referring to?
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

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