In this video, we will learn how to draw stock charts, stock charts are mostly useful for displaying
stock market information.
They do not have many use cases, although it is not limited to only stock market information that you
can depict with this chart.
You can debate other types of information also.
So let us first learn about this stock chart.
So if you have traded in stock market, you know that there are five major parameters that define the
performance of a stock within a day.
One example in this dataset, you can see for the first day I have the volume of the stock traded on
that day.
That is the number of shares of that particular company traded between two parties.
The second column is showing the opening price of that particular stock.
That is when the market started in the morning.
What was the opening price of that stock?
Third column is highest value of that stock within that particular.
The fourth column is the lowest value of that particular stock.
And the fifth column is the closing value of that stock.
That is when the market closed in the evening.
What was the price of that particular stock?
And I have this for five days, for an example, so you can depict these values using these four types
of stock charts that we have, if you go to the insert menu and you look into the stock chart options,
there are four charts.
The first one is the high, low, close chart.
This is what we have drawn here.
As you can see in this chart, there are three things for each data point, knee high, low and gross
value.
So if you look at the first point of the X axis, we have the lowest point given by the bottom end of
the line, which is nearly sixty nine point six.
We have the highest point given by the other end of the line, which is nearly seventy two point six
three.
And we have the closing value depicted by this marker.
This chart is giving us only three values high value, low value and closed value.
That is why it is known as high, low, close stock chart.
Let us learn how to draw this one.
I believe this chart.
We will select these three columns only in the order I close, if it is not in this order, you'll have
to separately go and select the data in the order that you have the columns.
So I'll go to the stock chart option and I will select the first one, the first evidence that you will
notice in this chart with the previous chart is that the market point is a very small market point in
this case, whereas previously we had a big market point.
So you know how to change it.
You right.
Click on it, select the formatted as it is option.
In this film line option, you can select a marker one.
And within these market options, you can increase the size, you can change the type of marker, you
can use a square circle or a triangular marker that's across when you can change the color of the marker
also.
Also on the horizontal axis, that is the x axis.
We have one, two, three, four, five.
Instead, if you wanted to get it in there, we just edited and selected cities, which you want to
show.
So now we have the date and for each date we have the lowest, highest and the closing value of the
stock.
The next step is the open, high, low, close.
It has additional information.
That is what was the price of stock when the stock market opened.
So, again, it is similar to the previous one, just you will have to select the opening price column
also wildling, and it has to be in this order open, high, low, close, so that by default, what
Axelrod will be correct.
If it is not in this order, you'll have to go to the selected option and correct it.
So in this chart line is similar to the previous line, the end of the lines are depicting the lowest
and the highest value that the stock underwent that particular day.
This box is for the opening and closing price, one of the line of the box is giving you the opening
price and the other one is giving the closing price to differentiate whether the opening price is lower
than the closing price or the opening price is higher than the closing price.
We have the color of the box.
So you can see for these four days, the opening price was lower than the closing price.
So there is wide color.
And for this box, the opening price is higher than the closing price.
That is why it is a blood clot that is over this day.
The stock started at a lower price and ended at a higher price for all these four days.
This is what has happened.
But for this 50, this talk started at a higher place, but it ended at a lower price.
So us draw this one also very quickly, we deleted these four columns or to insert.
Stock chart, the second one.
And here we have it, you can format the x axis format, these lines and these boxes, their colors
as you wish.
The third option is the volume Illo Clouzot, so the first one was Ilocos and discharged.
There is an additional information of how much volume of that particular stock was traded on that particular
day.
So that additional information is depicted in these columns and also since it has two types of information.
One is the quantity of stock traded and the price of stock during the day, it will have to scales one
for the value and one for the price.
So in our example, volume is on the primary access.
And these bars will have the values corresponding to this primary access, whereas the value of the
price of the stock is on the secondary access.
And these lines and these markers will take their value from the secondary axis to let alone how to
draw this chart.
So we will select William.
High-Low includes Collum will go to start charge like disturbing.
You can see that since the scales are set in this way, there are two graphs, that is the column chart
and the stock chart is overlapping.
We need to change the scale of either of the two charts.
So let us take this scale of primary access, so it is ending at 18000, we ended at 32000 so that the
bars are smaller.
Now you can clearly see the amount of stock traded and the price fluctuation during the day.
If you want to further remove this overlap, you can take this skill as you wish.
So I'm changing the secondary school here.
So now you can see that the two charts are separated and you can clearly see both of these charts.
James Deema corruption also and have a bigger circular marker.
Now we can see the volume of stock trading, the high, low and closing price on the stock.
Default option is just including the opening price also.
So, again, the buyers are representing the volume of stock traded.
This line in this chart is giving you the high and low value and these boxes is giving you the opening
and closing price.
So you can draw this also in the same fashion, you will select the whole table.
Go to judge and select default option.
You can see this is not in the format that we want it to be, the issues that we have fibros which confuses
the light, the volume open, high, low and close values are given horizontally or vertically.
So Excel by default thought that instead of volume going vertically down, it is going horizontally
across.
So if you want to tell Excel that that is not the case, the data is vertically down, you just need
to click this button, which is Switch wrote a column.
You can see it in your chart, you can format it in the same way we discussed for the other three charts,
as I told you, that stock charts are not limited to only financial information.
You can depict any information similar to stock prices.
For example, if you want to debate the changes in temperature within a day, you can use the Hielo
close chart.
Instead of the closing value, you can use an average of Hielo.
So this chart is showing you the highest temperature achieving that, the lowest temperature and the
average temperature during the day.
So it can be used for non-financial data also.
But the data should be similar to the stock price to the.