Description
The weekly return is a financial metric that measures the percentage change in the price of a stock over one week. It provides insights into the performance and volatility of the stock within a week.
WEEK-TO-DATE FORMULA
The week-to-date (WTD) formula for stock prices calculates the cumulative return of a stock from the beginning of the current week until the present day. It is calculated by subtracting the previous week’s closing price from the current day’s closing price and then dividing the result by the previous week’s closing price.
The formula can be represented as follows:
WTD = ((Current Day’s Closing Price – Previous Week’s Closing Price) / Previous Week’s Closing Price) * 100
Which can be simplified to:
WTD = (Current Close Price / Previous Week’s Close Price) – 1
=TO_PERCENT(GOOGLEFINANCE(B1,"price")/QUERY(GOOGLEFINANCE(B1
,"close",(TODAY()-WEEKDAY(TODAY()))-5,(TODAY()-WEEKDAY(TODAY()))),"SELECT Col2 ORDER BY Col1 DESC LIMIT 1 LABEL Col2 ''")-1)WEEK-TO-WEEK FORMULA
The week-to-week (WTW) formula for stock prices compares the closing price of a stock at the end of one week to the closing price at the end of the previous week. It calculates the percentage change in the stock’s price over the span of one week. The formula subtracts the previous week’s closing price from the current week’s closing price, divides it by the previous week’s closing price, and expresses the result as a percentage.
The Week-to-Week (WTW) formula for stock prices can be expressed as follows:
WTW = ((Current Week’s Closing Price – Previous Week’s Closing Price) / Previous Week’s Closing Price) * 100
Which can be simplified to:
WTW = (Current Week’s Closing Price / Previous Week’s Closing Price) – 1
=TO_PERCENT(QUERY(GOOGLEFINANCE(A2,"close",(TODAY()-WEEKDAY(TODAY()))-5,(TODAY()-WEEKDAY(TODAY()))),"SELECT Col2 ORDER BY Col1 DESC LIMIT 1",0)/QUERY(GOOGLEFINANCE(A2,"close",(TODAY()-WEEKDAY(TODAY())-7)-5,(TODAY()-WEEKDAY(TODAY())-7)),"SELECT Col2 ORDER BY Col1 DESC LIMIT 1",0)-1)SPREADSHEET
The spreadsheet monitors the weekly returns of stocks listed on the S&P100 index. The current week’s returns are recorded in Column C using the WTD (Week-to-Date) formula, while Columns D to F utilize the WTW (Week-to-Week) formula to track the returns of the previous weeks.
