Support Board
Date/Time: Sat, 23 Nov 2024 19:47:56 +0000
spreadsheet help
View Count: 140
| [2024-08-05 17:49:24] |
| User411320 - Posts: 289 |
|
Hello, I'm copying the numbers from the exponential moving average spreadsheet but when I do it just becomes a column of 1. attached are photos. please advise. thanks |
 Screenshot 2024-08-05 133331.png / V - Attached On 2024-08-05 17:49:11 UTC - Size: 11.8 KB - 32 views Screenshot 2024-08-05 134851.png / V - Attached On 2024-08-05 17:49:17 UTC - Size: 1.94 KB - 35 views |
| [2024-08-05 18:28:33] |
| John - SC Support - Posts: 36238 |
|
You are copying into a "Calculation" column in one of the Spreadsheet Studies. As such, whatever is entered for the first value is copied down throughout the column. If you need to use a Spreadsheet Study, then make sure you are not copying into a calculation column. The "Number of Formula Columns" is an Input on the Spreadsheet studies that you can change, by default the value of 16 puts formula columns out to the 'Z' column. Also, be aware that when you add studies to the chart, then the data for these will start populating in the first non-formula column, so you need to take this into consideration as well for where you would put the data. If you do not need a spreadsheet study for what you are doing, then you can open a "simple" Sierra Chart spreadsheet by selecting "File >> New Spreadsheet". 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: