Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5 . Choose the top 5 companies in terms of ESG score from dfASX 2 0 , and save the dataframe as dfASX 5 .

5. Choose the top 5 companies in terms of ESG score from dfASX20, and save the dataframe as dfASX5. Print out dfASX5.
6. Use yfinance package to obtain the monthly share price data for those 5 companies from Yahoo! Finance for the period December 2021 March 2024(named as df), and calculate the monthly returns (percentage return)(named as dfr).
7. For each stock, normalize the stock price to $1 at the beginning of the period. Then visualize the time-series movement of the normalized stock prices of those 5 companies in one graph.
8. Show the summary statistics of the returns of those 5 stocks. Use the bar plot to visualize the average returns of those 5 stocks. Show the correlation matrix of the returns of those 5 stocks.
Visualize the correlations using heatmap.

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

Upgrading Oracle Databases Oracle Database New Features

Authors: Charles Kim, Gary Gordhamer, Sean Scott

1st Edition

B0BL12WFP6, 979-8359657501

More Books

Students also viewed these Databases questions

Question

What is one of the skills required for independent learning?Explain

Answered: 1 week ago