Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 02:46:40 +0000

How to Post a Message for Support

Post From: A question and a request related to spreadsheets

[2020-06-26 12:02:19] Link To Thread - Link To Post [Go To First Post]
User247273 - Posts: 37
First off, let me say that I think Sierra's spreadsheet capability is great. It's one of many reasons I choose to pay for Sierra in spite of owning a lifetime license for Ninjatrader 8. You people make a great product. I was reading the help files on reversing the order of data in a spreadsheet here. Spreadsheet Studies Special Tasks: Reversing The Order Of Chart Data In The Spreadsheet and I noticed the comment at the end, "We plan to offer a feature in an upcoming version to reverse the order of the chart data outputted to a Spreadsheet." Not knowing how long ago that was written, I was just wondering if that feature is more likely to be a long way off or might it be something we see in the next 6 - 12 months or so? I've set up a spreadsheet to reverse the order of the data, but its extremely cumbersome with many columns full of formulas using INDIRECT and CONCATENATE functions. I'm looking forward to being able to manage this more efficiently. Also, I'd like to put my vote in for the addition of COUNTIF and SUMIF spreadsheet functions. I can't use helper columns to accomplish this because I need to run a column of COUNTIFS against hundreds of values in a column of variables which changes in length on every bar update (ex. =COUNTIF(K:K,J3), =COUNTIF(K:K,J4),etc...) COUNTIF Description https://support.microsoft.com/en-ie/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34?ui=en-us&rs=en-ie&ad=ie SUMIF Description https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b