Custom Functions

Learn how to use Cryptosheets custom function formulas to query and build custom datasets from any source

John Young avatar C
9 articles in this collection
Written by John Young and Chris Ware

How to Automatically Refresh Cryptosheets Custom Functions Data in Excel & Googlesheets using CS.TIME

Learn how to refresh any Cryptosheets custom function dataset (aka formula) using one single formula
C
Written by Chris Ware
Updated over a week ago

How to Troubleshoot Custom Function Authentication Errors

Authentication tokens are 'cached' which can result in error messages incorrectly displaying and may require some additional refresh steps
C
Written by Chris Ware
Updated over a week ago

How to Sort your data in Cryptosheets

Learn several techniques to dynamically sort your data from custom functions by column or data field
C
Written by Chris Ware
Updated over a week ago

How to use =CS.TA custom function for quick technical analysis data

The shortest article you’ll ever read about Crypto Technical Analysis and how to get the data in Cryptosheets in seconds
C
Written by Chris Ware
Updated over a week ago

CS.QUERY - Pull any data available on the Cryptosheets platform into your worksheets with formulas

Learn how to use Cryptosheets custom functions (aka formulas) to create powerful worksheets, models and more
C
Written by Chris Ware
Updated over a week ago

Date Formatting with Custom Functions

Learn how to quickly format the datetime output into over 50 different formats in 2 seconds using formatDates
C
Written by Chris Ware
Updated over a week ago

CS.OHLCV - Pull Historical OHLCV Data in Cryptosheets using custom functions

Pull 100,000+ rows of OHLCV data from over 11,000 symbols directly into Excel & Googlesheets using =CS.OHLCV
John Young avatar
Written by John Young
Updated over a week ago

Custom Functions Query Builder Template

Get started quick using the Query Builder template in to create customized queries for any provider, endpoint or dataset
C
Written by Chris Ware
Updated over a week ago

Real-time Streaming Crypto Data in Cryptosheets with CS.EXRATE

Learn how to use real-time streaming crypto data in your Excel & Google spreadsheets using the Cryptosheets =CS.EXRATE() custom function
C
Written by Chris Ware
Updated over a week ago