Custom Functions

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

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

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