question

Upvotes
Accepted
leticia.bernal avatar image
1 ●0 ●1 ●3

How can we extract avg trading price?

I would like to have confirmation definition for the following Functions/Expressions

AVG#(P,Start Date,End Date) - it is referred to the Average Traded price in one day ?
MIN#(P,Start Date,End Date) - it is referred to the Minimum Trading price in one day ?
MAX#(P,Start Date,End Date) - it is referred to the Maximum Trading price in one day ?

I specifically want to get the following information of values for one specific date (let’s say 09 – 07 – 2019):

  • -Previous close
  • -Closing price.
  • -Ask price
  • -Bid price
  • -Average daily Traded price
  • -Minimum daily Trading price (in the day)
  • -Maximum daily Trading price (in the day)

Best regards,

Leticia

eikon-data-apidatastream-apidsws-api
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.

Alex Putkov.1 avatar image   Alex Putkov.1

@leticia.bernal
It would be helpful if you included in your question the name of the Refinitiv product or API you're using. Judging by the function syntax mentioned in your question I'm guessing you're using Datastream Web Service. I've moved your question to the forum dedicated to DSWS. If you're using another Refinitiv product, please chime in.

Jirapongse avatar image   Jirapongse

Contacted DSWS Escalation Support.

Jirapongse avatar image   Jirapongse

@leticia.bernal

Please specify the Refinitiv product or API you're using. Then, we can refer this question to the team who can provide an answer.

veerapath.rungruengrayubkul avatar image   veerapath.rungruengrayubkul

@leticia.bernal

Hi,

Thank you for your participation in the forum. Is the reply below satisfactory in answering your question? If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

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

Thanks,

AHS

2 Answers

· Write an Answer
Upvotes
Accepted
Monika.Stankovic avatar image
1.1k ●3 ●3 ●3

Hello @leticia.bernal,

For information on Datastream definitions and descriptions of the expressions/functions please refer to this help page .

As this forum is dedicated for the technical question regarding API I would advise contacting Refinitiv Help Desk for content questions as this one .

Kind regards,

Monika

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
leticia.bernal avatar image
1 ●0 ●1 ●3

Hi Alex,

Yes I'm using Datastram.

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.

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.