Introducing Technical Analysis Functions for Google Sheets™

technical analysis functions overview

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.

Pricing & Licensing

The Technical Analysis Functions add-on is free to install and includes 14 foundational indicators forever. For access to our complete library of 40+ indicators and advanced functional updates, you can upgrade to a Pro License.

  • Free Tier: 14 Indicators (SMA, EMA, RSI, MACD, ATR, and more)
  • Pro Tier: Full 40+ Indicator Library, Special Patterns, and Priority Support.

Upgrade to Pro License

14 Indicators Free Forever

Key Features

Native Formula Syntax

Use functions like =ATR() with the same simple syntax as any built-in Sheets function.

Automatic Array Output

A single formula returns a full historical array, instantly populating your columns.

Flexible Data Input

Works with any data source that provides an DOHLCV format, giving you full control.

Live Data Compatibility

Analyze markets in real-time by integrating with live data from =GOOGLEFINANCE().

How to Use

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.
A spreadsheet showing columns for OHLCV data.

Call the Function

Use the desired indicator formula, like `=RSI(C2:C100,14)` or `=RSI(GOOGLEFINANCE(), 14)`, referencing your data range.
A spreadsheet cell with the custom RSI function.

View the Output

The indicator values will populate your sheet automatically, formatted in an array style.
A spreadsheet showing the calculated indicator values.

Indicator Reference

Explore our complete documentation for every indicator, featuring input formats, examples, and return behaviors.

Browse Library

Install Now

Ready to get started? Institutional analysts use this add-on to streamline their workflow directly in Google Sheets™.

Marketplace Link