question

Upvotes
Accepted
23 0 3 2

Name of Reuters Fields from OHCL bars

I am requesting bars from the rdp api, can you tell me what the filed names are for Open, High, Low, Close and VWAP for intra day bars ?


Thx

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

Upvote
Accepted
6.7k 12 5 8

hi @gordon.konheiser ,

The answer provided in the help desk ticket you raised is below

We have the below data fields for OHLC in Excel.
TR.OPENPRICE
TR.HIGHPRICE
TR.LOWPRICE
TR.CLOSEPRICE

We also have fields available in Quote app which can be OPEN_PRC,HIGH_1, LOW_1,TRDPRC_1. This represents the OHLC

I've tried using RD Library to retrieve mentioned fields and here's the result

1662458209629.png

Please let me know in case you have any further questions.


1662458209629.png (58.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.

Upvote
16.7k 42 12 19

Hi @gordon.konheiser,

You can invoke the intraday-summaries endpoint on the API playground and see all the data fields that are returned. I don't see a VWAP field, so you might have to calculate it in your app.


1661175830054.png


1661175830054.png (132.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.

Upvotes
23 0 3 2

Hi I have looked at the playground, but I am not finding the correct field for the open and close of a bar:

1661252790966.png



1661252790966.png (5.7 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.

Upvote
16.7k 42 12 19

I think it is some combination of the fields OPEN_BID, OPEN_ASK, BID_HIGH, ASK_HIGH etc. For content clarification it is best to raise a ticket at my.refinitiv.com and directly speak with a content expert.

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
23 0 3 2

No that is not correct, (traditional) OLHC bars are based on Trades only not bid and ask. I was ask the help desk.

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.