i have the python code:
fields=[ek.TR_Field('TR.PriceClose',
{'Frq':'D',
'SDate':0,
'EDate':-365
},'asc',1),
ek.TR_Field('TR.PriceClose.date',
{'Period':'D',
'SDate':0,
'EDate':-365
},'asc',1)
And I run this to get the data for the permid:
df,err=ek.get_data([4295905573],fields)
This returns 1 line with <NA> for both fields.
df Out[108]: 0 TR.PRICECLOSE(EDate=-9999,Frq=D,SDate=0) \ 0 4295905573 <NA> TR.PRICECLOSE.DATE(EDate=-9999,Period=D,SDate=0) 0 <NA>
If I use JUST the field PriceClose, I get all the data, but there are no dates so kind of useless...
df Out[112]: Instrument Price Close 0 4295281938 15.65 1 4295281938 15.65 2 4295281938 15.65 3 4295281938 15.65 4 4295281938 15.65 .. ... ... 361 4295281938 15.65 362 4295281938 15.65 363 4295281938 15.65 364 4295281938 15.65 365 4295281938 15.65 [366 rows x 2 columns]
Need to return both price and date.
