WEBVTT

00:00.730 --> 00:02.260
Welcome to coding exercise.

00:02.260 --> 00:07.150
Twelve feet here on the tuba the dashboard and our exercises file this on our desktop

00:10.190 --> 00:15.770
and we are in part two and we select the two put a notebook for exercise twelve

00:18.460 --> 00:23.790
and starting with coding exercise twelve for the coding exercises are a bit different than before.

00:24.190 --> 00:31.660
So far the focus was on Panda's coding and starting from coding exercise twelve.

00:31.720 --> 00:40.060
The focus is on solving real world problems and tasks in the finance and investment industry and therefore

00:40.060 --> 00:41.620
you have two options.

00:41.620 --> 00:47.700
So you have option number one self guided and you can find some high level questions.

00:47.710 --> 00:53.920
So first of all you should import to the U.S. stocks dataset and select the adjusted.

00:54.010 --> 01:01.720
Clothes for a particular time period and then you should visualize the adjusted clothes for the six

01:01.720 --> 01:10.240
stocks and also visualize the normalized prices over time and then you start to calculate monthly returns

01:10.540 --> 01:15.850
and based on that monthly returns you are asked to calculate the annualized the mean return and the

01:15.850 --> 01:18.240
annualized standard deviation of returns.

01:18.310 --> 01:21.130
So to say risk and return.

01:21.130 --> 01:27.640
And finally you should also visualize the risk and return in a total risk return framework with the

01:27.700 --> 01:34.810
standard deviation on the x axis and the mean return on the y axis and you should also be able to identify

01:34.810 --> 01:40.780
the best performing and the worst performing stocks in terms of total risk and return.

01:40.930 --> 01:47.170
And finally you should also visualize the correlation matrix of monthly returns with a seaborne heat

01:47.170 --> 01:54.160
map and you should identify the stock pair with the highest positive correlation of monthly returns.

01:54.280 --> 02:01.330
So that's the self guided option and essentially you have to find your very own code but you can also

02:01.330 --> 02:09.220
select the option to guide it and instructed and here you can find for each and every exercise a question

02:09.640 --> 02:12.340
a detailed guide and instruction.

02:12.430 --> 02:14.410
What to code here.

02:14.560 --> 02:17.820
And finally you can also find at the very end.

02:17.890 --> 02:26.040
The hint section so feel free to select that option that best fits your learning style and hope you

02:26.040 --> 02:29.790
have fun and also have a look at the solution by.