WEBVTT 00:00.900 --> 00:06.370 In this video you will learn how to create interactive candlestick stick and open high low close chats 00:06.420 --> 00:12.570 and these chats are heavily used and technical analysis where technical analysts and traders try to 00:12.570 --> 00:18.420 find patterns in historical price data and even if you haven't heard of that before. 00:18.510 --> 00:20.560 The intuition is pretty simple. 00:20.850 --> 00:24.110 So first of all we import pandas and cufflinks. 00:24.150 --> 00:26.730 Then we import again our stocks. 00:26.760 --> 00:28.210 Data set. 00:28.230 --> 00:35.430 So here we have the open high low close prices for our six stocks and let us assume that we want to 00:35.430 --> 00:39.570 f up my low close for our Apple stock. 00:39.750 --> 00:47.630 Then we could uh for example swap the levels here in order to have the stock take us on the outer level 00:48.090 --> 00:52.550 and then we can select only the Apple stock and to be safe. 00:52.860 --> 00:57.860 The resulting data frame and the variable Apple and have a look. 00:57.870 --> 01:04.470 So here we have the open high low and close prices and also the adjusted close prices and the volume 01:04.470 --> 01:06.210 for the Apple stock. 01:06.270 --> 01:13.020 And if you want to create a candlestick or a open high low close the chart then our data frame must 01:13.020 --> 01:18.260 contain the columns open high low and close and this is the case here. 01:18.670 --> 01:26.240 And let's assume that we are only interested in the period from May to 70 into September to 17. 01:26.310 --> 01:35.070 So we are selecting that period here and then we are changing the plot method and then we pass the candle 01:35.100 --> 01:36.540 to the kind parameter. 01:36.570 --> 01:37.380 So let's have a look 01:40.480 --> 01:48.310 and here we have a candlestick chart and it's called a candle stick chart because uh these uh things 01:48.430 --> 01:50.850 look like candles actually. 01:51.070 --> 01:59.290 So each candle stands for a one day period and uh for days where we have positive returns from the open 01:59.290 --> 02:00.610 to the close price. 02:00.610 --> 02:07.900 Then we have a green candles and a red candle stands for a day where we have actually losses from the 02:07.900 --> 02:10.360 open to the close price. 02:10.450 --> 02:13.690 And for example let's have a look at this candle here. 02:14.110 --> 02:22.150 So here you can see the candle body here and uh this is the marked with the the open and uh the close 02:22.150 --> 02:23.000 price. 02:23.170 --> 02:26.200 And as we have a negative return on that day. 02:26.200 --> 02:32.160 So the open prices here the beginning of the body and the closing price is uh here. 02:32.770 --> 02:40.720 So this is the body of the candle and then we have also to candle wax which Mark actually uh the daily 02:40.720 --> 02:41.620 high prices. 02:41.620 --> 02:43.860 So the Societe daily high price. 02:43.980 --> 02:46.880 So one hundred fifty eight point two six. 02:46.960 --> 02:56.260 And here we have the daily low price hadnot fifty three point a three so this is a candle stick chart 02:56.300 --> 02:57.960 and technical analyst. 02:58.000 --> 03:07.180 Discover here patterns and the historical data and uh we can also create a open high low close um graph 03:07.180 --> 03:09.510 which is pretty similar actually. 03:09.730 --> 03:12.670 And we pass here open high low close 03:16.140 --> 03:23.490 and also here we have for each day actually uh one bar and four days where we have positive returns 03:23.490 --> 03:25.670 from the open to the close price. 03:25.680 --> 03:34.420 We have a green bar and for a negative uh daily return we have a red bar and actually you can see here 03:34.600 --> 03:40.600 at uh the left hand side a small dot and up and at the right hand side. 03:40.600 --> 03:44.870 And uh these are actually the open and close prices. 03:45.130 --> 03:53.020 So the left and thoughtless actually the open price and the dot on the right hand side to sexually the 03:53.080 --> 03:55.120 close price. 03:55.120 --> 04:02.290 And it's pretty hard to see here but there are two small dots and actually at the very top of each bar 04:02.290 --> 04:04.690 here is actually the high price of the day. 04:05.380 --> 04:11.700 And uh the the end of uh the bar here is uh the low price of the day. 04:11.740 --> 04:18.450 So this is uh pretty similar to a candlestick chart and uh with this we are already finished here with 04:18.580 --> 04:21.550 this video and I hope to see you also in the next one by.