Pricehistory for Date Range get Requested Date in Result

Question

question

felix.roberto.read

1 ●0 ●0 ●1

Pricehistory for Date Range get Requested Date in Result

I am doing the following Request in code book, that i need to replicate in C#

import refinitiv.data as rd
rd.open_session()
df = rd.get_data(
    universe = ['NCSM.O','ZYNE.O'],
    fields = [
        'TR.PriceClose',
        'TR.Volume',
        'TR.PriceCloseDate'
    ],
    parameters={
        'SDate': '2024-09-11',
        'EDate': '2024-09-01'
    }
)

display(df)

And i get this result

result 

0 NCSM.O20.415902 2024-09-11 
1 NCSM.O20.884412988 2024-09-10
2 NCSM.O21.555194 2024-09-09
3 NCSM.O20.864047 2024-09-06
4 NCSM.O21.1711898 2024-09-05
5 NCSM.O20.964102 2024-09-04
6 NCSM.O20.7418982 2024-09-03
7 ZYNE.O1.302023-10-10
8 ZYNE.O1.302023-10-10
9 ZYNE.O1.302023-10-10
10 ZYNE.O1.302023-10-10
11 ZYNE.O1.302023-10-10
12 ZYNE.O1.302023-10-10
13 ZYNE.O1.302023-10-10

As you see for ZYNE i get the Last Priced Date,
Is there a way i can add to my series, the date that the response is for?
for example

7 ZYNE.O1.302023-10-10.2024-09-11
8 ZYNE.O1.302023-10-10.2024-09-10
9 ZYNE.O1.302023-10-10.2024-09-09
10 ZYNE.O1.302023-10-10.2024-09-06
11 ZYNE.O1.302023-10-10.2024-09-05
12 ZYNE.O1.302023-10-10.2024-09-04
13 ZYNE.O1.302023-10-10.2024-09-03

Here is the code i use to run in C#

                Frame<int, string> frame = privateEikon.GetData(
                    securities,
                    fields,
                    new Dictionary<string, string> { { "SDate", startDate }, { "EDate", endDate }, { "Frq", "D" } }
                );

workspace #technology c#time-series refinitiv-data-libraries

Sep 13 at 02:23 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.

felix.roberto.read Sep 12 at 01:27 PM

to clarify the reason i need to do this, is becuase i request a group of fields, incluiding volumen a vwap, and this is important to know for what date i requested it.

Answer 1 · 2024-09-13T04:47:00Z

Jirapongse

85.2k ●290 ●53 ●77

@felix.roberto.read

Thank you for reaching out to us.

I found that the ZYNE.O has been delisted in 2023 and the lastest price was on 10-10-2023. You can contact the content support team directly via MyAccount to verify this.

For C#, please use the Refinitiv Data Library for .Net. The sample code is available on GitHub. The code looks like this:

                response = FundamentalAndReference.Definition().Universe("NCSM.O","ZYNE.O")
                                                               .Fields("TR.PriceClose.Date","TR.PriceClose","TR.Volume")
                                                               .Parameters(new Newtonsoft.Json.Linq.JObject()
                                                               {
                                                                   ["SDATE"] = "2024-09-01",
                                                                   ["EDATE"] = "2024-09-11",
                                                                   ["FRQ"] = "D"
                                                               }).GetData();

The output is:

If the product returns the close price of ZYNE.O on 2024-09-11, it will confuse many users because this RIC is not a valid RIC anymore.

1726202092191.png (40.8 KiB)

Sep 13 at 04:47 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.

Q&A Forum

question

Pricehistory for Date Range get Requested Date in Result

1 Answer

Write an Answer

question

Pricehistory for Date Range get Requested Date in Result

1 Answer

Write an Answer

Related Questions