def write_xlsx(self, sheet: Worksheet, father):
graph1 = bar_and_plot(
category=self.year_list,
bar_param=[
[father.cash_data.get_sheet(year).data["net_cash_op"] for year in self.year_list],
"经营现金流"
],
plot_param=[
[self.get_indicator(year).data["operating_cash_growth_rate"] for year in self.year_list],
"经营现金增长率"
]
)
sheet.insert_image(0, 0, "", {"image_data": graph1})
graph2 = img_draw(
category=self.year_list,
plot_params=[
[
[father.dev_data.get_indicator(year).data["sales_growth_rate"] for year in self.year_list],
"销售增长率",
1
],
[
[self.get_indicator(year).data["operating_cash_growth_rate"] for year in self.year_list],
"经营现金增长率",
1
]
]
)
sheet.insert_image(20, 0, "", {"image_data": graph2})
graph3 = bar_and_plot(
category=self.year_list,
bar_param=[
[father.cash_data.get_sheet(year).data["final_cash"] for year in self.year_list],
"期末现金流"
],
plot_param=[
[self.get_indicator(year).data["cash_flow_growth_rate"] for year in self.year_list],
"现金流量增长率"
]
)
sheet.insert_image(40, 0, "", {"image_data": graph3})
graph4 = bar_and_plot(
category=self.year_list,
bar_param=[
[self.get_indicator(year).data["free_cash_ratio"] for year in self.year_list],
"自由现金流"
],
plot_param=[
[self.get_indicator(year).data["sales_and_operating_cash_ratio"] for year in self.year_list],
"销售自由现金比"
]
)
sheet.insert_image(60, 0, "", {"image_data": graph4})
graph5 = img_draw(
category=self.year_list,
plot_params=[
[
[self.get_indicator(year).data["sales_and_operating_cash_ratio"] for year in self.year_list],
"销售经营现金比",
1
]
]
)
sheet.insert_image(80, 0, "", {"image_data": graph5})
graph6 = img_draw(
category=self.year_list,
plot_params=[
[
[self.get_indicator(year).data["sales_cash_ratio"] for year in self.year_list],
"销售现金比",
1
]
]
)
sheet.insert_image(100, 0, "", {"image_data": graph6})
def write_xlsx(self, sheet: Worksheet, father):
graph1 = bar_and_plot(
category=self.year_list,
bar_param=[[
father.profit_data.get_sheet(year).data["selling_expenses"]
for year in self.year_list
], "销售费用"],
plot_param=[[
self.get_indicator(year).data["sales_expense_rate"]
for year in self.year_list
], "销售费用率"])
sheet.insert_image(0, 0, "", {"image_data": graph1})
graph2 = bar_and_plot(
category=self.year_list,
bar_param=[[
father.profit_data.get_sheet(year).data["management_fees"]
for year in self.year_list
], "管理费用"],
plot_param=[[
self.get_indicator(year).data["management_fee_rate"]
for year in self.year_list
], "管理费用率"])
sheet.insert_image(20, 0, "", {"image_data": graph2})
graph3 = bar_and_plot(
category=self.year_list,
bar_param=[[
(father.profit_data.get_sheet(year).data["management_fees"] +
father.profit_data.get_sheet(year).data["selling_expenses"])
for year in self.year_list
], "销售费用+管理费用"],
plot_param=[[
self.get_indicator(year).data["sales_management_fee_rate"]
for year in self.year_list
], "销售管理费用率"])
sheet.insert_image(40, 0, "", {"image_data": graph3})
graph4 = bar_and_plot(
category=self.year_list,
bar_param=[[
(father.profit_data.get_sheet(year).data["management_fees"] +
father.profit_data.get_sheet(year).data["selling_expenses"] +
father.profit_data.get_sheet(year).data["financial_expenses"])
for year in self.year_list
], "期间费用"],
plot_param=[[
self.get_indicator(year).data["period_expense_rate"]
for year in self.year_list
], "期间费用率"])
sheet.insert_image(60, 0, "", {"image_data": graph4})
graph5 = bar_and_plot(
category=self.year_list,
bar_param=[[
father.balance_data.get_sheet(year).data["total_assets"]
for year in self.year_list
], "资产总计"],
plot_param=[[
self.get_indicator(year).data["asset_turnover_days"]
for year in self.year_list
], "资产周转天数"],
use_percent=False)
sheet.insert_image(80, 0, "", {"image_data": graph5})
graph6 = bar_and_plot(
category=self.year_list,
bar_param=[[
father.balance_data.get_sheet(year).data["accounts_receivable"]
for year in self.year_list
], "应收账款"],
plot_param=[[
self.get_indicator(
year).data["accounts_receivable_turnover_days"]
for year in self.year_list
], "应收账款周转天数"],
use_percent=False)
sheet.insert_image(100, 0, "", {"image_data": graph6})
graph7 = bar_and_plot(
category=self.year_list,
bar_param=[[
father.balance_data.get_sheet(year).data["stock"]
for year in self.year_list
], "存货"],
plot_param=[[
self.get_indicator(year).data["inventory_turnover_days"]
for year in self.year_list
], "存货周转天数"],
use_percent=False)
sheet.insert_image(120, 0, "", {"image_data": graph7})
graph8 = img_draw(category=self.year_list,
plot_params=[[[
self.get_indicator(year).data["business_cycle"]
for year in self.year_list
], "营业周期", 1]],
use_percent=False)
sheet.insert_image(140, 0, "", {"image_data": graph8})
graph9 = img_draw(
category=self.year_list,
plot_params=[[[
self.get_indicator(year).data["repayment_rate_of_sales"]
for year in self.year_list
], "销售回款率", 1]])
sheet.insert_image(160, 0, "", {"image_data": graph9})
def write_xlsx(self, sheet: Worksheet, father):
graph1 = img_draw(
category=self.year_list,
plot_params=[[[
self.get_indicator(year).data["sales_gross_margin"]
for year in self.year_list
], "销售毛利率", 1]])
sheet.insert_image(0, 0, "", {"image_data": graph1})
graph2 = img_draw(
category=self.year_list,
plot_params=[[[
self.get_indicator(year).data["sales_operating_profit_margin"]
for year in self.year_list
], "销售营业利润率", 1]])
sheet.insert_image(20, 0, "", {"image_data": graph2})
graph3 = img_draw(category=self.year_list,
plot_params=[[[
self.get_indicator(year).data["sales_margin"]
for year in self.year_list
], "销售净利率", 1]])
sheet.insert_image(40, 0, "", {"image_data": graph3})
graph4 = img_draw(
category=self.year_list,
plot_params=[[[
self.get_indicator(year).data["sales_gross_margin"]
for year in self.year_list
], "销售毛利率", 1],
[[
self.get_indicator(
year).data["sales_operating_profit_margin"]
for year in self.year_list
], "销售营业利润率", 1],
[[
self.get_indicator(year).data["sales_margin"]
for year in self.year_list
], "销售净利率", 1]])
sheet.insert_image(60, 0, "", {"image_data": graph4})
graph5 = img_draw(category=self.year_list,
plot_params=[[[
self.get_indicator(year).data["roe"]
for year in self.year_list
], "净资产收益率", 1]])
sheet.insert_image(80, 0, "", {"image_data": graph5})
graph6 = img_draw(category=self.year_list,
plot_params=[[[
self.get_indicator(year).data["return_on_assets"]
for year in self.year_list
], "资产报酬率", 1]])
sheet.insert_image(100, 0, "", {"image_data": graph6})
graph7 = img_draw(
category=self.year_list,
plot_params=[[[
self.get_indicator(year).data["roe"] for year in self.year_list
], "净资产收益率", 1],
[[
self.get_indicator(year).data["return_on_assets"]
for year in self.year_list
], "资产报酬率", 1]])
sheet.insert_image(120, 0, "", {"image_data": graph7})
graph8 = img_draw(
category=self.year_list,
plot_params=[[[
self.get_indicator(year).data["earnings_per_share"]
for year in self.year_list
], "每股收益", 1]])
sheet.insert_image(140, 0, "", {"image_data": graph8})
graph9 = img_draw(
category=self.year_list,
plot_params=[[[
self.get_indicator(
year).data["capital_operating_rate_of_return"]
for year in self.year_list
], "资本运营收益率", 1]])
sheet.insert_image(160, 0, "", {"image_data": graph9})
def write_xlsx(self, sheet: Worksheet, father):
"""
insert the image to the work sheet
:param sheet: the Worksheet instance
:param father: the Company instance to share the data betweeen different sheets and indicators
:return:
"""
graph1 = bar_and_plot(
category=self.year_list,
bar_param=[[
father.profit_data.get_sheet(year).data["operating_income"]
for year in self.year_list
], "营业收入"],
plot_param=[[
self.get_indicator(year).data["sales_growth_rate"]
for year in self.year_list
], "销售增长率"])
sheet.insert_image(0, 0, "", {"image_data": graph1})
graph2 = bar_and_plot(
category=self.year_list,
bar_param=[[
father.balance_data.get_sheet(year).data["total_assets"]
for year in self.year_list
], "资产总计"],
plot_param=[[
self.get_indicator(year).data["asset_growth_rate"]
for year in self.year_list
], "资产增长率"])
sheet.insert_image(19, 0, "", {"image_data": graph2})
graph3 = img_draw(
category=self.year_list,
plot_params=[[[
self.get_indicator(year).data["sales_growth_rate"]
for year in self.year_list
], "销售增长率", 1],
[[
self.get_indicator(year).data["asset_growth_rate"]
for year in self.year_list
], "资产增长率", 1]])
sheet.insert_image(39, 0, "", {"image_data": graph3})
graph4 = bar_and_plot(
category=self.year_list,
bar_param=[[
father.profit_data.get_sheet(year).data["net_profit"]
for year in self.year_list
], "净利润"],
plot_param=[[
self.get_indicator(year).data["net_profit_growth_rate"]
for year in self.year_list
], "净利润增长率"])
sheet.insert_image(59, 0, "", {"image_data": graph4})
graph5 = img_draw(
category=self.year_list,
plot_params=[[[
self.get_indicator(year).data["net_profit_growth_rate"]
for year in self.year_list
], "净利润增长率", 1],
[[
self.get_indicator(year).data["sales_growth_rate"]
for year in self.year_list
], "销售收入增长率", 1]])
sheet.insert_image(79, 0, "", {"image_data": graph5})
graph6 = bar_and_plot(
category=self.year_list,
bar_param=[[
father.balance_data.get_sheet(year).data["owners_equity"]
for year in self.year_list
], "净资产"],
plot_param=[[
self.get_indicator(year).data["net_asset_growth_rate"]
for year in self.year_list
], "净资产增长率"])
sheet.insert_image(99, 0, "", {"image_data": graph6})
graph7 = img_draw(
category=self.year_list,
plot_params=[
[[
self.get_indicator(year).data["asset_growth_rate"]
for year in self.year_list
], "资产增长率", 1],
[[
self.get_indicator(year).data["net_asset_growth_rate"]
for year in self.year_list
], "净资产增长率", 1]
])
sheet.insert_image(119, 0, "", {"image_data": graph7})
graph8 = bar_and_plot(
category=self.year_list,
bar_param=[[
father.balance_data.get_sheet(year).data["fixed_assetes"]
for year in self.year_list
], "固定资产"],
plot_param=[[
self.get_indicator(year).data["fixed_asset_growth_rate"]
for year in self.year_list
], "固定资产增长率"])
sheet.insert_image(139, 0, "", {"image_data": graph8})
graph9 = img_draw(
category=self.year_list,
plot_params=[
[[
self.get_indicator(year).data["asset_growth_rate"]
for year in self.year_list
], "资产增长率", 1],
[[
self.get_indicator(year).data["fixed_asset_growth_rate"]
for year in self.year_list
], "固定资产增长率", 1]
])
sheet.insert_image(159, 0, "", {"image_data": graph9})
def write_xlsx(self, sheet: Worksheet, father):
graph1 = img_draw(
category=self.year_list,
plot_params=[
[
[self.get_indicator(year).data["assets_and_liabilities"] for year in self.year_list],
"资产负债率",
1
],
[
[0.4] * len(self.year_list),
"下限值",
1
],
[
[0.6] * len(self.year_list),
"上限值",
1
]
]
)
sheet.insert_image(0, 0, "", {"image_data": graph1})
graph2 = img_draw(
category=self.year_list,
plot_params=[
[
[self.get_indicator(year).data["current_ratio"] for year in self.year_list],
"流动比率",
1
],
[
[1.5] * len(self.year_list),
"合理值",
1
],
[
[2] * len(self.year_list),
"最佳值",
1
]
],
use_percent=False
)
sheet.insert_image(20, 0, "", {"image_data": graph2})
graph3 = img_draw(
category=self.year_list,
plot_params=[
[
[self.get_indicator(year).data["quick_ratio"] for year in self.year_list],
"速动比率",
1
],
[
[1] * len(self.year_list),
"最低值",
1
],
[
[1.5] * len(self.year_list),
"合理值",
1
]
],
use_percent=False
)
sheet.insert_image(40, 0, "", {"image_data": graph3})
