Support Board
Date/Time: Sun, 31 May 2026 06:51:02 +0000
Problem with Spreadsheet Study (OTHER SHEETS BEHAVE DIFFERENTLY!)
View Count: 180
| [2026-04-11 20:30:37] |
| TopGunTrader - Posts: 313 |
|
Hi, I really enjoy using Spreadsheet study I create statistics and have been posting them into spreadsheet to then display for example 1m statistical highs/lows, 5m, 15, 30 etc. When I paste DATA into say Row K3 it pastes all the other columns and well AND this is key that same data is below in next row and next and next all the way down! But when I paste data into another sheet which I plan to use in my main sheet to display on chart it DOES NOT COPY THAT DATA TO ALL ROWS BELOW! I just assumed all sheets would behave like ORIGINAL one. I feel I wasted entire Saturday recreating my stat spreadsheet as I assumed and WANT my data to be on multiple rows. You can see the problem on ScreenB pic I take the OPEN data in this spreadsheet and subtract the daily stat value in DATA sheet and its correct but FOR ONLY ONE ROW since that data isn't on the row down in DATA the next value is WRONG as its subtracting 0 there's nothing in the DATA sheet one row down. HOW CAN I PASTE DATA IN another sheet and have THE SAME BEHAVIOR as the main sheet ie when pasting in values it duplicates those values in EVERY ROW BELOW! Please let me know how to fix this I need to paste in stat data into another sheet and use that for main sheet to calculate and display levels on my chart but its broken now. All sheets should behave the same way. |
 ScreenA.png / V - Attached On 2026-04-11 20:26:20 UTC - Size: 24.8 KB - 30 views ScreenB.png / V - Attached On 2026-04-11 20:27:27 UTC - Size: 56.39 KB - 27 views |
| [2026-04-11 20:34:40] |
| TopGunTrader - Posts: 313 |
|
To recap the behavior on main sheet and OTHER sheets is different. In main sheet I take a row of values from excel copy and paste and it DUPLICATES this row into all of them 50 rows down has same values. On other sheets when I do this it ONLY PASTES ROW DATA INTO ONE ROW. I want to paste the data into EVERY ROW same exact behavior as main sheet! |
| [2026-04-11 20:56:52] |
| TopGunTrader - Posts: 313 |
|
It occurred to me I can create a macro to paste the data into say 100 rows but I don't think I should have to other sheets should have same behavior.
|
| [2026-04-11 21:28:37] |
| Sierra_Chart Engineering - Posts: 23895 |
|
Refer to: Working with Spreadsheets: Filling Cells with Value or Formula 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 |
| [2026-04-13 22:11:00] |
| TopGunTrader - Posts: 313 |
|
Can you guys A) Increase COLUMNS up to 150 or B) To study RELATIVE VOLUME - Add Volume Avg Type = Avgerage volume + Std with extra field for standard deviations of the data so I don't have to create my own ACCURATE stats in Excel and import into Spreadsheet Study anymore. |
| relative_volume.png / V - Attached On 2026-04-13 22:08:09 UTC - Size: 52.02 KB - 15 views |
| [2026-04-14 14:31:08] |
| John - SC Support - Posts: 46361 |
|
We have noted these as Feature Requests. We can not say when we would get to any particular request.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-04-14 23:36:44] |
| Sawtooth - Posts: 4332 |
|
Increase COLUMNS up to 150
In the meantime, you could use two instances of the Spreadsheet Study study because this study outputs its subgraphs which can be seen by the each other.
Date Time Of Last Edit: 2026-04-14 23:37:26
|
To post a message in this thread, you need to log in with your Sierra Chart account: