Error when extracting stock data from index using Datastream

Hey community, I am very new to this topic so my question might be quite simple:

I am currently researching historical stock market data(Jan 1st, 2018- Oct. 12th, 2020) of different European indices using the Excel DataStream Plugin. This worked without any Error for all indices, but I get back an Error for the Italian FTSEMIB (Invalid Code or expression entered)- even though I didn't change any of my input (besides Index Name.)

How can i fix this error?image

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    I can run it properly.

    image

    The formula is:

    =@DSGRID("LFTSEMIB","UP",Sheet4!$A$1,Sheet4!$B$1,"D","EDateCellRef=true;SDateCellRef=true;RowHeader=true;TimeSeriesList=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")

    The output is:

    image

    You may need to contact the DataStream support team via MyRefinitiv to verify the problem.