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.
Практическое интерактивное упражнение
Превратите теорию в практику с помощью одного из наших интерактивных упражнений
Начать упражнение