Microsoft Excel Tips | Excel Tutorial | Free Excel Help



Stock Market DashboardAbout 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.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.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.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.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. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download