cum_return2 = fs.get_bencnmark_cum_return_series(setup_date, end_date)
# 写入基金和基准时间序列
###########################################################################################
cum_return = pd.concat([cum_return, cum_return2], axis=1)
cum_return.columns = [fund_name, benchmark_name, benchmark_name_2]
cum_return = cum_return.dropna()
num_format_pd = pd.DataFrame([], columns=cum_return.columns, index=['format'])
num_format_pd.ix['format', :] = '0.00%'
excel.write_pandas(cum_return, worksheet, begin_row_number=0, begin_col_number=col_number,
num_format_pd=num_format_pd, color="blue", fillna=True)
# 基金和基准时间序列图
###########################################################################################
chart_name = fund_name + "累计收益（管理以来）"
series_name = [fund_name, benchmark_name, benchmark_name_2]
insert_pos = 'B12'
excel.line_chart_time_series_plot(worksheet, 0, col_number, cum_return,
series_name, chart_name, insert_pos, sheet_name)
excel.close()
###########################################################################################
return True
if __name__ == '__main__':
from quant.data.data import Data
save_path = os.path.join(Data().primary_data_path, "mfcteda_data\performance")
end_date = '20181231'
write_public_fxwy(end_date, save_path)
index=['format'])
num_format_pd.ix['format', :] = '0.00%'
excel.write_pandas(cum_return,
worksheet,
begin_row_number=0,
begin_col_number=col_number,
num_format_pd=num_format_pd,
color="blue",
fillna=True)
# 基金和基准时间序列图
###########################################################################################
chart_name = fund_name + "累计收益（管理以来）"
series_name = [fund_name, benchmark_name, benchmark_name_2]
insert_pos = 'B15'
excel.line_chart_time_series_plot(worksheet, 0, col_number, cum_return,
series_name, chart_name, insert_pos,
sheet_name)
excel.close()
###########################################################################################
return True
if __name__ == '__main__':
from quant.data.data import Data
save_path = os.path.join(Data().primary_data_path,
"mfcteda_data\performance")
end_date = '20190131'
write_public_chengzhang(end_date, save_path)
