1 00:00:01,830 --> 00:00:10,280 In this video we will learn how to draw stock charts stock charts are mostly useful for displaying stock 2 00:00:10,280 --> 00:00:13,100 market information. 3 00:00:13,100 --> 00:00:19,700 They do not have many use cases although it is not limited to only stock market information that you 4 00:00:19,700 --> 00:00:21,600 can depict with this chart. 5 00:00:21,680 --> 00:00:24,040 You're going to pick other types of information also. 6 00:00:24,850 --> 00:00:28,620 So let us first known about this top chart. 7 00:00:28,700 --> 00:00:35,960 If you have traded in stock market you will know that there are five major barometers that define the 8 00:00:35,960 --> 00:00:39,380 performance of the stock within a day. 9 00:00:39,380 --> 00:00:47,720 One example in this dataset you can see for the first day I have the volume of these stock traded on 10 00:00:47,720 --> 00:00:49,020 that day. 11 00:00:49,070 --> 00:00:55,010 That is the number of shares of that particular company traded between two parties. 12 00:00:55,010 --> 00:00:59,050 The second column is showing the opening price of that particular stock. 13 00:00:59,060 --> 00:01:03,350 That is when the market started in the morning or it was the opening price of that stock. 14 00:01:04,640 --> 00:01:13,080 Third column is highest value of that stock these within that particular day fourth column is the lowest 15 00:01:13,080 --> 00:01:19,780 value of that particular stock and the fifth column is the closing value of that stock. 16 00:01:19,800 --> 00:01:22,510 That is when the market closed in the evening. 17 00:01:22,530 --> 00:01:29,620 What was the price of that particular stock and I have this for five days. 18 00:01:29,620 --> 00:01:31,330 What an example. 19 00:01:31,510 --> 00:01:38,500 So you can depict these values using these four types of stock charts that we have. 20 00:01:39,640 --> 00:01:45,500 If you go to the Insert menu and you look into the stock chart options there are four charts. 21 00:01:45,550 --> 00:01:49,290 The first one is the high low close chart. 22 00:01:49,300 --> 00:01:56,690 This is what we have brought here as you can see in this chart there are three things for each data 23 00:01:56,830 --> 00:02:01,170 point knee high low and close value. 24 00:02:01,270 --> 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 25 00:02:09,670 --> 00:02:14,120 the line which is nearly sixty nine point six. 26 00:02:14,620 --> 00:02:19,870 We have the highest point given by the other end of the line which is nearly seventy two point sixty 27 00:02:21,070 --> 00:02:26,280 and we have the closing value depicted by this market. 28 00:02:26,290 --> 00:02:32,140 This chart is giving us only three values high value low value and close value. 29 00:02:32,140 --> 00:02:39,380 That is why it is known as a low close stock chart let us learn how to draw this one. 30 00:02:39,700 --> 00:02:48,520 I believe this chart we will select these three columns only in the order high low close if it is not 31 00:02:48,520 --> 00:02:57,070 in this order you'll have to separately go and select the data in the order that you have these columns. 32 00:02:57,520 --> 00:03:04,920 So I'll go to the stock chart option and a little like the first one the first evidence that you will 33 00:03:04,920 --> 00:03:13,470 notice in this chart that the previous chart is that the marker point is a very small market point in 34 00:03:13,470 --> 00:03:17,410 this case whereas previously we had a big market point. 35 00:03:18,000 --> 00:03:26,110 So you know how to change it you right click on it selective formatted as it is option in this fill 36 00:03:26,110 --> 00:03:34,290 and line option you can select the market 1 and within these market options you can increase the size 37 00:03:34,380 --> 00:03:42,870 you can change the type of marker you can use a square circle or a triangular marker that's a cross 38 00:03:42,880 --> 00:03:46,800 one you can change the color of the market also 39 00:03:49,470 --> 00:03:57,290 also on the horizontal axis that is the x axis we have one two three four five and instead if you want 40 00:03:57,290 --> 00:04:05,060 the date to get it under you will just edited and select DCD which you want to show. 41 00:04:05,220 --> 00:04:12,080 So now we have the date and for each date we have the lowest I used and the closing value of the stock 42 00:04:14,330 --> 00:04:22,170 the next type is the open high low close it has additional information that is what all the price of 43 00:04:22,170 --> 00:04:31,220 stock when the stock market opened so again it is similar to the previous one just you will have to 44 00:04:31,220 --> 00:04:40,280 select the opening price column also while driving and it has to be in this order open high low close 45 00:04:41,030 --> 00:04:48,500 so that by default what accelerated roll will be correct if it does not in this order you'll have to 46 00:04:48,500 --> 00:04:51,020 go to the selected option and correct it. 47 00:04:51,150 --> 00:04:58,940 So in this chart line is similar to the previous line the end of the lines are depicting the lowest 48 00:04:59,000 --> 00:05:05,200 and the highest value that the stock underwent that particular day. 49 00:05:05,810 --> 00:05:12,410 This box is for the opening and closing price one of the nine of the box is giving you the opening price 50 00:05:12,560 --> 00:05:20,240 and the other one is giving you the closing price to differentiate whether the opening price is lower 51 00:05:20,240 --> 00:05:26,060 than the closing price or the opening prices higher than the closing price we have the color of the 52 00:05:26,060 --> 00:05:34,160 box so you can see for these four days the opening price was lower than the closing place so there is 53 00:05:34,340 --> 00:05:43,070 wide color and for this box the opening price is higher than the closing price that is where it is in 54 00:05:43,250 --> 00:05:52,490 black color that is over this day the stock started at a lower price and ended at higher price for all 55 00:05:52,490 --> 00:06:00,510 these four days this is what has happened but for this fifth day this talk started at a higher place 56 00:06:00,540 --> 00:06:03,480 but it ended at a lower price. 57 00:06:03,690 --> 00:06:10,770 So let us draw this one also very quickly deleted the intellect these food columns or to insert 58 00:06:13,290 --> 00:06:14,560 stock chart. 59 00:06:14,670 --> 00:06:18,180 The second one I had we have it. 60 00:06:18,180 --> 00:06:20,420 You can format the x axis. 61 00:06:20,420 --> 00:06:25,580 What about these lines and these boxes their colors. 62 00:06:25,590 --> 00:06:28,330 As you wish. 63 00:06:28,500 --> 00:06:30,750 The third option is the volume. 64 00:06:30,750 --> 00:06:32,330 I love blues art. 65 00:06:32,530 --> 00:06:41,430 So the first one was I look close and this chart there is an additional information of how much volume 66 00:06:41,460 --> 00:06:50,330 of that particular stock was traded on that particular day so that additional information is depicted 67 00:06:50,560 --> 00:06:55,610 using these columns and also since it has two types of information. 68 00:06:55,610 --> 00:07:03,830 One is the quantity of stock traded and the price of stock during the day. 69 00:07:03,830 --> 00:07:08,070 It will have two skills one for the value and one for the price. 70 00:07:09,470 --> 00:07:19,640 So in our example volume is on the primary axis and these bars will have the values corresponding to 71 00:07:19,640 --> 00:07:28,670 this primary axis whereas the value of the price of the stock is on the secondary axis and these lines 72 00:07:28,670 --> 00:07:35,390 and these markers will take their value from the secondary axis to let us learn how to draw. 73 00:07:35,420 --> 00:07:35,960 This chart 74 00:07:39,180 --> 00:07:41,160 so we will select one new 75 00:07:45,130 --> 00:07:47,900 high low and close column. 76 00:07:48,300 --> 00:07:50,820 We go to stock chart like this third one 77 00:07:53,960 --> 00:08:00,290 you can see that since the scales are set in this way that are two graphs. 78 00:08:00,290 --> 00:08:09,260 That is the column chart and the stock chart is overlapping really to change the scale of either of 79 00:08:09,260 --> 00:08:14,630 these two charts so let us change the scale of primary axis. 80 00:08:14,820 --> 00:08:22,980 So it is ending at eighteen thousand really ended at 32000 so that the bars are smaller. 81 00:08:22,980 --> 00:08:27,930 Now you can clearly see the amount of stock traded and the price fluctuation in the. 82 00:08:28,860 --> 00:08:33,750 If you want to further the move this overlap you can take this skill as you wish 83 00:08:36,840 --> 00:08:39,060 so I'm changing the secondary school here. 84 00:08:42,610 --> 00:08:49,510 So now you can see that these two charts are separated and you can clearly see both of these charts 85 00:08:51,590 --> 00:08:53,310 James DeMarco optional. 86 00:08:53,960 --> 00:08:56,750 Have a bigger circular marker. 87 00:09:04,010 --> 00:09:14,790 Now we can see the volume of stock traded the high low and closing price on this stock default option 88 00:09:15,780 --> 00:09:18,180 is just including the opening price also. 89 00:09:18,900 --> 00:09:27,420 So again the buyers are representing the volume of stock rated this line in this chart is giving you 90 00:09:27,420 --> 00:09:29,130 the high and low value. 91 00:09:30,090 --> 00:09:33,400 And these boxes is giving you the opening and closing please 92 00:09:36,460 --> 00:09:45,860 so you can draw this also in the same fashion you would select the whole table go to stock charts and 93 00:09:45,910 --> 00:09:49,180 let default option. 94 00:09:49,240 --> 00:09:53,920 You can see this is not in the format that we want it to be. 95 00:09:53,920 --> 00:10:03,020 The issue is that we have five rows which confuses the Excel that the volume open high low and close. 96 00:10:03,160 --> 00:10:12,580 Values are given horizontally automatically so excel by default thought that instead of volume going 97 00:10:12,970 --> 00:10:18,130 vertically down it is going horizontally across. 98 00:10:18,240 --> 00:10:24,270 If you want to tell Excel that that is not the case the data is vertically down. 99 00:10:24,270 --> 00:10:27,750 You just need to click this button which is switch wrote to column 100 00:10:30,870 --> 00:10:37,240 so you can see it your chart you can formatted in the same way we discussed for the other three charts 101 00:10:38,630 --> 00:10:48,690 as I told you that stock charts are not limited to only financial information you can depict any information 102 00:10:48,690 --> 00:10:50,790 similar to stock prices. 103 00:10:50,790 --> 00:10:59,940 For example if you want to depict the changes in temperature within a day you can use the high low close 104 00:10:59,940 --> 00:11:02,780 chart instead of the closing value. 105 00:11:03,030 --> 00:11:05,050 You can use the average of high or low. 106 00:11:05,250 --> 00:11:12,990 So this chart is showing you the highest amplitude achieved in that day lowest temperature and the average 107 00:11:13,080 --> 00:11:14,910 temperature during the day. 108 00:11:15,120 --> 00:11:19,290 So it can be used for non-financial data also. 109 00:11:19,740 --> 00:11:22,670 But the data should be similar to the stock price data.