Bizzare behaviour on TR download.

kenbehren
kenbehren Newcomer
edited May 2 in Eikon Data APIs

I have several spreadsheets that were working fine earlier today but now have this cryptic message.

The '5' is unexpected in identifiers. Only the whole lexeme could be quoted. Escape sequence for quote and apostrophe is doubling.

No data is returned.

The Excel cell formula is:

=TR("SCREEN(U(IN(indices(TRGBLD/TR International Developed Mkt/))/UNV:Public/), TR.CompanyMarketCap(Scale=6)>=1000, TR.AvgDailyValTraded52W(Scale=6)>=1," & " IN(TR.TRBCEconSectorCode,""50"",""51"",""52"",""53"",""54"",""55"",""56"",""57"",""59"",""60"",""63""),"&"NOT_IN(TR.TRBCActivityCode,""5550101010"",""5550103010"",""5560101010""), CURN=USD),TSM.N,PBR.N,NVO.N/SINGLECOMPANIES/",CONCATENATE("TR.PrimaryQuote;TR.TickerSymbol;TR.CommonName;TR.Sedol;TR.HeadquartersRegion;","TR.CompanyMarketCap(Scale=6);TR.IssueMarketCap(Scale=6);TR.FreeFloatPct;TR.ExchangeMarketIdCode;TR.CombinedAlphaCountryRank;TR.CombinedAlphaIndustryRank;TR.ARM100Country;TR.IVPriceToIntrinsicValue;","TR.PE;TR.PriceToBVPerShare;TR.PriceToCFPerShare;TR.PriceToSalesPerShare;TR.FwdPE;TR.DividendYield;TR.TRBCIndustry;TR.TRBCIndustryCode;","TR.ExchangeCountryCode;TR.CoRPrimaryCountryCode"),"Curn=USD CH=Fd RH=IN SortD:TR.CombinedAlphaCountryRank SortA:TR.IVPriceToIntrinsicValue",A2)

This only started happening in the last six hours.

Any ideas?

The message is very cryptic.

Tagged:

Best Answer

  • kenbehren
    kenbehren Newcomer
    Answer ✓

    The behaviour of the formula parser seems different now. I removed the comment strings and the single company tickers and it works.

    =TR("SCREEN(U(IN(indices(TRGBLD))), TR.CompanyMarketCap(Scale=6)>=1000, TR.AvgDailyValTraded52W(Scale=6)>=1," & " IN(TR.TRBCEconSectorCode,""50"",""51"",""52"",""53"",""54"",""55"",""56"",""57"",""59"",""60"",""63""),"&"NOT_IN(TR.TRBCActivityCode,""5550101010"",""5550103010"",""5560101010""), CURN=USD)",CONCATENATE("TR.PrimaryQuote;TR.TickerSymbol;TR.CommonName;TR.Sedol;TR.HeadquartersRegion;","TR.CompanyMarketCap(Scale=6);TR.IssueMarketCap(Scale=6);TR.FreeFloatPct;TR.ExchangeMarketIdCode;TR.CombinedAlphaCountryRank;TR.CombinedAlphaIndustryRank;TR.ARM100Country;TR.IVPriceToIntrinsicValue;","TR.PE;TR.PriceToBVPerShare;TR.PriceToCFPerShare;TR.PriceToSalesPerShare;TR.FwdPE;TR.DividendYield;TR.TRBCIndustry;TR.TRBCIndustryCode;","TR.ExchangeCountryCode;TR.CoRPrimaryCountryCode"),"Curn=USD CH=Fd RH=IN SortD:TR.CombinedAlphaCountryRank SortA:TR.IVPriceToIntrinsicValue",A2)

Answers

  • kenbehren
    kenbehren Newcomer

    Weird. The failing formulas were working previously. I checked because I had archived workbooks with results.

Categories