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 @david.colas ,


Thank you for your participation in the forum.


Is the reply below satisfactory in resolving your query?


If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.


Otherwise please post again offering further insight into your question.


Thanks,


AHS

Hi,

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

Thanks,

AHS

Upvotes
Accepted
79.2k 251 52 74

@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
79.2k 251 52 74

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