question

Upvotes
Accepted
34 2 3 8

DSCHART End of Month data (in workspace)

Hi,

I want to download data from the DSCHART app (TRI from several global indices) but I cannot figure out how to parametrize the dates to be end of month. I didn't find in the documentation how to do this.

Using Dtart=BASE and End:LATEST provides monthly data but is not end of month (as in the screenshot, I get dates such as 08/M/YYY or 10/M/YYY). Ideally, I would like to get EOM (such as 31/M/YYY) dates.


screen-shot-2023-01-13-at-41948-pm.png

Thank you


workspace#productdatastream
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
59k 164 45 65

@ricardo.henriquez

Typically, to get month-end data, you need to specify an absolute date in the Start parameter, such as 1/31/2005.

However, this forum is dedicated to software developers using Refinitiv APIs. For DSCHART questions, please contact the Datastream support team directly via MyRefinitiv.

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.

@Jirapongse Thanks, it worked well. Just as a following question, what would be the specification to get daily data?

These indices have daily data as defined in Datastream Navigator.

Upvotes
8.8k 18 5 8

Hi @ricardo.henriquez ,

I'd like to add that tried to update the End field with 'Month End' and got the same result as yours. Hence please contact the Datastream support team directly as mentioned by my colleague.

1673844015270.png


1673844015270.png (46.5 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
59k 164 45 65

@ricardo.henriquez

You can change the view to Chart Settings.

1673925720844.png

Then, select the Dates and Data tab and change the Frequency to Daily. Finally, click the OK or Apply button.


1673925720844.png (70.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.