Support Board
Date/Time: Thu, 28 Nov 2024 16:51:36 +0000
Post From: Help with spreadsheet functions
| [2023-04-21 20:28:56] |
| John - SC Support - Posts: 36350 |
|
The problem is this particular entry: E3:E11-AVERAGE(E3:E12) And others like it. You can not subtract a single value that results from the Average from a range. We are very surprised that this works in Excel, but we did try it and it does do it - but the Sierra Chart Spreadsheet can not do this. You would have to subtract the Average from each item in the Range first and have that in another column, then you can perform the SUMPRODUCT() on the new set of Ranges. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |