question

Upvotes
Accepted
Jerome Cadahing avatar image
1 ●0 ●0 ●1

API Code for Eikon

Hi, I am using Eikon API on Python and i am doing a request for some boat location. My problem is that I am receiving data on a too small aggregation. For instance, i would like to have only one observation per week. Can you help me with that ? Below an example of my request:

trial45 = ek.get_data("C}KL7309431343" ,["TR.AssetName","TR.AssetStatus","TR.AssetCubicCapacity","TR.AssetLocationDate","TR.AssetLocationLatitude","TR.AssetLocationLongitude"], {'Sdate':'2020-10-01','EDate':'2020-10-15','FRQ':'M'}). Thank you

eikonpythoneikon-com-apiapi
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.

3 Answers

Upvotes
Accepted
jason.ramchandani01 avatar image
6.7k ●8 ●6 ●7

@Jerome Cadahing Please try this:

df,err = ek.get_data("C}KL7309431343" ,["TR.AssetName","TR.AssetStatus","TR.AssetCubicCapacity", "TR.AssetLocationDate","TR.AssetLocationLatitude","TR.AssetLocationLongitude"], {'Sdate':'2020-10-01','EDate':'2020-10-15','VDT':'True'})

df

which gives one reading per day - it is then easy for you to select which weekly reading you want to extract from either say on a friday or monday etc. using date manipulations.

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
Jirapongse avatar image
38.1k ●69 ●35 ●53

@Jerome Cadahing

You can use the Data Item Browser (DIB) application to verify available parameters for TR.AssetLocationLongitude.

These are parameters for TR.AssetLocationLongitude.

You can try those parameters.

For more information, please refer to this article.

You may also contact the Eikon support team via MyRefinitiv for the meaning of each parameter.


1603181997372.png (26.4 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
pierre.vareilles1 avatar image
1 ●0 ●0 ●0 
Solved it thanks !
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