Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 1 2

I can search data from EXCEL ADD-IN, but there is null from EIKON API

We cannot catch some tickers of the data from EIKON API, but we can search same tickers of the data from Excel Add-in. It seems that there exists the data. Why we cannot catch the data from EIKON API? How can I solve the problem? thanks.

透過EIKON API撈取資料時發現有些變數的值會撈不到(不是固定幾家公司無值,而是倒進去的所有公司都沒有那個欄位的資料值),然而,使用Excel Add-in做單點資料的撈取又能夠撈到該變數的值(代表資料庫應該是存在那個變數資料),因此想請問為什麼會有這樣的問題發生? 應該怎麼解決呢? 謝謝!


例如這2個變數: TR.PriceAvg20D (20日的股價均值)、TR.HistPE5YrAvg(5年平均的PE)

利用Add-in是能夠撈到值的,但是EIKON API就無法撈到值(整條序列都會是空的):

下圖為A、B兩個例子,分別撈取TR.PriceAvg20D 以及 TR.HistPE5YrAvg 這兩個變數資料

例B: 利用EIKON API撈取資料的結果:所有的PriceAvg20D 與 HistPE5YrAvg都沒有撈到資料(資料日期日每個季月的最後一日,ie., 3/31, 6/30, 9/30, 12/31)

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apieikon-for-office
1.png (34.0 KiB)
2.png (103.5 KiB)
icon clock
10 |1500

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

Hello @jiajun,

Thank you for your participation in the forum.

Is the reply below satisfactory in resolving your query?

If yes, please click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

-AHS

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS

1 Answer

· Write an Answer
Upvotes
Accepted
18.2k 21 13 21

Hi @jiajun

I can successfully retrieve these 2 fields with the following code:

df,e = ek.get_data(['MYL.OQ','GAA.CN'],['TR.PriceAvg20D','TR.HistPE5YrAvg'])
df


ahs2.png (10.9 KiB)
icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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