Custom Functions

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

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

What's the difference between CS.EXRATE vs. CS.PRICE vs. CS.PRICEA?

Learn the differences between CS.EXRATE vs CS.PRICE vs. CS.PRICEA and when to use each one.
C
Written by Chris Ware
Updated over a week ago

CS.PRICE or CSPRICE - Pull Current & Historical Price Data for any pair across any exchange in Cryptosheets using custom functions

How to use =CS.PRICE or =CSPRICE in Cryptosheets for Excel of Googlesheets
C
Written by Chris Ware
Updated over a week ago

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
Technical Indicators

VAR

How to use VAR in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

TSF

How to use TSF in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

STOCH

How to use STOCH in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

BETA

How to use BETA in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

OBV

How to use OBV in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

RSI

How to use RSI in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

CORREL

How to use CORREL in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

ROCR

How to use ROCR in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

MOM

How to use MOM in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

MFI

How to use MFI in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

ROCP

How to use ROCP in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

ROC

How to use ROC in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

MACD

How to use MACD in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

MACDFIX

How to use MACDFIX in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

CCI

How to use CCI in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

MACDEXT

How to use MACDEXT in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

ADX

How to use ADX in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

SAREXT

How to use SAREXT in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

TRANGE

How to use TRANGE in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

EMA

How to use EMA in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

ATR

How to use ATR in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

SMA

How to use SMA in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

DEMA

How to use DEMA in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

BBANDS

How to use BBANDS in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

FLOOR

How to use FLOOR in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

LN

How to use LN in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

EXP

How to use EXP in Excel and Google Sheets
John Young avatar
Written by John Young
Updated over a week ago

Technical Indicator Custom Functions in Cryptosheets

Learn how to use dozens of powerful technical indicators on any crypto data with simple formulas in Excel & Googlesheets.
C
Written by Chris Ware
Updated over a week ago