QA: Morgan Stanley in us_brokers/2018

Table of Contents

See also

PDF Report 0000895421_2019_Morgan_Stanley.pdf

Logs

warning The stock price does not exist industry.us_generic {}
warning The EntityCommonStockSharesOutstanding does not exist industry.us_generic {}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0000895421', 'EntityCommonStockSharesOutstanding': 1618597895, 'Assets': 895429000000, 'AssetsCurrent': 0, 'BrokerageAndAdvisoryCommissions': 0, 'CommissionsAndAdvisoryFees': 0, 'Expenses': 0, 'FinancialSecurities': 194773000000, 'GeneralAndAdministrativeExpense': 0, 'GoodwillAndIntangibleAssets': 9250000000, 'InterestIncome': 0, 'LaborExpense': 0, 'Liabilities': 812732000000, 'LiabilitiesAndStockholdersEquity': 895429000000, 'LiabilitiesCurrent': 190356000000, 'LongTermLiabilities': 0, 'NetIncome': 9237000000, 'OperatingExpenses': 0, 'Payables': 0, 'Receivables': 118060000000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SecuritiesRepurchaseAgreements': 196062000000, 'TradingGainsAndLosses': 0, 'remainder_Assets': 573346000000, 'remainder_ComprehensiveNetIncome': -691000000, 'remainder_Expenses': 0, 'remainder_Liabilities': 426314000000, 'remainder_NetIncome': 9237000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 82697000000, 'obs_EconomicCapitalRatio': nan}}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0000895421', 'Assets': 771462000000, 'AssetsCurrent': 0, 'BrokerageAndAdvisoryCommissions': 0, 'CommissionsAndAdvisoryFees': 0, 'Expenses': 0, 'FinancialSecurities': 490991000000, 'GeneralAndAdministrativeExpense': 0, 'GoodwillAndIntangibleAssets': 12216000000, 'InterestIncome': 0, 'LaborExpense': 0, 'Liabilities': 718682000000, 'LiabilitiesAndStockholdersEquity': 771462000000, 'LiabilitiesCurrent': 64593000000, 'LongTermLiabilities': 193374000000, 'NetIncome': 1406000000, 'OperatingExpenses': 0, 'Payables': 5423000000, 'Receivables': 5719000000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SecuritiesRepurchaseAgreements': 293030000000, 'TradingGainsAndLosses': 0, 'remainder_Assets': 262536000000, 'remainder_ComprehensiveNetIncome': -200000000, 'remainder_Expenses': 0, 'remainder_Liabilities': 162262000000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 52780000000, 'obs_EconomicCapitalRatio': nan}}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0000895421', 'EntityCommonStockSharesOutstanding': 1936223959, 'Assets': 787465000000, 'AssetsCurrent': 31469000000, 'BrokerageAndAdvisoryCommissions': 0, 'CommissionsAndAdvisoryFees': 0, 'Expenses': 0, 'FinancialSecurities': 370696000000, 'GeneralAndAdministrativeExpense': 0, 'GoodwillAndIntangibleAssets': 9568000000, 'InterestIncome': 0, 'LaborExpense': 0, 'Liabilities': 711281000000, 'LiabilitiesAndStockholdersEquity': 787465000000, 'LiabilitiesCurrent': 158207000000, 'LongTermLiabilities': 153768000000, 'NetIncome': 6279000000, 'OperatingExpenses': 0, 'Payables': 0, 'Receivables': 72559000000, 'RedeemableEquity': 0, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SecuritiesRepurchaseAgreements': 165189000000, 'TradingGainsAndLosses': 0, 'remainder_Assets': 303173000000, 'remainder_ComprehensiveNetIncome': -560000000, 'remainder_Expenses': 0, 'remainder_Liabilities': 234117000000, 'remainder_NetIncome': 6279000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 76184000000, 'obs_EconomicCapitalRatio': nan}}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0000895421', 'EntityCommonStockSharesOutstanding': 1872821289, 'Assets': 814949000000, 'AssetsCurrent': 0, 'BrokerageAndAdvisoryCommissions': 0, 'CommissionsAndAdvisoryFees': 0, 'Expenses': 0, 'FinancialSecurities': 387390000000, 'GeneralAndAdministrativeExpense': 0, 'GoodwillAndIntangibleAssets': 9298000000, 'InterestIncome': 0, 'LaborExpense': 0, 'Liabilities': 737772000000, 'LiabilitiesAndStockholdersEquity': 814949000000, 'LiabilitiesCurrent': 156804000000, 'LongTermLiabilities': 164775000000, 'NetIncome': 6123000000, 'OperatingExpenses': 0, 'Payables': 0, 'Receivables': 81704000000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SecuritiesRepurchaseAgreements': 198666000000, 'TradingGainsAndLosses': 0, 'remainder_Assets': 336557000000, 'remainder_ComprehensiveNetIncome': -819000000, 'remainder_Expenses': 0, 'remainder_Liabilities': 217527000000, 'remainder_NetIncome': 6123000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 77177000000, 'obs_EconomicCapitalRatio': nan}}
warning Ignoring company because Expenses is zero pre-agg {'balance_sheet': {'company_id': '0000895421', 'EntityCommonStockSharesOutstanding': 1618597895, 'Assets': 895429000000, 'AssetsCurrent': 0, 'BrokerageAndAdvisoryCommissions': 0, 'CommissionsAndAdvisoryFees': 0, 'Expenses': 0, 'FinancialSecurities': 194773000000, 'GeneralAndAdministrativeExpense': 0, 'GoodwillAndIntangibleAssets': 9250000000, 'InterestIncome': 0, 'LaborExpense': 0, 'Liabilities': 812732000000, 'LiabilitiesAndStockholdersEquity': 895429000000, 'LiabilitiesCurrent': 190356000000, 'LongTermLiabilities': 0, 'NetIncome': 9237000000, 'OperatingExpenses': 0, 'Payables': 0, 'Receivables': 118060000000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SecuritiesRepurchaseAgreements': 196062000000, 'TradingGainsAndLosses': 0, 'remainder_Assets': 573346000000, 'remainder_ComprehensiveNetIncome': -691000000, 'remainder_Expenses': 0, 'remainder_Liabilities': 426314000000, 'remainder_NetIncome': 9237000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 82697000000, 'obs_EconomicCapitalRatio': nan}}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('0000895421')"}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('EntityCommonStockSharesOutstanding')"}
info Failed to set obs_EconomicCapitalRatio industry.us_generic {'reason': "KeyError('0000895421')"}
info Added remainder_ComprehensiveNetIncome directly from 10K industry.us_generic {}

Edgar->Model Mapping