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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
jiajun avatar image
1 ●0 ●0 ●0

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-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythoneikon-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 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea