Support Board
Date/Time: Sun, 12 Apr 2026 05:03:43 +0000
Post From: Problem with Spreadsheet Study (OTHER SHEETS BEHAVE DIFFERENTLY!)
| [2026-04-11 20:30:37] |
| TopGunTrader - Posts: 292 |
|
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 - 2 views ScreenB.png / V - Attached On 2026-04-11 20:27:27 UTC - Size: 56.39 KB - 2 views |