Current streak” in trading refers to the consecutive days a stock’s price consistently moves in the same direction, either rising or falling. In Part 1 of this series, we will explain how to calculate these streaks using Google Apps Script. We’ll cover formula creation and provide a watchlist template.
Importing TradingView Watchlist Into Google Sheets
TradingView is great for technical analysis, while Google Sheets is powerful for data manipulation. This post explains how to connect the two using a custom Apps Script function. It retrieves symbols from a shared TradingView watchlist and imports them into Google Sheets.
Moving Average Convergence/Divergence (MACD) Google Sheets Formula
The Moving Average Convergence Divergence (MACD) is a momentum indicator created by Gerald Appel in the late 1970s, comprising the MACD line, the signal line, and a histogram. It’s used by traders to spot buy/sell signals, trend direction, and momentum strength. The MACD chart aids in identifying market moves, while divergence, dramatic rises, and convergence provide additional market insights.
Exponential Moving Average (EMA) Google Sheets Custom Function
An Exponential Moving Average (EMA) is a moving average that places a greater weight and significance on more recent data points when compared to Simple Moving Averages (SMAs) which treat all data points equally.