$$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?


Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

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