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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

Wrong volumes in 1 min bar get_timeseries for London equities.

It looks as if the volumes given for london equities (eg BP.L) are wrong when pulling 1min bars through get_timeseries(). Off by couple orders magnitude!

any idea?

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.

Upvotes
Accepted
18k 21 12 20

Hi @kenley.macandog , @t.hubert

You can use interval="tas" to retrieve timeseries information.

Here is the sample code:

df = ek.get_timeseries('BP.L', fields=['BID','ASK','TRDPRC_1','VALUE','COUNT'],
                       start_date="2020-02-13", end_date="2020-02-14", interval="tas")
df
But I think it is not possible to know which one is regular trade.

Please see the (small amount of the) data point below:






ahs.png (128.2 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.

Upvotes
18k 21 12 20

Hi @t.hubert

Here is the sample API call to retrieve 1-minute bar data.

However, for data clarification, please contact Refinitiv Content Helpdesk at https://my.refinitiv.com

They will be able to confirm which you on any content questions.


ahs.png (27.2 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.

Upvotes
1 0 0 0

I know how to get the bars, I am just pointing out that those volume numbers make no sense at all. 1 billion BP shares traded in one minute? eh?

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.

Upvotes
18k 21 12 20

Hi @t.hubert

I posted the sample code just to make sure that the API call is correct.

For content clarification, please contact Refinitiv Content Helpdesk at https://my.refinitiv.com

Moderators in this forum cannot confirm content behavior.

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.

Upvotes
3 0 0 2

@chavalit.jintamalit Client Tony Hubert reached us for the data issue.


I have engaged our Data Team and confirmed that London Stock Exchange (LSE) is providing volume data on FID 1031 which is the data being retrieved in the call retrieval you provided.


FID1031 displays both regular trades and theoretical trades from the exchange feed. This is why we are getting millions or billions of trade volume on the auction session (pre/post market). I have confirmed that this data logic has been like this for quite a while and Refinitiv has no control on the flow of data.


We have a way to filter out theoretical trades/data in Eikon apps like the CHT and TAS app. However the issue lies on those using fields to consume the data like those using API and Eikon Excel.


Need assistance if you can help client to check other call retrieval in Python which will only retrieve data from the regular trading session which is between 08:00- 16:30 London Time. This is the only workaround I can think of. If you also know other fields to use in Python, please share it to client.


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.

Upvotes
1 0 0 0

For the moment I am doing exactly this: imposing continuous trading hours on the data retrieved. The problem with this however is that opening auctions tend to open not exactly but a random amount of time after 0800 London time.

Also London has an intra ay auction at 1100 London time which may last a minimum of 2 minutes.

Another auction that should then be filtered out is the expiration auction every third friday of the month.

And then you have the ciruit breaker auctions that can happen any random moment.

So I guess the only option is filtering out any number that is x standard deviations away from normal.

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