For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

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

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"]

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
擷取1.png (196.4 KiB)
擷取2.png (199.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
18k 21 12 20

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.


ahs.png (56.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea