question

Upvotes
Accepted
1 1 1 1

How can we get historical data pricing including "Volume" in dollars and not in shares?

Hi,

We are using the .Net Core library "Refinitiv.Data.Content" (https://www.nuget.org/packages/Refinitiv.Data.Content/1.0.0-beta1). We are connecting to the eikon app, running in our computer, using the AppKey we generated in the Eikon.
How can we get historical data pricing including "Volume" in dollars and not in shares?

eikonrdp-apirefinitiv-data-platformhistoricalvolume
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.

@eugenelimtbc

Thank you for your participation in the forum. Are any of the replies below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply that best answers your question. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

-AHS

@eugenelimtbc

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thanks,

AHS

Upvotes
Accepted
39.4k 77 11 27

@eugenelimtbc

The following request retrieves daily volume in shares, VWAP and turnover (or volume in monetary units) for the RIC IBM.N.

string[] fields = { "ACVOL_UNS", "VWAP", "TRNOVR_UNS" };
var response = Summaries.Definition("IBM.N")
                .Fields(fields)
                .Interval(Summaries.Interval.P1D)
                .GetData();

The list of fields available differs by instrument. As @nick.zincone.1 said, you can retrieve all fields available for a given instrument by omitting the Fields method from the above.

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
17.1k 80 39 63

Hi @eugenelimtbc,

The Refinitiv Data Library for .Net creates a wrapper around the RDP HistoricalPricing endpoint. I don't believe the service provides a field for the Volume in dollars within the native response. You can actually see the all historical pricing fields available by simply leaving out the.Fields() specification in the request, i.e:

response = Summaries.Definition("VOD.L").Count(2)
                                        .Interval(Summaries.Interval.P1M)
                                        .GetData();

The response data will contain the values for all available fields within the response. To get a complete list of the field name, you can do this:

Console.WriteLine($"Fields:\n{string.Join("\n", 
             response.Data.Fields?.Select(f => $"\t{f.Name} ({f.Type})"))}");


The library is only an interface to the backend service. I would suggest you contact the helpdesk if you want to better understand what data is available within this service.

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
1 1 1 1

Hi @nick.zincone.1


Thanks for your answer.

So, how can we get historical data with volume in dollars? Is there some other endpoint, or can we get it from eikon api? Maybe we can calculate it somehow?

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.

Hi @eugenelimtbc,

Are you talking about Market cap? Are you limited to using .Net? Many of the advocates on this forum can provide assistance when using the APIs and are not content specialists which is why I suggested reaching out to the helpdesk which can guide you of the calculation and/or where the data may live.

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.