Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
Fundamental data error

Hi,

Has anyone noticed that some fundamental data is wrong(different) when compared with other fundamental data source such as bloomberg.

For example, ticker: PINC. When I tired to get its latest ROIC data: roic = Fundamentals.roic.latest, the return number is -0.003257. But When I check with bloomberg or other data source, PINC never has a negative ROIC for the past 4 years. And PINC is not the only name that has error and also roic is not the only field with error (others like fcf_yield). Does anyone has the same problem?

Michael

2 responses

Perhaps, this can be still useful.

ROIC is calculated differently from Bloomberg data. Here's the formula from the docs.

roic
Net Income / (Total Equity + Long-term Debt and Capital Lease Obligation + Short-term Debt and Capital Lease Obligation)

You can calculate your own ROIC and see that it matches with the Pipeline roic.

However, this is not the correct ROIC:
- must be based on NOPAT instead of net revenue
- cash must be excluded from from invested capital

def make_pipeline():  
    universe = StaticAssets(symbols(['AAPL', 'BKNG']))  
    roic = ROICFactor()  
    my_roic = Fundamentals.net_income_cash_flow_statement.latest / (Fundamentals.total_equity.latest + Fundamentals.long_term_debt.latest + Fundamentals.current_debt_and_capital_lease_obligation.latest)  
    screen = universe

    return Pipeline(  
        columns={  
            'roic': roic,  
            'my_roic': my_roic  
        },  
        screen = screen,  
    )  

Sorry, that's the correct code snippet.

def make_pipeline():  
    universe = StaticAssets(symbols(['AAPL', 'BKNG']))  
    roic = Fundamentals.roic.latest  
    my_roic = Fundamentals.net_income_cash_flow_statement.latest / (Fundamentals.total_equity.latest + Fundamentals.long_term_debt.latest + Fundamentals.current_debt_and_capital_lease_obligation.latest)  
    screen = universe

    return Pipeline(  
        columns={  
            'roic': roic,  
            'my_roic': my_roic  
        },  
        screen = screen,  
    )