Download - API Training Sheet
-
7/24/2019 API Training Sheet
1/21
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
-
7/24/2019 API Training Sheet
2/21
)*DS +,!rrent data avail
+',P-.INF/ IN Euity..P 3!ST.4
+',P-.NIFTY In#e..PE R!TI/.4
+',P-.RI3 IN Euity. .IS EPS.4
)*DS +Histori#al data av
+',6-.INF/ IN Euity..P 3!ST..0782582017..0782782015.4
15 +',6-.NIFTY In#e..PE R!TI/..0180182010..0*8*182015..Per+.
+',6-.RI3 IN Euity. .IS EPS. .0*8*182005. .0*8*182015. .Per+fy.
)*DS +Show b!lk data+
+',S-.NIFTY In#e..IN, 9:EI;6T.4
hol#in%
+',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
+',S-.S=NP IN Euity..!33 6/3,ERS P='3IC FI3IN;S+&
-
7/24/2019 API Training Sheet
3/21
able+
ilable+
4
!R+2015.4
-
7/24/2019 API Training Sheet
4/21
Po%!lar I-T.0A* )ields )ormat
INTERS=9 ',P-Tic(erInterval Fiel#??overri#es??4
INTER6I;6
INTER3/:
INTER!C6!N;E
INTERST,>,E/F>C!3C>6I
INTER,!TE>/F>C!3C>3/
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
@N!9EA
How m!#h has I- de%re#iated sin#e 9ay 7: 567;
Tic(er INR Curncy
+',P-.INR Curncy..INTER
@N!9EA
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
@N!9EA
2hat was the average %ro
-
7/24/2019 API Training Sheet
5/21
+',P-.6,FC' IN Euity..INTER
@N!9EA
-
7/24/2019 API Training Sheet
6/21
Po%!lar Overrides
9!RET>,!T!>/,!TE>/,!TE>/INTER
CRNCY
PERI/,ICITY>/
-
7/24/2019 API Training Sheet
7/21
RT ,!TE /
-
7/24/2019 API Training Sheet
8/21
FIINNET In#e
T!RT ,!TE /2000101 20012*1 @N!9EA
20100101 201012*1 @N!9EA
20110101 201112*1 @N!9EA20120101 201212*1 @N!9EA
201*0101 201*12*1 @N!9EA
20170101 201712*1 @N!9EA
-
7/24/2019 API Training Sheet
9/21
-
7/24/2019 API Training Sheet
10/21
.STI9AT.
-
7/24/2019 API Training Sheet
11/21
+',P-.6C3T IN Euity..'EST EPS..'EST FPERI/, /
-
7/24/2019 API Training Sheet
12/21
.STI9AT.
-
7/24/2019 API Training Sheet
13/21
6C3T IN Euity 1F)
TY.4 'EST EPS @N!9EA
Y.4 INF/ IN Euity 1F)
'EST EPS @N!9EA
"y suin% up the uarterly EPS nu"ers -actual8estiates4 of 9arch Kune Sept
5'C.4 6C3T IN Euity 9arH15
12?00
5'C.4
INF/ IN Euity 9arH15
2?10
# net Gscal year estiates to calculate J 12 onth for$ar# estiate
estiate
'F.4 6C3T IN Euity B8*082015
'EST EPS @N!9EA
'F.4
INF/ IN Euity *8*18201B
'EST EPS @N!9EA
-
7/24/2019 API Training Sheet
14/21
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
-
7/24/2019 API Training Sheet
15/21
2F) *F) 7F) Su
@N!9EA @N!9EA @N!9EA @N!9EA
2F) *F) 7F)
@N!9EA @N!9EA @N!9EA @N!9EA
n# ,ec 2015
KunH15 SepH15 ,ecH15 Su
12?B* 1*?17 1*?25 51?01
KunH15 SepH15 ,ecH15
2B?7 2?21 *0?*7 11*?50
estiate
B8*08201B :t !v%
@N!9EA @N!9EA @N!9EA @N!9EA
*8*18201
@N!9EA @N!9EA @N!9EA @N!9EA
,ays left inyear
,ays innet year
-
7/24/2019 API Training Sheet
16/21
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/, /
-
7/24/2019 API Training Sheet
17/21
B.ST )P.IOD O0.ID.?7G4 B.ST )P.IOD O0.ID.?7@4
@N!9EA 1?B7 @N!9EA 1?B7
2828201* 1?2 2828201* 1?2
*8*18201* 1?B5 *8*18201* 1?B5
78*08201* *?B 78*08201* 1?B
58*18201* *?5 58*18201* HB8*08201* *?7 B8*08201* H
8*18201* B?21 8*18201* H
8*18201* ?7 8*18201* H
8*08201* 0?00 8*08201* H
108*18201* 1?7B 108*18201* H
118*08201* 1?7 118*08201* H
128*18201* 1?75 128*18201* H
18*182017 *?05 18*182017 H
28282017 *?1 28282017 H
*8*182017 2?5 *8*182017 H78*082017 107?50 78*082017 H
58*182017 10*?*B 58*182017 H
B8*082017 10*?05 B8*082017 H
8*182017 107?B 8*182017 H
8*182017 107?B 8*182017 H
8*082017 105?01 8*082017 H
108*182017 10?00 108*182017 H
118*082017 10B? 118*082017 H
128*182017 10?2 128*182017 H
18*182015 10?2 18*182015 H28282015 10?B 28282015 H
*8*182015 10?00 *8*182015 H
78*082015 11?* 78*082015 H
-
7/24/2019 API Training Sheet
18/21
6:
.4 +',6-.INF/ IN Euity..'EST EPS..018018200B..0782582015..
@N!9EA 171?2
118*082011 1*?*B
18*182012 1*?2B8*082012 12?*B
108*182012 110?*1
128*182012 105?5B
78*08201* 102?B*
58*18201* 102?1
B8*08201* 10*?*1
8*18201* 10?5
8*18201* 11*?05
8*08201* 11B?1
108*18201* 120?0118*08201* 121?*
128*18201* 121?0
18*182017 12B?
28282017 12?2
*8*182017 12*?*
78*082017 11?1
es for )4 7: 58*182017 11?1
B8*082017 11B?7B
8*182017 11B?
8*182017 11B?B28*082017 11?17
108*182017 11?0
118*082017 11?5
128*182017 120?50
18*182015 121?B5
28282015 121?71
*8*182015 120?
l year
1*
an# so on
-
7/24/2019 API Training Sheet
19/21
B.ST )P.IOD O0.ID.?7;4 B.ST )P.IOD O0.ID.?7
@N!9EA ?52 @N!9EA ?01
2828201* ?B7 2828201* ?0
*8*18201* ?7 *8*18201* ?*
78*08201* *?B 78*08201* 2?*
58*18201* *?5 58*18201* 2?20B8*08201* *?7 B8*08201* 2?51
8*18201* B?21 8*18201* 5?B1
8*18201* ?7 8*18201* ?01
8*08201* 0?00 8*08201* 101?71
108*18201* 1?7B 108*18201* 10B?2
118*08201* 1?7 118*08201* 10?7*
128*18201* 1?75 128*18201* 10?5
18*182017 *?05 18*182017 110?7
28282017 *?1 28282017 110?*
*8*182017 2?5 *8*182017 10?**78*082017 2?B 78*082017 107?50
58*182017 H 58*182017 10*?*B
B8*082017 H B8*082017 10*?05
8*182017 H 8*182017 107?B
8*182017 H 8*182017 107?B
8*082017 H 8*082017 105?01
108*182017 H 108*182017 10?00
118*082017 H 118*082017 10B?
128*182017 H 128*182017 10?2
18*182015 H 18*182015 10?228282015 H 28282015 10?B
*8*182015 H *8*182015 10?00
78*082015 H 78*082015 10?5
-
7/24/2019 API Training Sheet
20/21
-
7/24/2019 API Training Sheet
21/21
4 B.ST )P.IOD O0.ID.?7:4
@N!9EA 105?5B
2828201*H
*8*18201*H
78*08201* 102?B*
58*18201* 102?1B8*08201* 10*?*1
8*18201* 10?5
8*18201* 11*?05
8*08201* 11B?1
108*18201* 120?0
118*08201* 121?*
128*18201* 121?0
18*182017 12B?
28282017 12?2
*8*182017 12*?*78*082017 11?1
58*182017 11?1
B8*082017 11B?7B
8*182017 11B?
8*182017 11B?B2
8*082017 11?17
108*182017 11?0
118*082017 11?5
128*182017 120?50
18*182015 121?B528282015 121?71
*8*182015 120?
78*082015 11?*