Obtain duplicate previous_data on days when there is no data

Question

question

jwlee08

9 ●3 ●4 ●10

Obtain duplicate previous_data on days when there is no data

It's been a long time.

I have a few questions.

First of all, it is an issue that occurred in the process of bringing gold prices from LBMA ( AM and PM).

If you look at this image below , there's no VALUE on the 23rd and 30th.

If you use the function GET_HISTORY you provided,

On the 23rd and 30th, each day has same price with previous day.

Is it able to controll the day which does not has value by putting some parameter or other ways?

On the other hands , CMZN0 which is the ZN value of LME. In this case, the date itself doesn't come up and the price doesn't come up on holidays.

Does each market have a different policy?

We would like to solve this problem using the GET_HISTORY function.

In the case of GETDATA, it is not easy to identify a definite date or bring past data.

In addition I just found out that someone says that by using get_timeseries can show up like image below which mean it shows blank value as<NA>

However in my case it does not have difference with using get_history.

Is it a difference with license?

I will wait for your kind reply.

And happy new year!

eikon-data-api #technology #content data

1672740760202.png (62.6 KiB)

1672740775749.png (90.7 KiB)

Jan 03, 2023 at 10:14 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raksina.samasiri Jan 05, 2023 at 03:35 AM

<AHS>

seems to be the same case with https://community.developers.refinitiv.com/questions/101171/managing-null-data-through-eikon-api.html

Jirapongse Jan 18, 2023 at 05:09 AM

The case #12068757 has been created.

wasin.w Jan 25, 2023 at 06:23 AM

<AHS>

Case 12068757 is still in "Working in Progress" status. Extending triage for a week.

raksina.samasiri Feb 01, 2023 at 06:44 AM

<AHS>

Case 12068757 is still in "Working in Progress" status. Extending triage for a week.

Jirapongse Feb 08, 2023 at 07:06 AM

@jwlee08

Hi,

Thank you for your participation in the forum.

Are any of the replies 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

Show more comments

Answer 1 · 2023-01-05T07:00:53Z

raksina.samasiri

14.2k ●30 ●5 ●10

Hi @jwlee08 ,

We apologize for this inconvenience. Ticket number 12068757 has been raised on your behalf and the technical support team is going to contact you to assist with this.

Jan 05, 2023 at 07:00 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jwlee08 Jan 06, 2023 at 07:05 AM

I've received remote support from the developer in charge.

they decided to contact the team that can solve the issue now and contact you again, but can you tell me how long you'll contact me?

raksina.samasiri jwlee08 Jan 11, 2023 at 03:57 AM

Hi @jwlee08 ,

Now the issue is under investigation and the support team will keep you updated.

wasin.w jwlee08 Feb 15, 2023 at 10:07 AM

Hello @jwlee08

I checked case 12068757, the issue is resolved now.

Answer 2 · 2023-01-03T10:16:01Z

jwlee08

9 ●3 ●4 ●10

this is the one that shows <NA> on the day which does not have data

this is my case that shows duplicate data

1672740904732.png (102.5 KiB)

1672740913771.png (101.1 KiB)

Jan 03, 2023 at 10:16 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2023-01-03T22:05:42Z

nick.zincone

17.2k ●82 ●39 ●63

Hi @jwlee08

Can you confirm the version of the Refinitiv Data Library for Python you are using?

I was able to retrieve the expected data using the following API call:

rd.get_history(universe=['XAUFIXPM=', 'XAUFIXAM='], fields=['TRDPRC_1'])

I'm using CodeBook and the version installed is: 1.0.0b27.

Here is the result:

ahs.png (46.2 KiB)

Jan 03, 2023 at 10:05 PM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jwlee08 Jan 04, 2023 at 01:35 AM

I found out it is

rd : 1.0.0b24

jwlee08 Jan 04, 2023 at 01:58 AM

I checked that I use the same version of library in codebook

but result is still same

1672797520145.png (62.8 KiB)

Answer 4 · 2023-01-04T01:31:40Z

jwlee08

9 ●3 ●4 ●10

could you tell me how could I check the version of Refinitiv Data Library for Python

and if i needed how could i update the version?

Jan 04, 2023 at 01:31 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 5 · 2023-01-04T14:20:52Z

nick.zincone

17.2k ●82 ●39 ●63

Hi @jwlee08

Thanks for confirming your version and your results.

I believe the issue you are facing has been resolved in a newer version of the library. If you are required to do this within CodeBook, I would suggest you contact Help & Support within the desktop via the Help menu option or by the function key (F1) and determine if your desktop can be updated within a newer version of the library. If you have your own Jupyter Notebook environment, you should be able to update your library version yourself via PyPi.

Trying the same command within my instance resulted in a correct response.

ahs.png (42.1 KiB)

Jan 04, 2023 at 02:20 PM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jwlee08 Jan 05, 2023 at 01:25 AM

this is from codebook

this is from my visual studio code

I've updated the library to recent version but I see the same thing...

1672881851217.png (31.1 KiB)

1672881884920.png (84.8 KiB)

nick.zincone jwlee08 Jan 05, 2023 at 06:21 PM

Hi @jwlee08

Please use the rd.get_history() instead - that is what I'm using.

Answer 6 · 2023-01-05T03:42:00Z

raksina.samasiri

14.2k ●30 ●5 ●10

Hi @jwlee08 ,

I cannot reproduce the issue. However, as an alternative way, can you please try to put the parameter 'raw_output=True' to get the output in Python dict format instead. With this parameter, I assume the date with NA will not be returned in the output as shown in the screenshot below.

Then this Python dict can be converted to the dataframe as you would like. Please also post the raw_output result here for further investigation.

timeseries_json = ek.get_timeseries(['XAUFIXPM=', 'XAUFIXAM='], raw_output=True)
timeseries_json

The help function in Python is going to return the available parameters and theirs description, including the description of raw_output parameter

help(ek.get_timeseries)

1672890081091.png (98.2 KiB)

Jan 05, 2023 at 03:42 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raksina.samasiri Jan 05, 2023 at 03:44 AM

Plus, this code is running in the Eikon Codebook app which uses the same version of the Eikon Data API Python library as yours and I still cannot reproduce an issue.

1672890258904.png (33.2 KiB)

jwlee08 raksina.samasiri Jan 05, 2023 at 05:12 AM

You said you can't reproduce this error.

Both the library version and the eikon desktop version are up to date, which means that there are other minor or unexpected problems, so can I ask for remote assistance?

Q&A Forum

question

Obtain duplicate previous_data on days when there is no data

6 Answers

Write an Answer

question

Obtain duplicate previous_data on days when there is no data

6 Answers

Write an Answer

Related Questions