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're going to pick other types of information also.
So let us first known about this top chart.
If you have traded in stock market you will know that there are five major barometers that define the
performance of the stock within a day.
One example in this dataset you can see for the first day I have the volume of these 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 or it was the opening price of that stock.
Third column is highest value of that stock these within that particular day 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.
What 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 brought here as you can see in this chart there are three things for each data
point knee high low and close 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 sixty
and we have the closing value depicted by this market.
This chart is giving us only three values high value low value and close value.
That is why it is known as a 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 high low close if it is not
in this order you'll have to separately go and select the data in the order that you have these columns.
So I'll go to the stock chart option and a little like the first one the first evidence that you will
notice in this chart that the previous chart is that the marker 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 selective formatted as it is option in this fill
and line option you can select the market 1 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 a cross
one you can change the color of the market also
also on the horizontal axis that is the x axis we have one two three four five and instead if you want
the date to get it under you will just edited and select DCD which you want to show.
So now we have the date and for each date we have the lowest I used and the closing value of the stock
the next type is the open high low close it has additional information that is what all 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 while driving and it has to be in this order open high low close
so that by default what accelerated roll will be correct if it does 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 nine of the box is giving you the opening price
and the other one is giving you the closing price to differentiate whether the opening price is lower
than the closing price or the opening prices 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 place so there is
wide color and for this box the opening price is higher than the closing price that is where it is in
black color that is over this day the stock started at a lower price and ended at higher price for all
these four days this is what has happened but for this fifth day this talk started at a higher place
but it ended at a lower price.
So let us draw this one also very quickly deleted the intellect these food columns or to insert
stock chart.
The second one I had we have it.
You can format the x axis.
What about these lines and these boxes their colors.
As you wish.
The third option is the volume.
I love blues art.
So the first one was I look close and this chart 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
using 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 two skills one for the value and one for the price.
So in our example volume is on the primary axis and these bars will have the values corresponding to
this primary axis whereas the value of the price of the stock is on the secondary axis and these lines
and these markers will take their value from the secondary axis to let us learn how to draw.
This chart
so we will select one new
high low and close column.
We go to stock chart like this third one
you can see that since the scales are set in this way that are two graphs.
That is the column chart and the stock chart is overlapping really to change the scale of either of
these two charts so let us change the scale of primary axis.
So it is ending at eighteen thousand really ended at 32000 so that the bars are smaller.
Now you can clearly see the amount of stock traded and the price fluctuation in the.
If you want to further the move this overlap you can take this skill as you wish
so I'm changing the secondary school here.
So now you can see that these two charts are separated and you can clearly see both of these charts
James DeMarco optional.
Have a bigger circular marker.
Now we can see the volume of stock traded the high low and closing price on this stock default option
is just including the opening price also.
So again the buyers are representing the volume of stock rated this line in this chart is giving you
the high and low value.
And these boxes is giving you the opening and closing please
so you can draw this also in the same fashion you would select the whole table go to stock charts and
let default option.
You can see this is not in the format that we want it to be.
The issue is that we have five rows which confuses the Excel that the volume open high low and close.
Values are given horizontally automatically so excel by default thought that instead of volume going
vertically down it is going horizontally across.
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 to column
so you can see it your chart you can formatted 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 depict the changes in temperature within a day you can use the high low close
chart instead of the closing value.
You can use the average of high or low.
So this chart is showing you the highest amplitude achieved in that day 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 data.