Stock Market Dashboard by gak67

Created by: gak67

 

About Dashboard:

Stock Market: - A stock market is the market that people use to selling and buying the shares which are the very small percentages to a company’s profit. When company will grow obviously share amount will grow we will get the amount accordingly if we sell it and if we buy the share then we will get the amount accordingly as per the company’s market value.

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

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

Through Excel Forum’s user we got the 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
 
In this table we can see top 10 Movement per Stock in descending order.
 
img3
 
In this table we can see top 10 total Movement in descending order.
 
img4
 
In this table we can see top 10 Movement percentage in descending order.
 
img5
 
img6
 
In this table we can see bottom 10 Movement per stock in descending order.
 
img7
 
In this table we can see bottom 10 total Movement in descending order.
 
img8
 
In this table we can see bottom 10 Movement percentage in descending order.
 
img9
 
In this table we can see bottom 10 value in descending order.
 
img10
 
In this table we can see summary of stock market. We can see the Portfolio report such as Portfolio Closing, Portfolio Movement, and Portfolio Movement Percentage.  Valuebottom 10 value in descending order.

Maximum movement per stock and Minimum movement per stock.

Maximum total movement and Minimum total movement.

Maximum movement percentage and Minimum movement percentage.
 
 

Comments

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.