1 00:00:00,390 --> 00:00:00,690 Great. 2 00:00:00,690 --> 00:00:07,070 So we were able to get this table with stock market data out of the Yahoo finance data 3 00:00:07,100 --> 00:00:16,350 sources and this table corresponds to Google data so Google as a company we also tried Apple and this 4 00:00:16,350 --> 00:00:19,500 is quite a long actually, a long time frame. 5 00:00:19,500 --> 00:00:21,840 So let's do this for 10 days only. 6 00:00:22,390 --> 00:00:24,100 So execute that again. 7 00:00:24,150 --> 00:00:28,450 And if you count these rows actually you don't have 10 days there. 8 00:00:28,470 --> 00:00:36,690 because the fifth of March sixth of March are missing there. The reason to that is that these they happened to 9 00:00:36,690 --> 00:00:38,080 on weekend. 10 00:00:38,340 --> 00:00:41,380 So you only have data for business days. 11 00:00:41,370 --> 00:00:43,460 Now these are daily data. 12 00:00:43,940 --> 00:00:45,660 So what do they mean? 13 00:00:46,130 --> 00:00:53,220 Well, first of all stock market means you know back in the days when a company needed to to make some 14 00:00:53,220 --> 00:00:59,790 investments so they needed some money they would use money from their capital. 15 00:00:59,790 --> 00:01:03,230 But when this investment was considerably high. 16 00:01:03,410 --> 00:01:07,560 So they needed to spend a great amount of money which they didn't have. 17 00:01:07,560 --> 00:01:17,150 So they did they sold shares all of their company. That means you as an individual you could buy shares so you 18 00:01:17,150 --> 00:01:20,410 buy stock in other words from this company. 19 00:01:20,720 --> 00:01:23,180 And that makes you an owner of that company. 20 00:01:23,310 --> 00:01:25,360 Of course with a certain percentage. 21 00:01:25,560 --> 00:01:27,510 Now this is what happens every day. 22 00:01:27,600 --> 00:01:31,240 So for Google for instance you have all these data. 23 00:01:31,500 --> 00:01:40,290 So this is this is seven hundred and three dollars, open means this is the price of one share for google 24 00:01:40,290 --> 00:01:42,050 for this date. 25 00:01:42,210 --> 00:01:51,140 So if you had to buy at the opening of the day the price would be this to buy a share from Google, and through 26 00:01:51,180 --> 00:01:57,510 out the day you get the maximum price so the maximum price for Google for the Google company for that 27 00:01:57,510 --> 00:02:02,870 day went up to around seven hundred eighteen dollars. 28 00:02:02,920 --> 00:02:07,130 Then the lowest went down to six hundred ninety nine. 29 00:02:07,170 --> 00:02:11,890 Then closing price was 718.8. 30 00:02:12,030 --> 00:02:18,110 So the closing price means the last price before the end of the day. 31 00:02:18,390 --> 00:02:23,580 And then you have the volumes so how many shares were sold in this day. 32 00:02:23,610 --> 00:02:31,920 Now we have a resolution of one day here so we have daily data and you can also get a greater granularity 33 00:02:31,920 --> 00:02:32,910 there. 34 00:02:33,630 --> 00:02:40,860 So there are services who offer you hourly data maybe but you probably have to buy them. 35 00:02:41,250 --> 00:02:49,010 But these here are free and then you have adjusted close price which actually is like the close price 36 00:02:49,010 --> 00:02:52,670 here but the date has been adjusted under some other conditions. 37 00:02:52,830 --> 00:03:01,620 But we will be using only the open, high, low, and the close attributes and of course the date for building 38 00:03:01,620 --> 00:03:03,640 a candlestick chart. 39 00:03:03,750 --> 00:03:09,790 So these are the four or five attributes including dates to be a candlestick chart. 40 00:03:09,950 --> 00:03:11,280 So up to here. 41 00:03:11,550 --> 00:03:17,250 So I hope that makes sense and in the next lecture I'll show you a candlestick chart and I'll explain 42 00:03:17,250 --> 00:03:19,330 all the elements of the chart. 43 00:03:19,590 --> 00:03:22,820 And then after that we will start building that chart. 44 00:03:22,840 --> 00:03:24,820 So talk to you later.