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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
quan.zheng avatar image
3 ●0 ●0 ●2

TR.FOLastTradingDate not available through the Python API

I don't seem to be able to get TR.FOLastTradingDate for some rics using the Python API. I'm able to get it through DIB though. The strange thing is once I have looked it up using DIB, it becomes available through the Python API. Maybe it is cached somewhere? The main question is why can't I get this field TR.FOLastTradingDate for example for the following rics:


ADZ6^1, ADZ5^1, ADU8^1, ADU7^1, ADU6^1, ADM8^1, ADM7^1, ADM6^1, ADH8^1, ADH7^1, ADH6^1, CN7^1, CK8^1, CK7^1

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
jason.ramchandani01 avatar image
6.7k ●8 ●6 ●7

@quan.zheng The RICs you are requesting are all expired rics but I can receive data for all of them. I hope this can help. 

rics = ['ADZ6^1', 'ADZ5^1', 'ADU8^1', 'ADU7^1', 'ADU6^1', 'ADM8^1', 'ADM7^1', 'ADM6^1', 'ADH8^1', 'ADH7^1', 'ADH6^1', 'CN7^1','CK8^1', 'CK7^1']

df, err = ek.get_data(rics, "TR.FOLastTradingDate")

df

1625533422009.png



1625533422009.png (83.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.

quan.zheng avatar image quan.zheng

The rics I mentioned here was a subset of the rics I used. It appears if you have a long list (say 100 rics) Eikon doesn't return TR.FOLastTradingDate for all rics. However if you split this in smaller subsets (say 20 each time), Eikon doesn't have a problem returning TR.FOLastTradingDate for all rics.

jason.ramchandani01 avatar image jason.ramchandani01 quan.zheng
@quan.zheng Well not sure how many other fields you are requesting as well at the same time - but there are API limits. So please be aware of those - in some cases it will be a silent failing - so returning NAs when over the limit, in other cases if data limits are hit a pause in usage until the next day could also happen. I hope this can help.
Click below to post an Idea Post Idea