BDP
Bloomberg Data Point Current price of Infosys PE Ratio of NIFTY EPS of Reliance in FY 2015
BDH
Bloomberg Data History Price of Infosys for the last 1 year PE Ratio of NIFTY every onth fro 2010 to 2 EPS for Reliance fro 2005 to 2015
BDS
Bloomberg Data Set !ll e"ers of NIFTY an# their $ei%hts !ll the sharehol#ers of Sun Phara $ith their
Overrides EPS for the stan#alone copany ICICI 'an( Sales for Infosys for )* 2015
Trend/Growth Analysis of data Am I looking at the right estimates B!ilding large data sheets "h!ndreds of se
)*DS
+,!rrent data avail
)*DS
+Histori#al data av
+',P-.INF/ IN Euity..P 3!ST.4 +',P-.NIFTY In#e..PE In#e.. PE R!TI/.4 R!TI/.4 +',P-.RI3 IN Euity. .IS EPS.4
15
+',6-.INF/ IN Euity..P 3!ST..0782582017..0782782015.4 +',6-. 6-.NIFT IFTY In#e n#e..P ..PE E R!TI/. /..01 .01801 801820 82010..0 .0*8*1 8*1820 82015..P .Per+ er+. +',6-.RI3 IN Euity. .IS EPS. .0*8*182005. .0*8*182015. .Per+fy.
)*DS
hol#in%
+Show b!lk data+
+',S-.NIFTY In#e..IN, 9:EI;6T.4 +',S-.S=NP IN Euity..!33 6/3,ERS P='3IC FI3IN;S +&
+',P-.ICICI'C IN Euity. .IS EPS. .E)Y C/NS/3I,!TE,+N.4 +',P-.INF/ IN Euity. .S!3ES RE< T=RN. .F=N, PER+)*. .E)Y F=N, YE
!rities $ m!lti%le data %oints for ea#h #om%any& in a 'i(y
able+
ilable+
4
!R+2015.4
Po%!lar I-T.0A* )ields
)ormat
INTERS=9 INTER6I;6 INTER3/: INTER!<; INTERPERCENT>C6!N;E INTERST,>,E< INTER,!TE>/F>C!3C>6I INTER,!TE>/F>C!3C>3/
',P-Tic(erInterval Fiel#??overri#es??4
1S. ,AS.S 2hat was the average %ri#e of S.-S.3 in )4 5678 Tic(er
SENSE In#e
+',P-.SENSE In#e..INTER
How m!#h has I- de%re#iated sin#e 9ay 7: 567; Tic(er
INR Curncy
+',P-.INR Curncy..INTER
I want to get the yearly )II investment in India for the last 76 years Tic(er
FIINNET In#e %ives #aily net FII inDo$
+',P-.FIINNET In#e..INTER
2hat was the average %ro
6,FC' IN Euity EPS>;R/:T6
+',P-.6,FC' IN Euity..INTER
Po%!lar Overrides 9!RET>,!T!>/,!TE>/,!TE>/INTER/
N, ,!TE /
/
RT ,!TE /
T!RT ,!TE /
2000101 20100101 20110101 20120101 201*0101 20170101
20012*1 201012*1 201112*1 201212*1 201*12*1 201712*1
FIINNET In#e INTERS=9 @N!9EA @N!9EA @N!9EA @N!9EA @N!9EA @N!9EA
.STI9AT.
Ty%e
'EST 'EST 'EST 'EST 'EST 'EST 'EST 'EST 'EST 'EST 'EST 'EST
contri"ute# contri"ute# contri"ute# contri"ute# contri"ute# contri"ute# contri"ute# contri"ute# contri"ute# contri"ute# contri"ute# contri"ute#
S!3ES /PP E'IT,! NET INC/9E NET ,E'T E< C!PE EPS 'PS ,PS R/E R/!
B.ST )P.IOD O0.ID. 1FY 2FY H0FY
Current Gscal year Net Gscal year Previous Gscal year
1BY 1Y 15Y
Fiscal year 201B Fiscal year 201 Fiscal year 2015
I* I- .=!ity
-Gscal year
B.ST .PS
1FY 2FY H0FY
@N!9EA @N!9EA @N!9EA
1BY 1Y 15Y
@N!9EA @N!9EA @N!9EA
I want to #om%are the .PS estimate for H,* Te#h ag +',P-.6C3T IN Euity..'EST EPS..'EST FPERI/, /
Sol!tion 7> B.ST )P.IOD O0.ID.?7T4 Stitches up the net 7 uarterly estiates to %ive the J 1 year f
+',P-.6C3T IN Euity..'EST EPS..'EST FPERI/, /
Sol!tion 5> B.ST )P.IOD O0.ID.?78B, 'len#e# calen#ar 2015 tries to %et calen#ar year 2015 estiate +',P-.6C3T IN Euity..'EST EPS..'EST FPERI/, /
Sol!tion @> B.ST )P.IOD O0.ID.?7B) 'len#e# For$ar# 1 year ta(es the $ei%hte# avera%e of current a +',P-.6C3T IN Euity..'EST EPS..'EST FPERI/, /
.STI9AT.
Ty%e
'EST 'EST 'EST 'EST
calculate# calculate# calculate# calculate#
PE R!TI/ P 'PS R!TI/ C=R E< T/ E'IT,! ,I< Y3,
current Price #ivi#e# "y EPS estiat current Price #ivi#e# "y 'PS estiat current E< #ivi#e# "y E'IT,! estia ,PS estiate #ivi#e# "y current Pric
IEST E'IT,!R IEST 3/!, F!CT/R
in#ustry in#ustry
Overrides 'EST FPERI/, /
Gscal perio# for $hich you $ant to see the esti "ro(er overri#e HHHL * letter currency co#e HHHL
or $hich the copany is epecte# to report4
inst Infosys FY.4 6C3 Tech Gscal year en#s in Kune so this is sho$i FY.4 Infosys Gscal year en#s in 9arch so this is sho$i
r$ar# estiate
TY.4 Y.4
6C3T IN Euity 'EST EPS
1F) @N!9EA
INF/ IN Euity 'EST EPS
1F) @N!9EA
"y suin% up the uarterly EPS nu"ers -actual8estiates4 of 9arch Kune Sept 5'C.4
6C3T IN Euity
9arH15 12?00
INF/ IN Euity
9arH15 2?10
5'C.4
# net Gscal year estiates to calculate J 12 onth for$ar# estiate 'F.4
6C3T IN Euity 'EST EPS
estiate B8*082015 @N!9EA
INF/ IN Euity 'EST EPS
*8*18201B @N!9EA
'F.4
te
te FP,FM Estiate Source H 'ro(er or !NRM hover on "ro(er nae INR =S, E=R ;'P 6, KPY S;, !=, etc
n% estiate for FY 15 en#in% Kune 2015 % estiate for FY 1B en#in% 9arch 201B
2F) @N!9EA
*F) @N!9EA
7F) @N!9EA
Su @N!9EA
2F) @N!9EA
*F) @N!9EA
7F) @N!9EA
@N!9EA
KunH15 12?B*
SepH15 1*?17
,ecH15 1*?25
Su 51?01
KunH15 2B?7
SepH15 2?21
,ecH15 *0?*7
11*?50
estiate ,ays left in year B8*08201B @N!9EA @N!9EA
,ays in net year @N!9EA
:t !v% @N!9EA
*8*18201 @N!9EA
@N!9EA
@N!9EA
n# ,ec 2015
@N!9EA
I want to download the histori#al ann!al .PS estimates for Infosys sin#e 56 +',6-.INF/ IN Euity..'EST EPS..018018200B..0782582015..'EST FPERI/, /
@N!9EA 118*082011 18*182012 B8*082012 108*182012 128*182012 78*08201* 58*18201* B8*08201* 8*18201* 8*18201* 8*08201* 108*18201* 118*08201* 128*18201* 18*182017 28282017 *8*182017 78*082017 58*182017 B8*082017 8*182017 8*182017 8*082017 108*182017 118*082017 128*182017 18*182015 28282015 *8*182015
171?2 1*?*B 1*?2 12?*B 110?*1 105?5B 102?B* 102?1 10*?*1 10?5 11*?05 11B?1 120?0 121?* 121?0 12B? 12?2 12*?* 11?1 11?1 11B?7B 11B? 11B?B2 11?17 11?0 11?5 120?50 121?B5 121?71 120?
2e !sed B.ST )P.IOD O0.ID. as 7) 7)4 means #!rrent
Data series is giving me the histori#al .PS estimat
:e nee# to use the overri#e
B.ST )P.IOD O0.ID.?7G4 ;eneric year rolls over at the en# of each Gsc So in FY 201* it $ill "e %ivin% estiates for F in FY 2017 it $ill "e %ivin% estiates for FY 1
B.ST )P.IOD O0.ID.?7G4 @N!9EA 2828201* *8*18201* 78*08201* 58*18201* B8*08201* 8*18201* 8*18201* 8*08201* 108*18201* 118*08201* 128*18201* 18*182017 28282017 *8*182017 78*082017 58*182017 B8*082017 8*182017 8*182017 8*082017 108*182017 118*082017 128*182017 18*182015 28282015 *8*182015 78*082015
1?B7 1?2 1?B5 *?B *?5 *?7 B?21 ?7 0?00 1?7B 1?7 1?75 *?05 *?1 2?5 107?50 10*?*B 10*?05 107?B 107?B 105?01 10?00 10B? 10?2 10?2 10?B 10?00 11?*
B.ST )P.IOD O0.ID.?7@4 @N!9EA 2828201* *8*18201* 78*08201* 58*18201* H B8*08201* H 8*18201* H 8*18201* H 8*08201* H 108*18201* H 118*08201* H 128*18201* H 18*182017 H 28282017 H *8*182017 H 78*082017 H 58*182017 H B8*082017 H 8*182017 H 8*182017 H 8*082017 H 108*182017 H 118*082017 H 128*182017 H 18*182015 H 28282015 H *8*182015 H 78*082015 H
1?B7 1?2 1?B5 1?B
6: .4
es for )4 7:
l year 1* an# so on
+',6-.INF/ IN Euity..'EST EPS..018018200B..0782582015..
@N!9EA 118*082011 18*182012 B8*082012 108*182012 128*182012 78*08201* 58*18201* B8*08201* 8*18201* 8*18201* 8*08201* 108*18201* 118*08201* 128*18201* 18*182017 28282017 *8*182017 78*082017 58*182017 B8*082017 8*182017 8*182017 8*082017 108*182017 118*082017 128*182017 18*182015 28282015 *8*182015
171?2 1*?*B 1*?2 12?*B 110?*1 105?5B 102?B* 102?1 10*?*1 10?5 11*?05 11B?1 120?0 121?* 121?0 12B? 12?2 12*?* 11?1 11?1 11B?7B 11B? 11B?B2 11?17 11?0 11?5 120?50 121?B5 121?71 120?
B.ST )P.IOD O0.ID.?7;4 @N!9EA 2828201* *8*18201* 78*08201* 58*18201* B8*08201* 8*18201* 8*18201* 8*08201* 108*18201* 118*08201* 128*18201* 18*182017 28282017 *8*182017 78*082017 58*182017 H B8*082017 H 8*182017 H 8*182017 H 8*082017 H 108*182017 H 118*082017 H 128*182017 H 18*182015 H 28282015 H *8*182015 H 78*082015 H
?52 ?B7 ?7 *?B *?5 *?7 B?21 ?7 0?00 1?7B 1?7 1?75 *?05 *?1 2?5 2?B
B.ST )P.IOD O0.ID.?7 @N!9EA 2828201* *8*18201* 78*08201* 58*18201* B8*08201* 8*18201* 8*18201* 8*08201* 108*18201* 118*08201* 128*18201* 18*182017 28282017 *8*182017 78*082017 58*182017 B8*082017 8*182017 8*182017 8*082017 108*182017 118*082017 128*182017 18*182015 28282015 *8*182015 78*082015
?01 ?0 ?* 2?* 2?20 2?51 5?B1 ?01 101?71 10B?2 10?7* 10?5 110?7 110?* 10?** 107?50 10*?*B 10*?05 107?B 107?B 105?01 10?00 10B? 10?2 10?2 10?B 10?00 10?5
EST FPERI/, /
4
B.ST )P.IOD O0.ID.?7:4 @N!9EA 2828201* H *8*18201* H 78*08201* 58*18201* B8*08201* 8*18201* 8*18201* 8*08201* 108*18201* 118*08201* 128*18201* 18*182017 28282017 *8*182017 78*082017 58*182017 B8*082017 8*182017 8*182017 8*082017 108*182017 118*082017 128*182017 18*182015 28282015 *8*182015 78*082015
105?5B
102?B* 102?1 10*?*1 10?5 11*?05 11B?1 120?0 121?* 121?0 12B? 12?2 12*?* 11?1 11?1 11B?7B 11B? 11B?B2 11?17 11?0 11?5 120?50 121?B5 121?71 120? 11?*
