How do i get Quarter or Financial year as the Column header for the data?

CZAR
CZAR Newcomer

ld.get_data(universe= [
"TRV",
"ORI",
"WRB",
"BRO",

], fields= ['TR.F.NETPREMEARNED'], parameters= {"Scale":6,'Curn':"USD", 'FRQ':'FQ', 'Period':'FQ0', "SDate":0,"EDate":-5}) ,

Screenshot 2025-02-21 111513.png

This is the output i'm getting, I want column net premium as header and under sub header quarter or year, is it possible

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @CZAR

    Thank you for reaching out to us.

    Is it this one?

    ld.get_data(
        universe= [
            "TRV",
            "ORI",
            "WRB",
            "BRO"], 
        fields= [
            'TR.F.NETPREMEARNED.Date',
            'TR.F.NETPREMEARNED.fperiod',
            'TR.F.NETPREMEARNED'], 
        parameters= {"Scale":6,'Curn':"USD", 'FRQ':'FQ', 'Period':'FQ0', "SDate":0,"EDate":-5})
    
    image.png