Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

you will write an R script to calculate the relative volatility for the three given stocks: enb, baba, and aal Files to download: Please download

you will write an R script to calculate the relative volatility for the three given stocks: enb, baba, and aal

Files to download: Please download the following files from D2L "baba.csv", "aal.csv", "enb.csv"

These CSV files contain the historical trading data for the corresponding stocks trading at NYSE/Nasdaq stock exchange, and each of them has the following information:

Date, Open Price, High Price, Low Price, Close Price, Adj Close, Volume

Your task is to write an R script that will calculate the covariance for each of the stocks to calculate the volatility for the year 2019 using the closing price of the stocks. A higher value of covariance means the stock is more volatile.

How to calculate covariance?

To calculate the covariance, we need to know the mean and the standard deviation (sd). Then using the mean and the standard deviation, we can calculate the covariance (cv) using the following formula:

cv = sd/mean

Your R script should deliver the following:

The script should save the covariance for each of the three stocks to a data frame, and then the data frame should be saved to a CSV file named "covariance.csv"

All the covariances of the three stocks should be plotted on a single plot

Your program should save the stock tickers for the most and the least volatile stocks to a data frame, and then the data frame should be saved to another CSV file named

"maxMin.csv"

Make sure the script is well documented. I mean, each line of code should be documented.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Equation Of Knowledge From Bayes Rule To A Unified Philosophy Of Science

Authors: Lê Nguyên Hoang

1st Edition

1000063275, 9781000063271

More Books

Students also viewed these Mathematics questions