Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
Morningstar Fundamentals Parents / Children / Siblings

Is there any documentation available to understand the hierarchy of Morningstar financial statements data? For example, how do we know that the value of net_ppe_purchase_and_sale is included in the value of cash_flow_from_continuing_investing_activities which is then included in the value of investing_cash_flow? The Quantopian Morningstar Fundamentals Reference page is not helpful in this regard. I doubt if even a Controller for a Fortune 500 company could easily piece all of this data together given the documentation provided here : )

Something like the (super incomplete) example below is sorely needed. Otherwise how can we understand how granular each data point is and how can we account for confounding variables?

Has anyone put something together like this that you'd like to share with the community? Or know of something put together by Morningstar that could help?

financial_statements  
 |-- balance_sheet  
 |    |-- total_assets  
 |    |    |-- current_assets  
 |    |    |    |-- cash_cash_equivalents_and_marketable_securities  
 |    |    |    |-- inventory  
 |    |    |    |-- receivables  
 |    |    |    |-- assets_held_for_sale_current  
 |    |    |    |-- restricted_cash  
 |    |    |-- total_non_current_assets  
 |    |    |    |-- net_ppe  
 |    |    |    |-- goodwill_and_other_intangible_assets  
 |    |    |    |-- long_term_investments  
 |    |    |    |-- non_current_accounts_receivable  
 |    |-- total_liabilities  
 |    |    |-- current_liabilities  
 |    |    |    |-- payables_and_accrued_expenses  
 |    |    |    |-- current_debt_and_capital_lease_obligation  
 |    |    |    |-- other_current_liabilities  
 |    |    |-- total_non_current_liabilities_net_minority_interest  
 |    |    |    |-- long_term_debt_and_capital_lease_obligation  
 |    |    |    |-- liabilities_heldfor_sale_non_current  
 |    |    |    |-- other_non_current_liabilities  
 |    |-- total_equity  
 |    |    |-- stockholders_equity  
 |    |    |    |-- additional_paid_in_capital  
 |    |    |    |-- retained_earnings  
 |    |    |    |-- gains_losses_not_affecting_retained_earnings  
 |-- cash_flow_statement  
 |    |-- operating_cash_flow  
 |    |    |-- cash_flow_from_continuing_operating_activities  
 |    |    |-- cash_from_discontinued_operating_activities  
 |    |-- investing_cash_flow  
 |    |    |-- cash_flow_from_continuing_investing_activities  
 |    |    |-- cash_from_discontinued_investing_activities  
 |    |-- financing_cash_flow  
 |    |    |-- cash_flow_from_continuing_financing_activities  
 |    |    |-- cash_from_discontinued_financing_activities