Support Board
Date/Time: Mon, 13 Jan 2025 11:36:00 +0000
Spreadsheet INDEX function changes on restart
View Count: 977
| [2017-04-11 02:30:10] |
| User161390 - Posts: 16 |
|
I have this formula that does what I expect and seems to work properly: =AVERAGE(INDEX(E:E,ROW()+L3), INDEX(E:E,ROW()+L3*2), INDEX(E:E,ROW()+L3*3), INDEX(E:E,ROW()+L3*4), INDEX(E:E,ROW()+L3*5)) After restarting Sierra Chart, the formula changes to this and all values show as #NUM! until I change it back to the above correct formula: =AVERAGE(INDEX(E@$1:E@$999999,ROW()+L3), INDEX(E@$1:E@$999999,ROW()+L3*2), INDEX(E@$1:E@$999999,ROW()+L3*3), INDEX(E@$1:E@$999999,ROW()+L3*4), INDEX(E@$1:E@$999999,ROW()+L3*5)) |
| [2017-04-11 04:19:44] |
| |
|
We will be looking into this next week.
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, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-04-18 23:38:52] |
| Jeffrey - Posts: 2194 |
|
I have not been able to reproduce this issue on a blank spreadsheet. Everything seems to be working as expected with the latest version of Sierra Chart. If you are still having an issue, please provide your spreadsheet, and let us know which cell you are setting to this formula, so that we can see what you're seeing.
|
| [2017-04-21 03:08:29] |
| User161390 - Posts: 16 |
|
I have attached the spreadsheet. Column M is the formula column. It is currently in the messed up state because I had to restart Sierra Chart
Date Time Of Last Edit: 2017-04-21 03:08:58
|
Private File |
| [2017-04-21 17:42:46] |
| User161390 - Posts: 16 |
|
When I fixed it after restarting today, I noticed that the formula had completely changed to point to Q column instead of E column. The correct column is E as in my example in the first post. Sierra is definitely changing this on every restart
|
| [2017-04-21 18:02:41] |
| |
|
We are looking into this.
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, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-04-25 17:52:44] |
| Jeffrey - Posts: 2194 |
|
Thank you for providing the sheet and formula. These issues should be fixed in the next version (1549). Once you have updated, you will need to set the formula one more time, and then save the spreadsheet. After that point, the formula should remain stable.
|
To post a message in this thread, you need to log in with your Sierra Chart account: