Fields not following in order for mixed of streaming/real-time and Fundamental

MarkJoseph.Canada

Fields not following in order for mixed of streaming/real-time and Fundamental

Script
import refinitiv.data as rd
rd.open_session()
df = rd.get_data(
    universe = [
        '/PETR4.SA',
        '/VALE3.SA'
    ],
    fields = [
        'CF_LAST',
        'TR.PriceClose',
        'PCTCHNG',
        'TR.PricePctChg1D',
        'TR.PricePctChg2D',
        'TR.PricePctChg1M',
        'TR.PricePctChgMTD',
        'TR.PricePctChg3M',
        'TR.PricePctChgQTD',
        'TR.PricePctChg6M',
        'TR.PricePctChg1Y'
    ]
)

 

display(df)



Testing shows that get_history follows correctly however, get_data appears to put all real time fields at the end.

image (25).png

Jirapongse

@MarkJoseph.Canada

Thank you for reaching out to us.

This could be an expected behaviour of the library. I will contact the product team to verify it.

For now, the client can use the Python code to rearrange fields.

For example:

fields = [
        'CF_LAST',
        'TR.PriceClose',
        'PCTCHNG',
        'TR.PricePctChg1D',
        'TR.PricePctChg2D',
        'TR.PricePctChg1M',
        'TR.PricePctChgMTD',
        'TR.PricePctChg3M',
        'TR.PricePctChgQTD',
        'TR.PricePctChg6M',
        'TR.PricePctChg1Y'
    ]

df = ld.get_data(
    universe = [
        '/PETR4.SA',
        '/VALE3.SA'
    ],
    fields = fields,
    header_type = ld.HeaderType.NAME
)

df[[field.upper() for field in fields]]