Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 2

I am unable to extract the time series of the following RIC: ".FTBG05GBPT"

I am unable to extract the time series of the following RIC: ".FTBG05GBPT" via ek.get_timeseries.


I encounter the following error: "ValueError: datetime64/timedelta64 must have a unit specified".

#technologytimeseries
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.

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thanks,

AHS

Upvotes
Accepted
80.3k 259 52 75

@david.colas

Eikon Data API is expected to see the TIMESTAMP field in the response.

'fields': [{'name': 'TIMESTAMP', 'type': 'DateTime'},
    {'name': 'HIGH', 'type': 'Double'},
    {'name': 'CLOSE', 'type': 'Double'},
    {'name': 'LOW', 'type': 'Double'},
    {'name': 'OPEN', 'type': 'Double'},
    {'name': 'COUNT', 'type': 'Long'},
    {'name': 'VOLUME', 'type': 'Double'}],
   'ric': 'IBM.N',
   'statusCode': 'Normal'}]}

However this RIC <.FTBG05GBPT> returns the NDA_DATE filed so the API is unable to parse the response.

 'fields': [{'name': 'NDA_DATE', 'type': 'DateTime'},
    {'name': 'NDA_LAST', 'type': 'Double'}],
   'ric': '.FTBG05GBPT',
   'statusCode': 'Normal'}]}

I tested it again and it works now.

1675837279436.png


1675837279436.png (29.3 KiB)
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.

Hi, thank you for your response. Yes, it works because the data content team mapped again this data. Thank you.

Upvote
80.3k 259 52 75

@david.colas

Thanks for reaching out to us.

What is the version of Eikon Data API that you are using?

I am using 1.1.16 and got the following error.

ValueError: 'TIMESTAMP' is not in list

You may set the raw_output to True to get the raw data instead of DataFrame.

ek.get_timeseries(['.FTBG05GBPT'], raw_output=True)

1675220150842.png



1675220150842.png (38.0 KiB)
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.

Upvotes
1 0 0 2

Hi, my version is the 1.1.15, but my query is as follows:

ek.get_timeseries(

rics='.FTBG05GBPT',

fields='CLOSE',

)


If I remove the fields arg, and I set raw_output=True It works as you, but why is not working? I have a process defined as before. It doesn't look very consistent.

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.

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.