Introducing Technical Analysis Functions for Google Sheets™

The Technical Analysis Functions add-on simplifies trading analysis by integrating a library of indicators directly into Google Sheets™ formula system.

Instead of building fragile, multi-step nested formulas, this tool consolidates technical indicators into a comprehensive set of functions. You can calculate an indicator by typing a formula like =RSI(data, period) directly into a cell.

Get Started

Install the Technical Analysis Functions add-on directly from the Google Workspace Marketplace to add the full library of indicators to your Google Sheets.

Important: After installing, Google will ask you to grant the necessary permissions for the script to run. This is a standard, one-time authorization required to activate the functions.

How to Use

Hide Steps

1

Prepare Your Data

Data can be pulled directly with the GOOGLEFINANCE() function or from any other source with standard DOHLCV : [ Date, Open, High, Low, Close, Volume ] formatting.

2

Call the Function

Use the desired indicator formula, like `=RSI(C2:C100,14)` or `=RSI(GOOGLEFINANCE(), 14)`, referencing your data range.

3

View the Output

The indicator values will populate your sheet automatically, formatted in an array style.

Key Features

Indicator Reference

We’ve documented every indicator included in the add-on — complete with input format, example usage, and return behavior.

Install Now

Ready to get started? Install the add-on from the official Google Workspace Marketplace.