investor’s aid
TRANSCRIPT
-
8/11/2019 Investors Aid
1/10
INVESTORS AID
By Group 10:
Vaibhav Varadkar 55
Shivangi Verma 56
Pulkit Bhardwaj 57
Mohammed Amir Sheikh 58
Aditya Patil 59
Kumar Simant 60
PROJECT OF IT IN MANAGEMENT
-
8/11/2019 Investors Aid
2/10
PURPOSE
To provide comparative study of the companys equity values toderive to help stock traders make rational decisions by:
a) Providing consolidated data of the Scrips for investment
b) Analysis based on Scrips monthly performance
Analysis and representation based on graphs and chartc) Showing sector wise performance of Scrips
d) Risk analysis
e) To understand market sentiments about the Scrips
-
8/11/2019 Investors Aid
3/10
1. AVERAGE MONTHLY HIGH-LOW
Indications by Conditional Formatting:
Red color in Close Price: Scrip is trading below Average MonthlyLow
[Good for buying]
Green Color in close price: Scrip is trading above Average MonthlyHigh
[Good for selling]
No Color in Close price: Scrip is trading between Average Monthly
Low and Average Monthly High
Green Color in Spread Close-Open: Scrips value has increasedin the given month
Average Monthly High and Low calculations
-
8/11/2019 Investors Aid
4/10
FIG: REPRESENTATION USING CONDITIONAL FORMATTING
Average Monthly High-Low Cntd..
-
8/11/2019 Investors Aid
5/10
2. SCRIP PERFORMANCE
Indications by Line graph: Annual trend of change in the Close Price of the Scrip
A graph with positive slope indicates annual growth of the equity
[good time to make a long term investment in this scrip]
A graph with negative slope indicates downfall of the equity
[Keep track to get the best buy value]
-
8/11/2019 Investors Aid
6/10
3. RISK ANALYSIS
Indications by Bar Chart: Difference between Monthly High and Low through the
year
The green color bar shows value for Spread High-Low
Conclusion: Higher the value in green, higher the volatility, higher
the risk and therefore not a good short term investment.
-
8/11/2019 Investors Aid
7/10
4. RETRIEVE SPECIFIC SCRIP VALUES
Indications by Lookup function:
Retrieve closing price of Scrip by entering month and scrip name
Scrip name
Company
Code Sep-13 Oct-13 Nov-13 Dec-13 Jan-14
HDFC 2 593.7 679.45 661.2 665.75 628.9
ICICI 3 884.95 1121.05 1067.9 1098.45 988.5
Axis Bank 4 1007.3 1222.9 1155.3 1299.65 1119.55
TCS 5 1926.7 2108.25 2004.6 2170.95 2236.2
Infosys 6 3015.45 3308.65 3353.5 3485.5 3699.45
Wipro 7 474.05 476.95 470.95 559.05 574.95
Sun Pharmaceutical 8 592.55 607.95 572.15 567.75 588.15
Lupin 9 854.7 887.15 855.45 908.6 882.05
Dr.Reddys 10 2383.65 2455.95 2484.85 2533.05 2607
Name of Scrip ICICI
Month-Year Jan-14 Close Price 988.5
-
8/11/2019 Investors Aid
8/10
4. CONSOLIDATED TABLE
Indications by using Pivot Table:
Analyzing which scrip is more popular in a month
Customizing display format of analysis based on investors needs
Compare share trend whether trading above or below average
-
8/11/2019 Investors Aid
9/10
CONCLUSION
-
8/11/2019 Investors Aid
10/10
THANK YOU