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.
