How To Calculate Daily Return of A Stock PDF
How To Calculate Daily Return of A Stock PDF
How To Calculate Daily Return of A Stock PDF
Introduction
Thank you for your interest in learning how to calculate daily return
and annual return. Before we begin, it is important to understand the
formula for daily return, which is ((Close Stock Price Today-Close
Stock Price Yesterday)/Close Stock Price Yesterday)*100. While
annual return is the sum of daily return over the course of a year.
These concepts are fundamental to understanding the financial
growth of prospective companies and we are excited to take you
through the process step by step. In order to complete the
instruction set, you will need access to Yahoo Finance and
Microsoft Excel.
7. Click the Download Data button which will download a .csv file
8. Go to your computers downloads and open the .csv file
9. Upon opening the .csv file you will be able to see all of the companies
information for the previous year. Under the date column (column A), it is
likely you will only be able to see the # symbol. In order to fix this issue,
change the size of the cell by placing your cursor between columns A
and B and drag the cursor to the right.
10. Save the file
11. After you have saved the file, go to the top left cell (Column A)
12. Go to the Insert Tab
13. Hit Insert Table
*The following visual depicts the new columns that should be added to the
right.
This section will explain the formula necessary to calculate daily returns
21. In Cell H2, type the equal sign
22. Then select Cell E2 (Close Price Today)
23. Type the subtraction sign into the formula
24. Select Cell E3 (Close Price Yesterday)
25. Then divide the entire formula by E3 (Close Price Yesterday)
26. Multiple the entire formula by 100
27. Your final formula should be: =((E2-E3)/E3)*100
28. Once you are confident with your formula, click the check mark above
Column B. (This will then apply the formula to the entire H column).
This section will explain how to graph the data, which will provide a
quality visualization of the results.
34. Select the entire I2 Column
35.Click the Insert tab
36.Go to the graph icon and select the top left option
37.Excel will then graph the return over the course of the year, providing a
nice visualization of the data.
The following visual illustrates the chart in relation to the data. Graphing
the data is a valuable tool in order to interpret the results. This concludes
the instruction set on calculating daily return and annual return on Yahoo
Finance and Microsoft Excel.