question

Upvotes
Accepted
31 3 6 1

How to use TR.LotSize as a time-series?

Hello,

I'd like to know if TR.LotSize can be used as a time series in Python or in Excel. With any frequency (daily, monthly, etc).

The main goal I have with this is to request previous availability for lot sizes rather than just a 'present-day' snapshot (which is how I think CF_LotSize is meant to be used for).

Can we use CF_LotSize for this purpose? Or is not possible to have such request using Eikon at the moment?

Thanks!

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apiexcelfields
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvote
Accepted
39.4k 78 11 27

The best resource to answer content question such as "can I view the history of lot size for a given instrument anywhere in Eikon" is Thomson Reuters Helpdesk, which you can reach by either calling the Helpdesk number in your country or by using Contact Us capability in your Eikon application. Assuming the question is about stocks or futures, I'd be surprised if this info were available in Eikon, since the lot size for any given exchange traded instrument doesn't change with any frequency. When the lot size changes it's an extraordinary event. But I'm not a content specialist. For authoritative answer, please contact TR Helpdesk.
You're correct to assume that CF_LOTSIZE will only return current value. TR.LotSize can theoretically return timeseries, but I'm struggling to find any instrument for which this field is populated.

icon clock
10 |1500

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

I asked because I struggled as well and I'm working with a large universe (around 40K stocks, obviously splitted in smaller chunks so I don't have issues with the Eikon requests).

But this answer is still great!

Thanks a lot Alex!

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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