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

VAR

How to use VAR in Excel and Google Sheets

Written by John Young
Updated this week

TSF

How to use TSF in Excel and Google Sheets

Written by John Young
Updated this week

STOCH

How to use STOCH in Excel and Google Sheets

Written by John Young
Updated this week

BETA

How to use BETA in Excel and Google Sheets

Written by John Young
Updated this week

OBV

How to use OBV in Excel and Google Sheets

Written by John Young
Updated this week

RSI

How to use RSI in Excel and Google Sheets

Written by John Young
Updated this week

CORREL

How to use CORREL in Excel and Google Sheets

Written by John Young
Updated this week

ROCR

How to use ROCR in Excel and Google Sheets

Written by John Young
Updated this week

MOM

How to use MOM in Excel and Google Sheets

Written by John Young
Updated this week

MFI

How to use MFI in Excel and Google Sheets

Written by John Young
Updated this week

ROCP

How to use ROCP in Excel and Google Sheets

Written by John Young
Updated this week

ROC

How to use ROC in Excel and Google Sheets

Written by John Young
Updated this week

MACD

How to use MACD in Excel and Google Sheets

Written by John Young
Updated this week

MACDFIX

How to use MACDFIX in Excel and Google Sheets

Written by John Young
Updated this week

CCI

How to use CCI in Excel and Google Sheets

Written by John Young
Updated this week

MACDEXT

How to use MACDEXT in Excel and Google Sheets

Written by John Young
Updated this week

ADX

How to use ADX in Excel and Google Sheets

Written by John Young
Updated this week

SAREXT

How to use SAREXT in Excel and Google Sheets

Written by John Young
Updated this week

TRANGE

How to use TRANGE in Excel and Google Sheets

Written by John Young
Updated this week

EMA

How to use EMA in Excel and Google Sheets

Written by John Young
Updated this week

ATR

How to use ATR in Excel and Google Sheets

Written by John Young
Updated this week

SMA

How to use SMA in Excel and Google Sheets

Written by John Young
Updated this week

DEMA

How to use DEMA in Excel and Google Sheets

Written by John Young
Updated this week

BBANDS

How to use BBANDS in Excel and Google Sheets

Written by John Young
Updated this week

FLOOR

How to use FLOOR in Excel and Google Sheets

Written by John Young
Updated this week

LN

How to use LN in Excel and Google Sheets

Written by John Young
Updated this week

EXP

How to use EXP in Excel and Google Sheets

Written by John Young
Updated this week

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