Ichimoku Cloud

The Ichimoku Cloud (Ichimoku Kinko Hyo) is a versatile indicator that defines support and resistance, identifies trend direction, gauges momentum, and provides trading signals. It consists of five lines: Tenkan-sen (Conversion Line), Kijun-sen (Base Line), Senkou Span A (Leading Span A), Senkou Span B (Leading Span B), and Chikou Span (Lagging Span).

ICHIMOKU

=ICHIMOKU(data, tenkanPeriod, kijunPeriod, senkouBPeriod)

Example Usage

=ICHIMOKU(A2:F500, 9, 26, 52)

Parameters

Parameter Type Description Status
data
Range
The input range of columns containing the Date, Open, High, Low, Close, and Volume data.
 Required
tenkanPeriod
Number
The period for the Tenkan-sen (Conversion Line). Default is 9.
 Optional
kijunPeriod
Number
The period for the Kijun-sen (Base Line). Default is 26.
 Optional
senkouBPeriod
Number
The period for the Senkou Span B (Leading Span B). Default is 52.
 Optional

Returns

A multi-column array containing:

  1. Date
  2. Tenkan-sen: (Highest High + Lowest Low) / 2 for the past tenkanPeriod.
  3. Kijun-sen: (Highest High + Lowest Low) / 2 for the past kijunPeriod.
  4. Senkou Span A: (Tenkan-sen + Kijun-sen) / 2, plotted 26 periods ahead.
  5. Senkou Span B: (Highest High + Lowest Low) / 2 for the past senkouBPeriod, plotted 26 periods ahead.
  6. Chikou Span: Closing price plotted 26 periods behind.
Ichimoku Cloud Formula Result in Google Sheets