Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Mon, 13 Jan 2025 18:47:05 +0000

How to Post a Message for Support

Post From: Spreadsheet INDEX function changes on restart

[2017-04-11 02:30:10]
[Go To First Post]
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))