DESCRIPTION
Yearly Returns refer to the percentage change in the price of a stock over a specific calendar year. It provides an insight into the price performance within that period. There are two common approaches to calculating yearly returns: Year-to-Date (YTD) and Year-to-Year (YTY).
YEAR-TO-DATE
Year-to-Date (YTD) return measures the performance of a stock from the beginning of the calendar year up to the current date. It provides insight into how the stock has performed during the current year and helps investors assess its progress over a specific time period.
=TO_PERCENT(GOOGLEFINANCE(B1)/QUERY(GOOGLEFINANCE(B1,"Close",DATE(YEAR(TODAY())-1,12,31)-5,DATE(YEAR(TODAY())-1,12,31)+1),"SELECT Col2 ORDER BY Col1 DESC LIMIT 1",0)-1)YEAR-TO-YEAR
Year-to-Year (YTY) return compares the performance of a stock between two consecutive calendar years. It measures the percentage change in the stock’s price from the end of one year to the end of the following year. YTY return helps investors understand the stock’s performance and trend over a longer time horizon.
=TO_PERCENT(QUERY(GOOGLEFINANCE(A2,"Close",DATE(YEAR(TODAY())-1,12,31)-5,DATE(YEAR(TODAY())-1,12,31)),"SELECT Col2 ORDER BY Col1 DESC LIMIT 1",0)/QUERY(GOOGLEFINANCE(A2,"Close",DATE(YEAR(TODAY())-2,12,31)-5,DATE(YEAR(TODAY())-2,12,31)),"SELECT Col2 ORDER BY Col1 DESC LIMIT 1",0)-1)By analyzing both YTD and YTY returns, investors can gain a comprehensive understanding of how a stock has performed in the current year as well as its performance compared to previous years. These metrics are valuable tools for evaluating investment potential and making informed decisions in the stock market.
SPREADSHEET
The spreadsheet serves as a tool to help you keep track of the annual performance of stocks across different indices. It already includes the S&P100 template, but you can easily add more indices to customize it to your needs. You can find a list of available stock indices here.
The Year-to-Date (YTD) performance is tracked in Column C, while the performance of the stocks for the four previous years is tracked in additional columns using the Year-to-Year(YTY) formula.
This enables you to analyze and compare the stocks’ performance over an extended period, providing insights into their historical trends and patterns.
