question

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

$$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 512.0 KiB each and 1.0 MiB total.

wasin.w avatar image   wasin.w

Hello @yb97008

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
78.8k ●250 ●52 ●74

@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 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.