Current, I am extracting the Price and OpenInterest data for a voluntary carbon credit product using the following formulas in excel:
=@RHistory("ONGZ2",".Timestamp;.Close","START:01-Mar-2021 INTERVAL:1D",,"SORT:ASC TSREPEAT:NO CH:IN;Fd",B2) =@RHistory("ONGZ2","OPINT_1.Timestamp;OPINT_1.Value","START:30-Jul-2021 INTERVAL:1D",,"TSREPEAT:NO SORT:ASC CH:IN;Fd",G3)
Now, I want to get this data in python using the eikon-python api.
df= ek.get_timeseries('ONGZ2', fields=['Close'], start_date=startDate,end_date=endDate)
I now the filed name for Price as 'Close' but can't find the field name for 'Open interest' column. the codebook only suggest the code using get_data() method but now get_timeseries()
How do I find the appropriate field name here?