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.
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).
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.
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.
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.