Managing risk is a crucial part of trading, and having a stop-loss in place helps you know when to exit a trade. While there’s no perfect stop-loss level, the Average True Range (ATR) offers a way to set dynamic stops based on market volatility.
Stock Price Current Streak (Part 1)
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.
Importing Index Constituents into Google Sheets
Building a robust watchlist is an important step for any trader. It allows for focused analysis and selection of potential trading opportunities. However, manually constructing and maintaining a watchlist can be a time-consuming task. Index constituents offer a valuable solution. These pre-defined lists of established companies from major stock indexes provide a solid foundation for your watchlist creation.
How Standard Deviation Analysis Can Enhance Your Trading
Standard deviation bands go beyond the single-line limit, revealing how price returns distribute. Wider bands signal higher past volatility, while narrow bands suggest consolidation. By observing price action within the bands, you can identify potential breakouts or periods of tight trading, giving context to the current volatility level.
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.
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).
Gravestone Doji Candle Google Sheets Formula
A Gravestone Doji is a candlestick pattern that often indicates a bearish reversal. This pattern is characterized by a long upper shadow and open, close, and low prices that are roughly at the same level, giving it the appearance of an inverted “T” or tombstone.
Dragonfly Doji Candle Google Sheets Formula
A Dragonfly Doji is a candlestick pattern that occurs when the open, close, and high are almost identical, with a long lower wick. The pattern is usually interpreted as a signal of a potential bullish reversal, particularly when it appears following a downtrend.
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.
Simple Moving Average Google Sheets Formula
The moving average is a powerful ally when it comes to gaining a holistic view of the market’s overall trend. In this blog post, we’ll take you through the complete calculation process and introduce you to a valuable tool for monitoring the broader market.
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.
Market Snapshot Part 1: Scatterplot
Analyzing market data through scatterplots can provide a quick and comprehensive overview of the market. This method can help uncover patterns, correlations, and outliers that may have been overlooked when analyzing stocks.
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
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
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.
Month-to-Month Stock Price Return: Google Sheets Formula
The month-to-month return compares the value of a stock at the end of one month to the value of the stock at the end of the previous month.
A Trading Framework for Short-Term Stock Traders: Overview
Learn how to create a structured approach to stock trading with a personal trading framework. Explore the key components of a trading framework, including market selection, watchlist creation, shortlisting potential trades, and executing trades with a defined plan.
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
Normalized ATR Googles Sheets Formula
The Normalized ATR extends the function of the ATR by being able to get a volatility measure that is directly comparable across stocks with different prices. This is accomplished by calculating the ATR as a percentage of the stock price.
Average True Range Google Sheets Formula
The Average True Range is an indicator used to determine stock price volatility; it measures how much price moves on average over a given period. Welles Wilder introduced it in his book “New concepts in technical trading systems.
Standard Deviation of Stock Price Returns Google Sheets Formula
The Standard Deviation of Daily Price Returns is a statistical measure representing the volatility or risk in an instrument. It tells you how the daily price return can deviate from the historical mean.
Stock Price Daily Range Google Sheets Formula
The” range” forms the fabric of market structure as we know it. Being able to identify and use it within the daily-price context proves itself as a great tool.
YTD ( Year-To-Date) Google Sheets Formula
YTD stands for “Year-To-Date” and refers to the period of time from the beginning of the current calendar year to the present date. It is used to track and measure the performance of investments, such as stocks, over the course of the year.
52-Week Range Google Sheets Formula
Learn how to use the 52-week range and current price relative to 52-week range metrics to evaluate the performance and volatility of stocks. This guide explains the calculation of the 52-week range and provides a formula for calculating the current price relative to this range in Google Sheets.
Narrow Range 7 (NR7) Google Sheets Formula
The Narrow Range 7 pattern arises when a price has the smallest range between high and low compared to the previous seven daily prices. Our comprehensive tutorial teaches how to identify this pattern using Google Sheets.
Inside Day NR4 (ID/NR4) Google Sheets Formula
Learn how to identify the powerful ID-NR4 pattern using Google Sheets in this step-by-step tutorial. Enhance your trading strategy by combining Inside Day and Narrow Range 4 patterns, and unlock potential breakout opportunities with our easy-to-follow guide.
Inside Day Price Pattern Google Sheets Formula
Learn about the Inside Day pattern and its application in trading using Google Sheets formulas. Learn how understanding the pattern and the surrounding price structure can assist in predicting market movements and seizing potential opportunities.
How to Request Historical Data from Google Finance
Looking to retrieve, organize, and manipulate data using Google Finance? This comprehensive guide is just what you need. Learn the essential techniques for requesting historical data from Google Finance.