Stock Market Dashboard - Trend Analysis of Stock Performance

Created by: pedroufksi

 

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 know where 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

img2

Line chart is used to show the share trend and amount date wise. We can see what is the share price and the trend and how it is performing.

In this 3 lines are used, dark blue line is representing the MPC, light blue line is representing to TFG and red line is representing to TRU.

Through this chart we can take idea that MPC is best to invest the money, as per the trend we can forecast that this share can give us better returns than other shares.

img3

Area chart is used to show the share trend and amount calendar wise. In this chart we have 2 radio buttons and 3 check boxes. 2 radio buttons are available to show the report on daily trend, and to show the report on Weekly trend. 3 check boxes are available to show the as per the sectors, where we can select a single sector or multiple sectors.

Below 1 table is linked with chart analyses in which presenting the summary to the selected criteria.

img4

Above shown tabs are showing the current status of the shares. In these tabs we can see the all the shares present market value.According to this tab users switch their funds, buy and sells their shares.

Through this dashboard we can easily analyze where we should invest the money, when we should sell our shares, where we should switch the money and from where we can get more profit.

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