Custom Functions

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

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

Cryptosheets Custom Functions (aka formulas) - Excel vs Googlesheets

Using Cryptosheets custom functions in Excel vs Googlesheets is almost exactly the same with a few very slight differences.

C

Written by Chris Ware
Updated over a week ago

VAR

How to use VAR in Excel and Google Sheets

Written by John Young
Updated over a week ago

TSF

How to use TSF in Excel and Google Sheets

Written by John Young
Updated over a week ago

STOCH

How to use STOCH in Excel and Google Sheets

Written by John Young
Updated over a week ago

BETA

How to use BETA in Excel and Google Sheets

Written by John Young
Updated over a week ago

OBV

How to use OBV in Excel and Google Sheets

Written by John Young
Updated over a week ago

RSI

How to use RSI in Excel and Google Sheets

Written by John Young
Updated over a week ago

CORREL

How to use CORREL in Excel and Google Sheets

Written by John Young
Updated over a week ago

ROCR

How to use ROCR in Excel and Google Sheets

Written by John Young
Updated over a week ago

MOM

How to use MOM in Excel and Google Sheets

Written by John Young
Updated over a week ago

MFI

How to use MFI in Excel and Google Sheets

Written by John Young
Updated over a week ago

ROCP

How to use ROCP in Excel and Google Sheets

Written by John Young
Updated over a week ago

ROC

How to use ROC in Excel and Google Sheets

Written by John Young
Updated over a week ago

MACD

How to use MACD in Excel and Google Sheets

Written by John Young
Updated over a week ago

MACDFIX

How to use MACDFIX in Excel and Google Sheets

Written by John Young
Updated over a week ago

CCI

How to use CCI in Excel and Google Sheets

Written by John Young
Updated over a week ago

MACDEXT

How to use MACDEXT in Excel and Google Sheets

Written by John Young
Updated over a week ago

ADX

How to use ADX in Excel and Google Sheets

Written by John Young
Updated over a week ago

SAREXT

How to use SAREXT in Excel and Google Sheets

Written by John Young
Updated over a week ago

TRANGE

How to use TRANGE in Excel and Google Sheets

Written by John Young
Updated over a week ago

EMA

How to use EMA in Excel and Google Sheets

Written by John Young
Updated over a week ago

ATR

How to use ATR in Excel and Google Sheets

Written by John Young
Updated over a week ago

SMA

How to use SMA in Excel and Google Sheets

Written by John Young
Updated over a week ago

DEMA

How to use DEMA in Excel and Google Sheets

Written by John Young
Updated over a week ago

BBANDS

How to use BBANDS in Excel and Google Sheets

Written by John Young
Updated over a week ago

FLOOR

How to use FLOOR in Excel and Google Sheets

Written by John Young
Updated over a week ago

LN

How to use LN in Excel and Google Sheets

Written by John Young
Updated over a week ago

EXP

How to use EXP in Excel and Google Sheets

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