For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
akshay.kaushal avatar image
20 ●1 ●0 ●3

Access denied when accessing TR field data from Eikon Data API, Excel Add-in working fine

Hi Team,

I am receiving the following error when trying to access DPS value from Eikon Data API for my company say 'Metlife':

(  Instrument  Dividend Per Share  Company Market Cap  Price Close 0        MET                <NA>        3.291184e+10        36.26, [{'code': 221,   'col': 1,   'message': 'The access to field(s) denied.',   'row': 0}])

It's able to retrieve Market Cap and Close price but not the DPS. However, I am able to pull the DPS value easily when using Excel Add-in. My code is as given below:

data = ek.get_data('MET', ['TR.DPS','TR.CompanyMarketCap','TR.PriceClose'])

data


I need to retrieve this data in order to update some files regularly. Could you please help me out with it? Thank you

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
Jirapongse avatar image
38.1k ●71 ●35 ●53

@akshay.kaushal

I got the same error when requesting TR.DPS on both Eikon Excel and Eikon Data API.


(  Instrument  Dividend Per Share  Company Market Cap  Price Close  0        MET                <NA>        3.381043e+10        37.25,  [{'code': 221,    'col': 1,    'message': 'The access to field(s) denied.',    'row': 0}])

Can you try the below formula in Eikon Excel?

=@TR("MET","TR.DPSActValue;TR.DPS","CH=Fd RH=IN",B3)

Moreover, I am unable to find TR.DPS when using the Data Item Browser and Excel Formula Builder tools.



1601349002506.png (17.6 KiB)
1601349357942.png (75.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea