price index/PUTCAL_RTO for instrument TRRTOEU

grace.arquion

Can you please check why I’m unable to pull price index/PUTCAL_RTO in Code Creator or Phyton? This field is working in Datastream Excel and in Workspace Eikon but not in Phyton/CodeBook.

import refinitiv.data as rdrd.open_session()df = rd.get_data(universe=['TRRTOEU'],fields=['PUTCAL_RTO(SDate=2009-02-25,EDate=2009-03-24)'])

df = rd.get_data(universe=['TRRTOEU'],fields=[f'PUTCAL_RTO(SDate=2008-01-01,EDate=2008-02-01).date',f'PUTCAL_RTO(Frq=D,SDate=2008-01-01,EDate=2008-02-01)'])

import refinitiv.data as rdrd.open_session()df = rd.get_data(universe=['TRRTOEU'],fields=['PUTCAL_RTO(SDate=2009-02-25,EDate=2009-03-24)']

The '(' delimiter is unexpected in formula. Requested universes: ['TRRTOEU']. Requested fields: ['TR.PUTCAL_RTO(SDATE=2009-02-25,EDATE=2009-03-24)']

Jirapongse

@grace.arquion

Thank you for reaching out to us.

Please share the Excel formula used in the Workspace Excel. I could not find this RIC in the Formula Builder.