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


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+&


3/21

able+

ilable+

4

!R+2015.4


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


5/21

+',P-.6,FC' IN Euity..INTER

@N!9EA


6/21

Po%!lar Overrides

9!RET>,!T!>/,!TE>/,!TE>/INTER

CRNCY

PERI/,ICITY>/


7/21

RT ,!TE /


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


9/21


10/21

.STI9AT.


11/21

+',P-.6C3T IN Euity..'EST EPS..'EST FPERI/, /


12/21

.STI9AT.


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


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


15/21

2F) *F) 7F) Su

@N!9EA @N!9EA @N!9EA @N!9EA

2F) *F) 7F)


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%


*8*18201


,ays left inyear

,ays innet year


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/, /


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


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


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


20/21


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?*

api training sheet

Documents