This is another way to deal with SC’s descending order spreadsheet studies, different from using the INDEX(…MATCH…)) function combination.

It is an expansion of the concept in SC’s documentation, without having to manually enter a formula in every cell:

 http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetAdditionalInfo.html#ReversingChartOrder

1) Put this in cell Z3:

=$J$30-ROW()+3

2) Put this in cell Y3:

=INDEX(A$3:OFFSET(A$3,$J$30-1,0),Z3,1)

This example sorts the Date-Time of column A in ascending order in column Y, but it works with any column.