question

Upvotes
Accepted
jwlee08 avatar image
9 ●4 ●9 ●17

How to get monthly Average data?

Hi,

I am using Eikon in Python.

this is my code:

1702523323215.png

Here is my question:

In the second one, at the fields for some RICs which does not have 'TR.~ ' fields, where to find what to put in AVG(here).

1. is it possible to get monthly data for these RIC in the second one?

2. if so, how to know what to put in AVG() function?


I truly appreciate if anyone would give me an example code

eikoneikon-data-apirefinitiv-dataplatform-eikon#technology#content
1702523323215.png (30.2 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.

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
87.7k ●294 ●53 ●79

@jwlee08

Thank you for reaching out to us.

I think the AVG function could be used with the fields that can provide series data.

You can check this via the Data Item Browser tool.

1702546448510.png

1702546489545.png

TRDPRC_1 doesn't support series data.

You can use another method, such as get_timeseries to get histoical data and then calculate the average.


1702546448510.png (37.1 KiB)
1702546489545.png (26.8 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.

jwlee08 avatar image jwlee08

wow... thank you alot!

please bless you!

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.