Crypto MACD in Google Sheets: line, signal and histogram

By CryptoTrackPro · Published 9 September 2026 · Examples checked against the current formula implementation

CryptoTrackPro returns each MACD component with one formula. Use =cryptotrackproMACD("BTC","line","USD") for the line, change the second argument to "signal" for the signal, or use "histogram" for their difference. The implementation uses daily Kraken candles and fixed 12/26/9 settings. It returns the latest values rather than a historical indicator series.

Set up three explicit output columns

Connect the add-on through Extensions → CryptoTrackPro → Open CryptoTrackPro. MACD requires Base or Pro access, including the 30-day Base trial. Create one row per asset and quote currency, then put the components in separate numeric columns. That makes it easier to inspect what changed without hiding the calculation inside a single colored label.

Use these formulas in the first populated row:

C2: =cryptotrackproMACD(A2,"line",B2)
D2: =cryptotrackproMACD(A2,"signal",B2)
E2: =cryptotrackproMACD(A2,"histogram",B2)

Fill down through your input rows. Use the exact component names above; unsupported component text currently falls back to the line, which could conceal a typo. The examples use comma separators. In a sheet that expects semicolons, use =cryptotrackproMACD(A2;"signal";B2) and make the equivalent change in the other formulas.

Understand the arithmetic before styling the table

The MACD line is the difference between 12-period and 26-period exponential moving averages. The signal is a 9-period exponential moving average of the MACD series. The histogram is the line minus the signal. In the BTC example, 120 minus 150 equals −30. A positive line and negative histogram can therefore appear together without an error.

For a simple cross-check, place =C2-D2 in a spare column and compare it with E2. Outputs are rounded to four decimal places, so a tiny rounding difference is possible. Keep error text visible if an upstream request fails. An unavailable line or signal should not be turned into zero merely to make the table look complete.

MACD values are expressed in price units rather than on a common 0–100 scale. A value of 120 for BTC and 8.5 for ETH does not, by itself, establish which asset has stronger momentum. It also makes a USD value inappropriate to compare directly with an EUR value as if they shared units.

Keep a dated observation log

For a repeatable review, record the asset, quote, three components and observation time together. Copy reviewed values into an archive using Paste special → Values only. A live formula in an old row does not preserve the indicator from that date. Keep the original live table as the place you refresh and the archive as the place you compare observations.

A histogram above zero describes the current relationship between line and signal. Establishing a crossover requires a comparison with an earlier observation; one isolated number cannot establish when that relationship changed. Even a change between snapshots can miss events between those snapshots. Label your notes accordingly instead of treating a spreadsheet refresh as a complete record of market activity.

Match the market and timeframe

The settings are fixed at daily 12/26/9; extra arguments do not enable a custom fast period, slow period or hourly interval. Compare with a daily chart of the same Kraken pair when checking a result. The available indicator pairs are narrower than current-price coverage, and the USD request can use a USDT market if a direct USD pair is unavailable.

The current unfinished candle is included in Kraken's OHLC response and in this implementation's MACD calculation. Values can change during the day; a completed-candles-only chart may differ. Kraken documents the unfinished final candle. The indicator cache is roughly 15 minutes, so a 5-minute Pro sidebar refresh is not a guarantee of a new MACD calculation every time.

Use the RSI guide if you want a separate 0–100 measure alongside this table. For the underlying daily price series, the OHLCV guide explains how to inspect and export candles. Keeping source, units and timeframe visible is more useful than adding another indicator without knowing what it measures.

Frequently asked questions

Can I change the 12/26/9 MACD settings?

The current function uses fixed daily 12/26/9 settings. Its arguments select the asset, returned component and quote currency, not custom MACD periods.

Does a positive histogram mean the MACD line is positive?

No. A positive histogram means the line is above the signal. Both values can still be negative. Inspect the line and signal columns together.

Continue with: Daily RSI watchlist · Formula reference and setup · All guides