def get_cashflow_data(provider: Provider, sleep, desc, pc, lock, region, batch): # 现金流量表 CashFlowStatement.record_data(provider=provider, share_para=(desc, pc, lock, True, region), sleeping_time=sleep, batch_size=batch)
def test_000778_cash_flow_statement(): correct_timestamps = [ '2018-09-30', '2018-06-30', '2018-03-31', '2017-12-31', '2017-09-30', '2017-06-30', '2017-03-31', '2016-12-31', '2016-09-30', '2016-06-30', '2016-03-31', '2015-12-31', '2015-09-30', '2015-06-30', '2015-03-31', '2014-12-31', '2014-09-30', '2014-06-30', '2014-03-31', '2013-12-31', '2013-09-30', '2013-06-30', '2013-03-31', '2012-12-31', '2012-09-30', '2012-06-30', '2012-03-31', '2011-12-31', '2011-09-30', '2011-06-30', '2011-03-31', '2010-12-31', '2010-09-30', '2010-06-30', '2010-03-31', '2009-12-31', '2009-09-30', '2009-06-30', '2009-03-31', '2008-12-31', '2008-09-30', '2008-06-30', '2008-03-31', '2007-12-31', '2007-09-30', '2007-06-30', '2007-03-31', '2006-12-31', '2006-09-30', '2006-06-30', '2006-03-31', '2005-12-31', '2005-09-30', '2005-06-30', '2005-03-31', '2004-12-31', '2004-09-30', '2004-06-30', '2004-03-31', '2003-12-31', '2003-09-30', '2003-06-30', '2003-03-31', '2002-12-31', '2002-06-30', '2001-12-31', '2001-06-30', '2000-12-31', '2000-06-30', '1999-12-31', '1998-12-31', '1998-06-30' ] result = CashFlowStatement.query_data( session=session, provider='eastmoney', return_type='domain', codes=['000778'], end_timestamp='2018-12-30', order=CashFlowStatement.report_date.desc(), time_field='report_date') assert len(correct_timestamps) == len(result) timestamps = [to_time_str(item.report_date) for item in result] assert set(correct_timestamps) == set(timestamps) latest: CashFlowStatement = result[0] assert latest.cash_from_selling == 27784000000 assert latest.tax_refund == 60700000 assert latest.cash_from_other_op == 1463000000 assert latest.total_op_cash_inflows == 29310000000 assert latest.cash_to_goods_services == 21210000000 assert latest.cash_to_employees == 1460000000 assert latest.taxes_and_surcharges == 2016000000 assert latest.cash_to_other_related_op == 573700000 assert latest.total_op_cash_outflows == 25260000000 assert latest.net_op_cash_flows == 4050000000 assert latest.cash_from_disposal_of_investments == 556500000 assert latest.cash_from_returns_on_investments == 44180000 assert latest.cash_from_disposal_fixed_intangible_assets == 457200 assert latest.cash_from_disposal_subsidiaries == 1046000000 assert latest.cash_from_other_investing == 553000000 assert latest.total_investing_cash_inflows == 2201000000 assert latest.cash_to_acquire_fixed_intangible_assets == 2521000000 assert latest.cash_to_investments == 1808000000 assert latest.total_investing_cash_outflows == 4329000000 assert latest.net_investing_cash_flows == -2128000000 assert latest.cash_from_accepting_investment == 24500000 assert latest.cash_from_subsidiaries_accepting_minority_interest == 24500000 assert latest.cash_from_borrowings == 10080000000 assert latest.cash_from_issuing_bonds == 997000000 assert latest.cash_from_other_financing == 200000000 assert latest.total_financing_cash_inflows == 11300000000 assert latest.cash_to_repay_borrowings == 11940000000 assert latest.cash_to_pay_interest_dividend == 892100000 assert latest.cash_to_other_financing == 328500000 assert latest.total_financing_cash_outflows == 13160000000 assert latest.net_financing_cash_flows == -1862000000 assert latest.foreign_exchange_rate_effect == 21350000 assert latest.net_cash_increase == 81240000 assert latest.cash_at_beginning == 5078000000 assert latest.cash == 5159000000
def test_000001_cash_flow_statement(): correct_timestamps = [ '2018-09-30', '2018-06-30', '2018-03-31', '2017-12-31', '2017-09-30', '2017-06-30', '2017-03-31', '2016-12-31', '2016-09-30', '2016-06-30', '2016-03-31', '2015-12-31', '2015-09-30', '2015-06-30', '2015-03-31', '2014-12-31', '2014-09-30', '2014-06-30', '2014-03-31', '2013-12-31', '2013-09-30', '2013-06-30', '2013-03-31', '2012-12-31', '2012-09-30', '2012-06-30', '2012-03-31', '2011-12-31', '2011-09-30', '2011-06-30', '2011-03-31', '2010-12-31', '2010-09-30', '2010-06-30', '2010-03-31', '2009-12-31', '2009-09-30', '2009-06-30', '2009-03-31', '2008-12-31', '2008-09-30', '2008-06-30', '2008-03-31', '2007-12-31', '2007-09-30', '2007-06-30', '2007-03-31', '2006-12-31', '2006-09-30', '2006-06-30', '2006-03-31', '2005-12-31', '2005-09-30', '2005-06-30', '2005-03-31', '2004-12-31', '2004-09-30', '2004-06-30', '2004-03-31', '2003-12-31', '2003-09-30', '2003-06-30', '2003-03-31', '2002-12-31', '2002-06-30', '2001-12-31', '2001-06-30', '2000-12-31', '2000-06-30', '1999-12-31', '1999-06-30', '1998-12-31', '1998-06-30' ] result = CashFlowStatement.query_data( session=session, provider='eastmoney', return_type='domain', codes=['000001'], end_timestamp='2018-12-30', order=CashFlowStatement.report_date.desc(), time_field='report_date') assert len(correct_timestamps) == len(result) timestamps = [to_time_str(item.report_date) for item in result] assert set(correct_timestamps) == set(timestamps) latest: CashFlowStatement = result[0] # 00000000 assert latest.fi_deposit_increase == 104700000000 assert latest.fi_borrow_from_central_bank_increase == 18960000000 assert latest.fi_deposit_in_others_decrease == 60880000000 assert latest.fi_lending_and_buy_repurchase_decrease == 12330000000 assert latest.fi_lending_decrease == 12270000000 assert latest.fi_buy_repurchase_decrease == 56000000 assert latest.fi_cash_from_interest_commission == 133700000000 assert latest.cash_from_other_op == 20540000000 assert latest.total_op_cash_inflows == 381200000000 assert latest.fi_loan_advance_increase == 250300000000 assert latest.fi_borrowing_and_sell_repurchase_decrease == 14350000000 assert latest.fi_borrowing_decrease == 10190000000 assert latest.fi_sell_repurchase_decrease == 4155000000 assert latest.fi_cash_to_interest_commission == 56760000000 assert latest.cash_to_employees == 12930000000 assert latest.taxes_and_surcharges == 20010000000 assert latest.cash_to_other_related_op == 38150000000 assert latest.total_op_cash_outflows == 392500000000 assert latest.net_op_cash_flows == -11310000000 assert latest.cash_from_disposal_of_investments == 348900000000 assert latest.cash_from_returns_on_investments == 21080000000 assert latest.cash_from_disposal_fixed_intangible_assets == 108000000 assert latest.total_investing_cash_inflows == 370100000000 assert latest.cash_to_investments == 294600000000 assert latest.cash_to_acquire_fixed_intangible_assets == 1518000000 assert latest.total_investing_cash_outflows == 296100000000 assert latest.net_investing_cash_flows == 73960000000 assert latest.cash_from_issuing_bonds == 581200000000 assert latest.total_financing_cash_inflows == 581200000000 assert latest.cash_to_repay_borrowings == 612500000000 assert latest.fi_cash_to_pay_interest == 2511000000 assert latest.cash_to_pay_interest_dividend == 3209000000 assert latest.total_financing_cash_outflows == 618300000000 assert latest.net_financing_cash_flows == -37080000000 assert latest.foreign_exchange_rate_effect == 2018000000 assert latest.net_cash_increase == 27590000000 assert latest.cash_at_beginning == 137000000000 assert latest.cash == 164600000000
# columns=[ # CashFlowStatement.net_op_cash_flows, # CashFlowStatement.net_investing_cash_flows, # CashFlowStatement.net_financing_cash_flows, # ], # filters=[ # CashFlowStatement.report_period == "year", # CashFlowStatement.report_date == to_pd_timestamp("2015-12-31"), # ], # ) df = CashFlowStatement.query_data( entity_id="stock_sz_000338", columns=[ CashFlowStatement.net_op_cash_flows, CashFlowStatement.net_investing_cash_flows, CashFlowStatement.net_financing_cash_flows, ], filters=[ CashFlowStatement.report_period == "year", CashFlowStatement.report_date == to_pd_timestamp("2015-12-31"), ], index="timestamp", ) composite_df(df=df) # the __all__ is generated __all__ = [ "compare", "compare_df", "distribute", "distribute_df", "composite", "composite_df", "composite_all" ]