Tag: Formulas

Explore a collection of custom formulas designed to enhance your data analysis in Google Sheets. Simplify complex calculations and streamline your workflow with ease

Momentum Trend

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.

Momentum

Relative Strength Index (RSI) Google Sheets Formula

The Relative Strength Index (RSI) is a momentum oscillator introduced by J. Welles Wilder in 1978 to detect price extremes in markets. It measures asset strength on a 0-100 scale, highlighting potential reversals when above 70 (overbought) or below 30 (oversold).

Price Patterns

Doji Candle Google Sheets Formula

The Doji candlestick is a pattern where the opening and closing prices are very close or almost the same. This pattern is significant because it can indicate moments of indecision among traders, which often occur at critical points such as the top or bottom of a range, the end of a trend, or around key support and resistance levels.

Analysis

Market Snapshot Part 2: Current Price

Observing the current price of a stock within a broader context is crucial for effective trading. While the current price offers a snapshot of value, it alone is insufficient for informed decision-making. By examining additional factors like price change, volatility, and momentum, a more comprehensive understanding of the current price behavior can be obtained.

Momentum

Using Price Range to Gauge Intraday Performance

Using the current price relative to daily true range indicator can provide valuable insights into a stock’s performance throughout the day. In this blog post, we explore how to use this tool to monitor a stock’s intraday performance, identify bullish or bearish signals, and gain a more comprehensive understanding of short-term price dynamics

Momentum

Week-to-Date Stock Price Return: Google Sheets Formula

Stock price Week-to-Date (WTD) return is a measure of the change in a stock’s price from the beginning of the current trading week to the current date. The WTD return is calculated by subtracting the stock’s previous week’s closing price from its current price and then dividing the result by the previous week’s closing price. The result is then expressed as a percentage, representing the stock’s WTD return

Momentum

Month-to-Date (MTD) Stock Price Return: Google Sheets Formula

Month-to-date (MTD) stock price return is the percentage change in the stock price from the beginning of the current month to the current date. It is calculated by taking the difference between the stock price at the current date and the stock price at the previous month’s close and dividing that amount by the stock price at the previous month’s close.

Volatility

Volatility Spike Indicators Google Sheets Formulas – Sigma Spike & Range Spike

Using price volatility to measure price moves is based on the fact that daily price returns are meaningless without context. Therefore, short-term price history is required to understand the significance of a price change

Back To Top