1 00:00:01,740 --> 00:00:09,930 In this video, we will learn how to draw stock charts, stock charts are mostly useful for displaying 2 00:00:09,930 --> 00:00:11,310 stock market information. 3 00:00:13,050 --> 00:00:19,710 They do not have many use cases, although it is not limited to only stock market information that you 4 00:00:19,710 --> 00:00:20,980 can depict with this chart. 5 00:00:21,660 --> 00:00:23,990 You can debate other types of information also. 6 00:00:24,810 --> 00:00:26,770 So let us first learn about this stock chart. 7 00:00:28,440 --> 00:00:35,970 So if you have traded in stock market, you know that there are five major parameters that define the 8 00:00:35,970 --> 00:00:38,280 performance of a stock within a day. 9 00:00:39,330 --> 00:00:47,720 One example in this dataset, you can see for the first day I have the volume of the stock traded on 10 00:00:47,730 --> 00:00:48,170 that day. 11 00:00:48,990 --> 00:00:54,110 That is the number of shares of that particular company traded between two parties. 12 00:00:54,960 --> 00:00:58,720 The second column is showing the opening price of that particular stock. 13 00:00:58,980 --> 00:01:01,310 That is when the market started in the morning. 14 00:01:01,350 --> 00:01:03,340 What was the opening price of that stock? 15 00:01:04,590 --> 00:01:09,180 Third column is highest value of that stock within that particular. 16 00:01:09,750 --> 00:01:14,510 The fourth column is the lowest value of that particular stock. 17 00:01:15,300 --> 00:01:19,240 And the fifth column is the closing value of that stock. 18 00:01:19,740 --> 00:01:22,070 That is when the market closed in the evening. 19 00:01:22,470 --> 00:01:25,200 What was the price of that particular stock? 20 00:01:26,920 --> 00:01:36,940 And I have this for five days, for an example, so you can depict these values using these four types 21 00:01:36,940 --> 00:01:44,190 of stock charts that we have, if you go to the insert menu and you look into the stock chart options, 22 00:01:44,230 --> 00:01:45,250 there are four charts. 23 00:01:45,470 --> 00:01:48,760 The first one is the high, low, close chart. 24 00:01:49,270 --> 00:01:50,950 This is what we have drawn here. 25 00:01:51,580 --> 00:01:59,890 As you can see in this chart, there are three things for each data point, knee high, low and gross 26 00:01:59,890 --> 00:02:00,290 value. 27 00:02:01,210 --> 00:02:09,670 So if you look at the first point of the X axis, we have the lowest point given by the bottom end of 28 00:02:09,670 --> 00:02:13,270 the line, which is nearly sixty nine point six. 29 00:02:14,590 --> 00:02:19,600 We have the highest point given by the other end of the line, which is nearly seventy two point six 30 00:02:19,610 --> 00:02:19,860 three. 31 00:02:20,950 --> 00:02:24,790 And we have the closing value depicted by this marker. 32 00:02:26,260 --> 00:02:32,090 This chart is giving us only three values high value, low value and closed value. 33 00:02:32,110 --> 00:02:35,150 That is why it is known as high, low, close stock chart. 34 00:02:37,150 --> 00:02:38,860 Let us learn how to draw this one. 35 00:02:39,580 --> 00:02:40,660 I believe this chart. 36 00:02:42,750 --> 00:02:49,860 We will select these three columns only in the order I close, if it is not in this order, you'll have 37 00:02:49,860 --> 00:02:55,470 to separately go and select the data in the order that you have the columns. 38 00:02:57,460 --> 00:03:04,930 So I'll go to the stock chart option and I will select the first one, the first evidence that you will 39 00:03:04,930 --> 00:03:13,480 notice in this chart with the previous chart is that the market point is a very small market point in 40 00:03:13,480 --> 00:03:17,280 this case, whereas previously we had a big market point. 41 00:03:17,950 --> 00:03:19,360 So you know how to change it. 42 00:03:19,790 --> 00:03:20,200 You right. 43 00:03:20,200 --> 00:03:23,290 Click on it, select the formatted as it is option. 44 00:03:25,390 --> 00:03:29,290 In this film line option, you can select a marker one. 45 00:03:31,500 --> 00:03:37,470 And within these market options, you can increase the size, you can change the type of marker, you 46 00:03:37,470 --> 00:03:46,440 can use a square circle or a triangular marker that's across when you can change the color of the marker 47 00:03:46,440 --> 00:03:46,810 also. 48 00:03:49,350 --> 00:03:52,860 Also on the horizontal axis, that is the x axis. 49 00:03:53,640 --> 00:03:55,090 We have one, two, three, four, five. 50 00:03:56,010 --> 00:04:03,870 Instead, if you wanted to get it in there, we just edited and selected cities, which you want to 51 00:04:03,870 --> 00:04:04,150 show. 52 00:04:05,190 --> 00:04:11,700 So now we have the date and for each date we have the lowest, highest and the closing value of the 53 00:04:11,700 --> 00:04:12,100 stock. 54 00:04:14,250 --> 00:04:17,520 The next step is the open, high, low, close. 55 00:04:18,040 --> 00:04:20,100 It has additional information. 56 00:04:20,100 --> 00:04:24,390 That is what was the price of stock when the stock market opened. 57 00:04:26,560 --> 00:04:34,720 So, again, it is similar to the previous one, just you will have to select the opening price column 58 00:04:34,720 --> 00:04:43,180 also wildling, and it has to be in this order open, high, low, close, so that by default, what 59 00:04:43,180 --> 00:04:45,730 Axelrod will be correct. 60 00:04:46,540 --> 00:04:50,510 If it is not in this order, you'll have to go to the selected option and correct it. 61 00:04:51,070 --> 00:04:58,960 So in this chart line is similar to the previous line, the end of the lines are depicting the lowest 62 00:04:58,960 --> 00:05:03,510 and the highest value that the stock underwent that particular day. 63 00:05:05,770 --> 00:05:12,040 This box is for the opening and closing price, one of the line of the box is giving you the opening 64 00:05:12,040 --> 00:05:20,230 price and the other one is giving the closing price to differentiate whether the opening price is lower 65 00:05:20,230 --> 00:05:24,730 than the closing price or the opening price is higher than the closing price. 66 00:05:25,000 --> 00:05:26,500 We have the color of the box. 67 00:05:27,160 --> 00:05:33,130 So you can see for these four days, the opening price was lower than the closing price. 68 00:05:33,550 --> 00:05:34,990 So there is wide color. 69 00:05:36,570 --> 00:05:40,900 And for this box, the opening price is higher than the closing price. 70 00:05:41,910 --> 00:05:46,430 That is why it is a blood clot that is over this day. 71 00:05:46,890 --> 00:05:53,340 The stock started at a lower price and ended at a higher price for all these four days. 72 00:05:53,370 --> 00:05:54,740 This is what has happened. 73 00:05:56,750 --> 00:06:02,510 But for this 50, this talk started at a higher place, but it ended at a lower price. 74 00:06:03,620 --> 00:06:10,790 So us draw this one also very quickly, we deleted these four columns or to insert. 75 00:06:13,250 --> 00:06:15,350 Stock chart, the second one. 76 00:06:16,430 --> 00:06:25,520 And here we have it, you can format the x axis format, these lines and these boxes, their colors 77 00:06:25,520 --> 00:06:26,240 as you wish. 78 00:06:28,430 --> 00:06:36,250 The third option is the volume Illo Clouzot, so the first one was Ilocos and discharged. 79 00:06:36,290 --> 00:06:44,540 There is an additional information of how much volume of that particular stock was traded on that particular 80 00:06:44,540 --> 00:06:44,770 day. 81 00:06:46,650 --> 00:06:55,570 So that additional information is depicted in these columns and also since it has two types of information. 82 00:06:55,590 --> 00:07:05,490 One is the quantity of stock traded and the price of stock during the day, it will have to scales one 83 00:07:05,490 --> 00:07:07,980 for the value and one for the price. 84 00:07:09,390 --> 00:07:13,680 So in our example, volume is on the primary access. 85 00:07:15,340 --> 00:07:23,950 And these bars will have the values corresponding to this primary access, whereas the value of the 86 00:07:23,950 --> 00:07:26,230 price of the stock is on the secondary access. 87 00:07:26,590 --> 00:07:34,960 And these lines and these markers will take their value from the secondary axis to let alone how to 88 00:07:35,080 --> 00:07:35,980 draw this chart. 89 00:07:39,150 --> 00:07:41,160 So we will select William. 90 00:07:45,060 --> 00:07:50,820 High-Low includes Collum will go to start charge like disturbing. 91 00:07:53,860 --> 00:08:01,870 You can see that since the scales are set in this way, there are two graphs, that is the column chart 92 00:08:02,110 --> 00:08:04,840 and the stock chart is overlapping. 93 00:08:06,190 --> 00:08:10,390 We need to change the scale of either of the two charts. 94 00:08:11,310 --> 00:08:21,360 So let us take this scale of primary access, so it is ending at 18000, we ended at 32000 so that the 95 00:08:21,360 --> 00:08:22,250 bars are smaller. 96 00:08:22,860 --> 00:08:27,920 Now you can clearly see the amount of stock traded and the price fluctuation during the day. 97 00:08:28,770 --> 00:08:33,770 If you want to further remove this overlap, you can take this skill as you wish. 98 00:08:36,750 --> 00:08:39,060 So I'm changing the secondary school here. 99 00:08:42,550 --> 00:08:49,510 So now you can see that the two charts are separated and you can clearly see both of these charts. 100 00:08:51,580 --> 00:08:56,770 James Deema corruption also and have a bigger circular marker. 101 00:09:04,000 --> 00:09:11,470 Now we can see the volume of stock trading, the high, low and closing price on the stock. 102 00:09:13,820 --> 00:09:18,170 Default option is just including the opening price also. 103 00:09:18,830 --> 00:09:22,640 So, again, the buyers are representing the volume of stock traded. 104 00:09:23,630 --> 00:09:32,450 This line in this chart is giving you the high and low value and these boxes is giving you the opening 105 00:09:32,450 --> 00:09:33,410 and closing price. 106 00:09:36,400 --> 00:09:41,880 So you can draw this also in the same fashion, you will select the whole table. 107 00:09:43,970 --> 00:09:46,790 Go to judge and select default option. 108 00:09:49,120 --> 00:09:58,510 You can see this is not in the format that we want it to be, the issues that we have fibros which confuses 109 00:09:58,510 --> 00:10:06,820 the light, the volume open, high, low and close values are given horizontally or vertically. 110 00:10:07,330 --> 00:10:15,820 So Excel by default thought that instead of volume going vertically down, it is going horizontally 111 00:10:15,820 --> 00:10:16,270 across. 112 00:10:17,700 --> 00:10:24,840 So if you want to tell Excel that that is not the case, the data is vertically down, you just need 113 00:10:24,840 --> 00:10:27,780 to click this button, which is Switch wrote a column. 114 00:10:30,940 --> 00:10:37,240 You can see it in your chart, you can format it in the same way we discussed for the other three charts, 115 00:10:38,530 --> 00:10:44,170 as I told you, that stock charts are not limited to only financial information. 116 00:10:45,490 --> 00:10:50,270 You can depict any information similar to stock prices. 117 00:10:50,710 --> 00:10:59,580 For example, if you want to debate the changes in temperature within a day, you can use the Hielo 118 00:10:59,620 --> 00:11:00,310 close chart. 119 00:11:01,000 --> 00:11:05,020 Instead of the closing value, you can use an average of Hielo. 120 00:11:05,200 --> 00:11:12,460 So this chart is showing you the highest temperature achieving that, the lowest temperature and the 121 00:11:12,460 --> 00:11:14,160 average temperature during the day. 122 00:11:15,070 --> 00:11:19,260 So it can be used for non-financial data also. 123 00:11:19,690 --> 00:11:22,720 But the data should be similar to the stock price to the.