question

Upvotes
Accepted
jwlee08 avatar image
9 ●3 ●5 ●13

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.

2 Answers

· Write an Answer
Upvotes
Accepted
raksina.samasiri avatar image
14.9k ●32 ●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
83.1k ●281 ●53 ●77

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