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

Best Answer

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

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @Jerome Cadahing

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

    These are parameters for TR.AssetLocationLongitude.

    image

    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.

  • Solved it thanks !