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

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

jason.ramchandani01

@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

All comments

jason.ramchandani01

@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

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

@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.

EXPLORE OUR SITES