Relative price and daily return
You will be calculating the relative price and daily returns for the AmerisourceBergen Corporation (ABC) stock for the last several months. ABC is one of the largest healthcare companies in the world that sells drugs and hospital supplies. You want to learn the volatility of their stock to see if you should invest by first calculating the relative price and daily returns.
本練習屬於課程
在 Google Sheets 進行財務建模
練習說明
- In
F4, create a ratio of the current day inE4to the previous day inE5. - In
G4, use the natural log function applied to the ratio inF4. - Copy these formulas to the rest of data provided excluding the last row.
