question

Upvotes
Accepted
dgarrard avatar image
66 ●2 ●5 ●7

rd.getHistory with Interval = tas and Conditions

I am trying to retrieve the 'CONDITIONS' data when calling rd_getHistory with the Time and Sales ("tas") interval for equity instruments:

df = rd.get_history(universe, start = "2024-07-18T13:30:00.000", end = "2024-07-18T20:00:00.000", fields=["TRDPRC_1","TRDVOL_1","CONDITIONS"], interval = "tas")

In Workspace if I display the Time and Sales on screen the "Conditions" can be seen. When I run the above code I get no data in the conditions column:

Timestamp,TRDPRC_1,TRDVOL_1,CONDITIONS
2024-07-18 13:30:00.199,170.13,37,
2024-07-18 13:30:02.472,170.15,200,
2024-07-18 13:30:02.472,170.08,1,
2024-07-18 13:30:02.472,170.13,1,
2024-07-18 13:30:02.472,170.13,1,


Thank you



refinitiv-data-platformpython apirefinitiv-data-platform-libraries
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
84.6k ●287 ●53 ●77

@dgarrard

Thank you for reaching out to us.

Please share RICs that you are using. Therefore, I can test it.

You can remove the fields parameter to get all available fields. 

df = rd.get_history(["IBM.N"], 
                    start = "2024-07-18T13:30:00.000", 
                    end = "2024-07-18T20:00:00.000", 
                    #fields=["TRDPRC_1","TRDVOL_1","CONDITIONS"], 
                    interval = "tas")


df.columns

1721372330335.png



1721372330335.png (25.0 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.

dgarrard avatar image dgarrard

Thank you for the rapid response. Here are a few sample rics:

["LEN","ARE.TO","AEM.TO","MU.O"]

dgarrard avatar image dgarrard

QUALIFIERS is giving me some data:

Timestamp,TRDPRC_1,TRDVOL_1,QUALIFIERS

2024-07-18 13:30:00.199,170.13,37, I[GV4_TEXT];ODD[IRGCOND]

2024-07-18 13:30:02.472,170.15,200, [LSTSALCOND]

2024-07-18 13:30:02.472,170.08,1, 4 I[GV4_TEXT]

2024-07-18 13:30:02.472,170.13,1, I[GV4_TEXT];ODD[IRGCOND]

2024-07-18 13:30:02.472,170.13,1, I[GV4_TEXT];ODD[IRGCOND]

2024-07-18 13:30:02.472,170.08,23, 4 I[GV4_TEXT]

2024-07-18 13:30:02.472,169.6,21, O I[GV4_TEXT]

2024-07-18 13:30:02.472,169.81,1, I[GV4_TEXT];ODD[IRGCOND]

2024-07-18 13:30:02.472,170.5,1, I[GV4_TEXT];ODD[IRGCOND]

2024-07-18 13:30:02.472,170.08,23145, O [LSTSALCOND]; [PRC_QL2]


But I am unsure how that maps to Conditions (or not)

Jirapongse avatar image Jirapongse dgarrard

Please contact the Historical Pricing API support team direclty via MyAccount regarding how to use it.

1721382177062.png

1721382177062.png (14.1 KiB)

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.