question

Upvotes
Accepted
jwlee08 avatar image
9 ●3 ●4 ●10

Historical Dataset is wrong in Python.

Hello,

Today, I tried to get Average Price of RIC : CMZN0 on January, 2024 and get Daily Price then sum all of them and divide for average on January, 2024 so that I wanted to see entire provided data is correct.

However, it does not provide same dataset between them.

Here is what i got:

1706232016014.png

1706232105267.png

I think it has to be the same these data.

Or i assume that 'TR.OFFICIALASKPRICE' and 'TRDPRC_1' fields are showing different data.

I was told these fields are displaying same data so i am using like this.


If i was wrong, Please could you tell me what fields i can use when using 'get_history' function?

Here is the code i used in python:

history = rd.get_history(["CMZN0"],["TRDPRC_1","TR.OFFICIALASKPRICE"],end='2024-01-25',interval='daily', count=30)

print(history)


Thank you in advance.

eikoneikon-data-apirefinitiv-dataplatform-eikon#technology#content
1706232016014.png (135.6 KiB)
1706232105267.png (72.6 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.

wasin.w avatar image   wasin.w

Hello @jwlee08

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

2 Answers

· Write an Answer
Upvotes
Accepted
raksina.samasiri avatar image
14.2k ●30 ●5 ●10

Hi @jwlee08 ,

Thank you for your patience, could you try the field OFF_ASK to retrieve this data

history = rd.get_history(["CMZN0"],['OFF_ASK'],start='2024-01-01',end='2024-01-25',interval='daily', count=30)
history

1707479416171.png



1707479416171.png (12.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.

Upvotes
Jirapongse avatar image
79.2k ●251 ●52 ●74

@jwlee08

Thank you for reaching out to us.

I don't have permission to access this RIC so I can't verify the data. However, if you don't specify the fields parameter, the response will contain all available real-time fields for this RIC.

history = rd.get_history(["CMZN0"],end='2024-01-25',interval='daily', count=30)

After that, you can check which field that can provide the official ask values.

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
Hi~

I already tried that without specific fields but it gives me the same as the picture i posted...

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.