Can't acquire any data under "Ownership" via ek.get_data(...) function

2323by

I want to get stocks list in the S&P500, like RIC: A, APPL.O...etc,

but it stuck for a long time then return

EikonError: Error code 400 | Backend error. 400 Bad Request

Here are columns that I want to acquire:

# Consolidated Ownership (91) => Consolidated Holdings (26)
cols = ["TR.HoldingsDate",
"TR.EarliestHoldingsDate",
"TR.PctOfSharesOutHeld",
"TR.SharesHeld",
"TR.SharesHeldValue",
"TR.FilingType",
"TR.PctPortfolio",
"TR.PrevSharesHeldValue",
"TR.PrevSharesHeld",
"TR.PrevHoldingsDate",
"TR.PrevFilingType",
"TR.SharesHeldValChg",
"TR.SharesHeldChange",
"TR.SharesHeldVAShared",
"TR.SharesHeldVASole",
"TR.SharesHeldVAOther",
"TR.SharedDispHoldings",
"TR.SoleDispHoldings",
"TR.PctExchange",
"TR.WeightExchange",
"TR.PctSector",
"TR.WeightSector",
"TR.PctCountry",
"TR.WeightCountry",
"TR.PctSharesHeldChangeOld",
"TR.PctSharesHeldChange"
]

Here are error screen shots:

However, using the same code, I can acquire following columns successfully:

cols = ["TR.PriceCloseDate",
"TR.PriceClose","TR.Volume","TR.PriceOpen","TR.PriceHigh","TR.PriceLow",
"TR.PriceTargetMean",
"TR.PriceToMeanPriceTarget",
"TR.PriceTargetMedian",
"TR.PriceTargetHigh",
"TR.PriceTargetLow",
"TR.PriceTargetStdDev",
"TR.PriceTargetNumOfEstimates",
"TR.PriceTargetNumIncEstimates",
"TR.PriceClose",
"TR.PriceToCFPerShare"]

chavalit-jintamalit

Hi @2323by

I can retrieve the data successfully using the columns you defined.

But this seems to be a large request and returning data may hit limitation if you are requesting multiple RIC at the same time.

Please refer to this limitation document.