EIkon 1.1.6. post2 get_data returns -1 while excel returns correct value

laurens

loaded Eikon version 1.1.6.post2
the operation you intend to perform will cost 1 data points
2020-09-28 15:05:27
 get_data( instruments = ["AAPL.O"]
    , fields = ["TR.CompanyMarketCap(Sdate=0D)/*Market Cap*/"]
    , debug = False, raw_output = True
    )
EikonGetData request returned the following data: 2 columns and 2 rows
EikonGetData request returned with length 7

it then returns the following result:

---

[[1]]
[[1]]$columnHeadersCount
[1] 1

[[1]]$data
[[1]]$data[[1]]
[[1]]$data[[1]][[1]]
[1] "AAPL.O"

[[1]]$data[[1]][[2]]
[1] -1



[[1]]$headerOrientation
[1] "horizontal"

[[1]]$headers
[[1]]$headers[[1]]
[[1]]$headers[[1]][[1]]
[[1]]$headers[[1]][[1]]$displayName
[1] "Instrument"


[[1]]$headers[[1]][[2]]
[[1]]$headers[[1]][[2]]$displayName
[1] "Company Market Cap"

[[1]]$headers[[1]][[2]]$field
[1] "TR.COMPANYMARKETCAP(SDATE=0D)/*MARKET CAP*/"




[[1]]$rowHeadersCount
[1] 1

[[1]]$totalColumnsCount
[1] 2

[[1]]$totalRowsCount
[1] 2

---

if I however perform the exact same operation in excel I get

=TR("AAPL.O";"TR.CompanyMarketCap(Sdate=0D)/*Market Cap*/";"CH=Fd RH=IN";B2)

with the following response:

1,92027E+12

---

This happen issues with All US stocks other Japanese European do not seem to have this problem

---

Gurpreet

Hello @laurens

I try your query in Python and get the expected result:

>> ek.get_data(instruments = ["AAPL.O"], fields = ["TR.CompanyMarketCap(Sdate=0D)"], debug = False, raw_output = True)

{
 'columnHeadersCount': 1,
 'data': [['AAPL.O', 1920272742080]],
 'headerOrientation': 'horizontal',
 'headers': [[{
    'displayName': 'Instrument'
   }, {
    'displayName': 'Company Market Cap',
    'field': 'TR.COMPANYMARKETCAP(SDATE=0D)'
   }
  ]],
 'rowHeadersCount': 1,
 'totalColumnsCount': 2,
 'totalRowsCount': 2
}

As you can see the market cap is correct.