Is there any possibility to retrieve Piotroski F-Score via Python Eikon Data API?

alekseenkova.marina
alekseenkova.marina Explorer
in Eikon Data APIs

Is there any possibility to retrieve Piotroski F-Score via Python Eikon Data API?

I need historical values for the period of the last 15 years for the following companies:

TSLA.O

META.O

APPL.O


Thanks!

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @alekseenkova.marina

    You can try the following code:

    df, err = ek.get_data(["TSLA.O","META.O","AAPL.O"],
                          "if(TR.NetIncome(Period=FY0)>0,1,0)+if(TR.CashFromOperatingAct(Period=FY0)>0,1,0)+if(TR.ROAActValue(Period=FY0)>TR.ROAActValue(Period=FY-1),1,0)+if(TR.CashFromOperatingAct(Period=FY0)>TR.NetIncomeBeforeExtraItems(Period=FY0),1,0)+if(TR.LTDebtToTotalAssetsPct(Period=FY0)>=TR.LTDebtToTotalAssetsPct(Period=FY-1),1,0)+if(TR.CurrentRatio(Period=FY0)>TR.CurrentRatio(Period=FY-1),1,0)+if(TR.SaleIssuanceOfCommon(Period=FY0)>=0,1,0)+if(TR.GrossProfitMarginIndustrialAndUtilityPct(Period=FY0)>=TR.GrossProfitMarginIndustrialAndUtilityPct(Period=FY-1),1,0)+if(TR.AssetTurnover(Period=FY0)>TR.AssetTurnover(Period=FY-1),1,0)")
    df.columns = ['Instrument', 'Piotroski F-Score']
    df

    The output is:

    1671698596926.png

Answers

  • raksina.samasiri
    raksina.samasiri admin

    hi @alekseenkova.marina ,

    The moderators on this forum do not have deep expertise in
    every type of content available through Refinitiv products. Such expertise is
    available through Refinitiv Helpdesk. If the Helpdesk can show you how to
    retrieve it using =@TR formula in Eikon Excel, then
    the moderators on this forum can help you translate it into get_data method in Eikon Data API call. Refinitiv Helpdesk can
    be reached via MyRefinitiv and you may request from
    them the data you would like to get.

  • alekseenkova.marina
    alekseenkova.marina Explorer
    https://community.developers.refinitiv.com/discussion/comment/100879#Comment_100879

    Yes, it could be retrieved via Formula Builder.

    =TR("","if(TR.NetIncome(Period=FY0)>0,1,0)+if(TR.CashFromOperatingAct(Period=FY0)>0,1,0)+if(TR.ROAActValue(Period=FY0)>TR.ROAActValue(Period=FY-1),1,0)+if(TR.CashFromOperatingAct(Period=FY0)>TR.NetIncomeBeforeExtraItems(Period=FY0),1,0)+if(TR.LTDebtToTotalAssetsPct(Period=FY0)>=TR.LTDebtToTotalAssetsPct(Period=FY-1),1,0)+if(TR.CurrentRatio(Period=FY0)>TR.CurrentRatio(Period=FY-1),1,0)+if(TR.SaleIssuanceOfCommon(Period=FY0)>=0,1,0)+if(TR.GrossProfitMarginIndustrialAndUtilityPct(Period=FY0)>=TR.GrossProfitMarginIndustrialAndUtilityPct(Period=FY-1),1,0)+if(TR.AssetTurnover(Period=FY0)>TR.AssetTurnover(Period=FY-1),1,0)/*Piotroski F-Score*/","CH=Fd RH=IN",J15)

    Could you please help me transform it to python code?

Categories