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.
