Support Board
Date/Time: Fri, 29 Nov 2024 18:48:29 +0000
Spreadsheet study glitch - Data not being dragged across rows
View Count: 414
| [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: 36350 |
|
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
|
 MicrosoftTeams-image (1).png / V - Attached On 2023-01-20 13:09:50 UTC - Size: 176.29 KB - 104 views Attachment Deleted. |
| [2023-01-20 13:40:21] |
| Sierra_Chart Engineering - Posts: 17233 |
|
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: 17233 |
|
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: