最近要用到甲醇期货日线159合约数据,自己写了一段代码获取甲醇最近的历史和最新的动态数据并保存到excell表中,随时调用,导出数据如下表
python详细代码
import pandas as pd
from functools import reduce
import numpy as np
import xlsxwriter
import akshare as ak
from openpyxl import load_workbook
import datetime
from datetime import datetime as d1
#获取历史数据,新浪的
df1 = ak.futures_zh_daily_sina(symbol="MA2301")
df2 = ak.futures_zh_daily_sina(symbol="MA2305")
df3 = ak.futures_zh_daily_sina(symbol="MA2209")
order = ['date', 'open', 'close', 'low', 'high', 'volume']
df1 = df1[order]
df2 = df2[order]
df3 = df3[order]
#获取实时数据,新浪的
spot_df1 = ak.futures_zh_spot(symbol='MA2301', market="CF", adjust='0')
spot_df2 = ak.futures_zh_spot(symb