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 in E4 to the previous day in E5.
In G4, use the natural log function applied to the ratio in F4.
Copy these formulas to the rest of data provided excluding the last row.

Практична інтерактивна вправа

Перетворіть теорію на практику за допомогою однієї з наших інтерактивних вправ

Почати вправу