Hi,
It is Aug 13, 2019, 4:30 pm IST now and I am trying to download close price for couple of Indian RICs `TCS.NS` and `HDBK.NS` since it has been end of trading hours for Indian market (3:30 pm IST).
Usually everyday by this time, the close price gets downloaded via Excel or Python API, but today I am unable to retrieve them.
Please see my below code and corresponding output.
import eikon as ek
rics = ['HDBK.NS', 'TCS.NS']
fields = [ek.TR_Field('TR.PriceClose'), ek.TR_Field('TR.PriceClose.date')]
df = ek.get_data(instruments=rics, fields=fields, parameters={'SDate': '2019-08-08', 'EDate': '2019-08-13', 'FRQ': 'D', 'CH': 'Fd;IN', 'RH': 'date', 'SORTD': 'date'})
print(df)
Output is as follows:
( Instrument Price Close Date
0 HDBK.NS 2233.15 2019-08-08T00:00:00Z
1 HDBK.NS 2282.00 2019-08-09T00:00:00Z
2 HDBK.NS 2282.00 2019-08-09T00:00:00Z
3 TCS.NS 2258.10 2019-08-08T00:00:00Z
4 TCS.NS 2246.25 2019-08-09T00:00:00Z
5 TCS.NS 2246.25 2019-08-09T00:00:00Z, None)
Note that the price downloaded is for Aug 8 and 9, not Aug 13.
Any help would be appreciated.
