Cryptosheets

There are several ways to do this depending on:

What specific data source you're using

What version of Excel you have

Whether you're using Excel or Googlesheets

- What specific data source you're using 
- What version of Excel you have
- Whether you're using Excel or Googlesheets

Use Cryptosheets <code>sort</code>  custom functions argument

Use a native data provider's available sorting parameters if available (example: ParadigmAPI)

Use Excel or Googlesheet's native <code>=SORT()</code>   and <code>=SORTBY()</code>  functions to wrap any existing Cryptosheets custom function

1. Use Cryptosheets <code>sort</code>  custom functions argument
2. Use a native data provider's available sorting parameters if available (example: ParadigmAPI)
3. Use Excel or Googlesheet's native <code>=SORT()</code>   and <code>=SORTBY()</code>  functions to wrap any existing Cryptosheets custom function

Example #1: Using Cryptosheets 'sort' Argument

For Cryptosheets <a href="https://app.cryptosheets.com/#/functions/core" rel="nofollow noopener noreferrer" target="_blank">core custom functions</a> (ie CS.OHLCV, CS.ORDERBOOKS etc) there are powerful built in sorting arguments available using the <code>sort</code> argument

➡️ For Excel<code> =CS.OHLCV("BTC","USD","Coinbase","SPOT","1day",,,{"sort","-trades_count"})</code>

➡️ For Google<code> =SORT(CSQUERY("Nomics","dashboard"),3,false)</code>

Example #2: Using A Data Provider's Native Sorting

Some data providers have native sort functionality built into their APIs and endpoints as parameters (ie <a href="https://app.cryptosheets.com/#/browse/Paradigm" rel="nofollow noopener noreferrer" target="_blank">Paradigm</a>). Here's an example (try to copy and paste into your sheet)

=CS.QUERY("Paradigm", "TA Historical", {"symbol","btc";"sort","change50";"order","asc"})&nbsp;

=CSQUERY("Paradigm", "TA Historical", {"symbol","btc";"sort","change1";"order","desc"})

Example #3: Using Excel's =SORT() &amp; =SORTBY() or Google's SORT()

Recently rolled out <a href="https://support.office.com/en-us/article/sort-function-22f63bd0-ccc8-492f-953d-c20e8e44b86c" rel="nofollow noopener noreferrer" target="_blank">new functions from Excel</a> allow powerful and easy sorting of any array by simply using the =SORT()  or =SORTBY()  functions to wrap any existing function including a Cryptosheets custom function

Googlesheets also has <a href="https://support.google.com/docs/answer/3093150?hl=en" rel="nofollow noopener noreferrer" target="_blank">native sorting ability</a> =SORT

- Recently rolled out <a href="https://support.office.com/en-us/article/sort-function-22f63bd0-ccc8-492f-953d-c20e8e44b86c" rel="nofollow noopener noreferrer" target="_blank">new functions from Excel</a> allow powerful and easy sorting of any array by simply using the =SORT()  or =SORTBY()  functions to wrap any existing function including a Cryptosheets custom function
- Googlesheets also has <a href="https://support.google.com/docs/answer/3093150?hl=en" rel="nofollow noopener noreferrer" target="_blank">native sorting ability</a> =SORT

Learn several techniques to dynamically sort your data from custom functions by column or data field

How to Sort your data in Cryptosheets

Sorting methods, tips & tricks

Example #1: Using Cryptosheets 'sort' Argument

Example #2: Using A Data Provider's Native Sorting

Googlesheets

Example #3: Using Excel's =SORT() & =SORTBY() or Google's SORT()