初学akshare获取ETF数据

 获取股票数据的库比较多，拿来主义即可，这里选择akshare，同时将数据导入excel表格中，以电力ETF为例

import numpy as np
import talib as ta
import akshare as ak

close = ak.fund_etf_hist_em(symbol='561560', period='daily', start_date='20200501',
                            end_date='20240520',
                            adjust='qfq')

types = ['MA5', 'MA10', 'MA15', 'MA20']

print(types)
for i in range(len(types)):
    close[types[i]] = ta.SMA(close.loc[:, "收盘"], timeperiod=(i + 1) * 5)  #在close后面加入列（均值）

close.to_excel('电力ETF（561560）.xlsx', sheet_name='Sheet1', index=False)  #此处一定要导入openpyxl库，不然会报错