Stock Market Dashboard - Stock wise and % share in total volume

Created by: arunagarwal

 

About Dashboard:

Stock Market: - The stock market is the market that people use to sell and buy shares which are very small percentages of a company’s profit. When company grow obviously share amount also grow. We get the amount accordingly if we sell it and if we buy the share then share price will obviously be according to the company’s market value.

The value of the share also depends on how many buyers want to purchase the share of that company. It means if more buyers are there, share price will go up.

Stock Dashboard is useful to show the share trend, how the shares have performed in the last year, last month and last day. It is useful to analyze that to knowwhere we should invest our money.

Through Excel Forum’s user we got a dashboard related to Stock Market. Let’s understand the dashboard; how it is prepared and how it will be useful to analyze the stock performance for the user.
img1
On the top of the dashboard we have drop down list of Stocks. Where we can select any stock and see the share performance and trend of the share performed.
img2
In this dashboard we have stock value performance according to previous closing and last trade, difference in percentage, and Volume.

Column chart is used to show the stock performance in between previous closing and last trade. Through this chart it shows very clearly this stock was in during previous closing and last trade.

Pie chart is used to show the % share in total volume.
img3
In the above shown table we can see the top 5 gainers whose stock gained very good movement. We can also see the movement percentage as well.

img4

In the above shown table we can see the bottom 5 gainers whose stock gained very low movement. We can see the movement percentage as well, which is negative.

Download Dashboard

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube