#画K线图
import pandas as pd
import matplotlib.pyplot as plt
import mplfinance as mpf#金融画图库
from pylab import mpl#字体显示库
#字体和方块问题
mpl.rcParams['font.sans-serif'] = ['FangSong']
mpl.rcParams['axes.unicode_minus'] = False
#读取数据
ndsd = pd.read_excel("宁德时代.xlsx",index_col="日期")
ndsd.columns
#将中文索引改成英文索引
df = ndsd[['开盘价(元)', '最高价(元)', '最低价(元)', '收盘价(元)', '成交额(百万)']]
df.columns = ['Open', 'High', 'Low', 'Close',"Volume"]
df.index.rename("date",inplace=True)
#成交量数值类型改成浮点形
df.volume = df.Volume.astype(float)
df.dtypes

mpf.plot(df,type='candle',linecolor='g')
#设计风格
mc = mpf.make_marketcolors(up='red',down='green',inherit=True)
s = mpf.make_mpf_style(base_mpf_style='nightclouds',
                       rc={'font.family':'SimHei'},
                       marketcolors=mc)
mpf.plot(df,type='candle',figsize=(16,8),volume=True,
         mav=(5,10),figscale=1.5,
         xrotation=15,datetime_format='%Y-%m-%d',
         title='宁德时代',ylabel='price',ylabel_lower='volume',
         tight_layout=True,style=s)