question

Upvotes
Accepted
yb97008 avatar image
3 ●0 ●0 ●1

$$ER: E110,INVALID END DATE ENTERED ; $$ER: E115,START DATE AFTER END DATE

datastream.pngWhen I download data from Datastream, I get error like these:

$$ER: E110,INVALID END DATE ENTERED ; and

$$ER: E115,START DATE AFTER END DATE.

The code I imputed is like this:

=DSGRID(Sheet1!$A$2:$A$1020,"AF","Base Date","TIME","D","RowHeader=true;ColHeader=true;Transpose=true;Code=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false;AutoRefresh=false","")

I want to download the data of all the company in a specific market, and I think the problem is that I did not choose the right start date of all the company in the market. So how can I choose the earliest time this market starts? Do I have to check it one company by company?


datastream
datastream.png (149.7 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
Jirapongse avatar image
38.1k ●69 ●35 ●53

@yb97008

I think the formula should look like the following.

=@DSGRID("315611,14785Q,87809R","AF","BDATE","LATESTDATE","D","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")

I used "BDATE" for the start date and "LATESTDATE" for the end date.

The output is:

1635478902334.png

However, if I used 315611 as the last item, the output is different.

1635479035483.png

The first date changes to 11/14/2001, not 5/5/1992.

You need to contact the Refinitiv Eikon with Datastream for Office support team directly via MyRefinitiv to verify the problem.


1635478902334.png (34.6 KiB)
1635479035483.png (19.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea