关于股票均线数据excel的问题,我们总结了以下几点,给你解答:
股票均线数据excel
:param stock_code:
:return:
"""
# 创建excel
workbook = xlsxwriter.Workbook(f'{stock_code}.xlsx')
# 创建sheet
worksheet = workbook.add_worksheet('均线数据')
# 设置列宽
worksheet.set_column('A:A', 10)
worksheet.set_column('B:B', 10)
worksheet.set_column('C:C', 10)
worksheet.set_column('D:D', 10)
worksheet.set_column('E:E', 10)
worksheet.set_column('F:F', 10)
worksheet.set_column('G:G', 10)
worksheet.set_column('H:H', 10)
worksheet.set_column('I:I', 10)
worksheet.set_column('J:J', 10)
worksheet.set_column('K:K', 10)
worksheet.set_column('L:L', 10)
worksheet.set_column('M:M', 10)
worksheet.set_column('N:N', 10)
worksheet.set_column('O:O', 10)
worksheet.set_column('P:P', 10)
worksheet.set_column('Q:Q', 10)
worksheet.set_column('R:R', 10)
worksheet.set_column('S:S', 10)
worksheet.set_column('T:T', 10)
worksheet.set_column('U:U', 10)
worksheet.set_column('V:V', 10)
worksheet.set_column('W:W', 10)
worksheet.set_column('X:X', 10)
worksheet.set_column('Y:Y', 10)
worksheet.set_column('Z:Z', 10)
worksheet.set_column('AA:AA', 10)
worksheet.set_column('AB:AB', 10)
worksheet.set_column('AC:AC', 10)
worksheet.set_column('AD:AD', 10)
worksheet.set_column('AE:AE', 10)
worksheet.set_column('AF:AF', 10)
worksheet.set_column('AG:AG', 10)
worksheet.set_column('AH:AH', 10)
worksheet.set_column('AI:AI', 10)
worksheet.set_column('AJ:AJ', 10)
worksheet.set_column('AK:AK', 10)
worksheet.set_column('AL:AL', 10)
worksheet.set_column('AM:AM', 10)
worksheet.set_column('AN:AN', 10)
worksheet.set_column('AO:AO', 10)
worksheet.set_column('AP:AP', 10)
worksheet.set_column('AQ:AQ', 10)
worksheet.set_column('AR:AR', 10)
worksheet.set_column('AS:AS', 10)
worksheet.set_column('AT:AT', 10)
worksheet.set_column('AU:AU', 10)
worksheet.set_column('AV:AV', 10)
worksheet.set_column('AW:AW', 10)
worksheet.set_column('AX:AX', 10)
worksheet.set_column('AY:AY', 10)
worksheet.set_column('AZ:AZ', 10)
worksheet.set_column('BA:BA', 10)
worksheet.set_column('BB:BB', 10)
worksheet.set_column('BC:BC', 10)
worksheet.set_column('BD:BD', 10)
worksheet.set_column('BE:BE', 10)
worksheet.set_column('BF:BF', 10)
worksheet.set_column('BG:BG', 10)
worksheet.set_column('BH:BH', 10)
worksheet.set_column('BI:BI', 10)
worksheet.set_column('BJ:BJ', 10)
worksheet.set_column('BK:BK', 10)
worksheet.set_column('BL:BL', 10)
worksheet.set_column('BM:BM', 10)
worksheet.set_column('BN:BN', 10)
worksheet.set_column('BO:BO', 10)
worksheet.set_column('BP:BP', 10)
worksheet.set_column('BQ:BQ', 10)
worksheet.set_column('BR:BR', 10)
worksheet.set_column('BS:BS', 10)
worksheet.set_column('BT:BT', 10)
worksheet.set_column('BU:BU', 10)
worksheet.set_column('BV:BV', 10)
worksheet.set_column('BW:BW', 10)
worksheet.set_column('BX:BX', 10)
worksheet.set_column('BY:BY', 10)
worksheet.set_column('BZ:BZ', 10)
worksheet.set_column('CA:CA', 10)
worksheet.set_column('CB:CB', 10)
worksheet.set_column('CC:CC', 10)
worksheet.set_column('CD:CD', 10)
worksheet.set_column('CE:CE', 10)
worksheet.set_column('CF:CF', 10)
worksheet.set_column('CG:CG', 10)
worksheet.set_column('CH:CH', 10)
worksheet.set_column('CI:CI', 10)
worksheet.set_column('CJ:CJ', 10)
worksheet.set_column('CK:CK', 10)
worksheet.set_column('CL:CL', 10)
worksheet.set_column('CM:CM', 10)
worksheet.set_column('CN:CN', 10)
worksheet.set_column('CO:CO', 10)
worksheet.set_column('CP:CP', 10)
worksheet.set_column('CQ:CQ', 10)
worksheet.set_column('CR:CR', 10)
worksheet.set_column('CS:CS', 10)
worksheet.set_column('CT:CT', 10)
worksheet.set_column('CU:CU', 10)
worksheet.set_column('CV:CV', 10)
worksheet.set_column('CW:CW', 10)
worksheet.set_column('CX:CX', 10)
worksheet.set_column('CY:CY', 10)
worksheet.set_column('CZ:CZ', 10)
worksheet.set_column('DA:DA', 10)
worksheet.set_column('DB:DB', 10)
worksheet.set_column('DC:DC', 10)
worksheet.set_column('DD:DD', 10)
worksheet.set_column('DE:DE', 10)
worksheet.set_column('DF:DF', 10)
worksheet.set_column('DG:DG', 10)
worksheet.set_column('DH:DH', 10)
worksheet.set_column('DI:DI', 10)
worksheet.set_column('DJ:DJ', 10)
worksheet.set_column('DK:DK', 10)
worksheet.set_column('DL:DL', 10)
worksheet.set_column('DM:DM', 10)
worksheet.set_column('DN:DN', 10)
worksheet.set_column('DO:DO', 10)
worksheet.set_column('DP:DP', 10)
worksheet.set_column('DQ:DQ', 10)
worksheet.set_column('DR:DR', 10)
worksheet.set_column('DS:DS', 10)
worksheet.set_column('DT:DT', 10)
worksheet.set_column('DU:DU', 10)
worksheet.set_column('DV:DV', 10)
worksheet.set_column('DW:DW', 10)
worksheet
股票均线数据下载
股票数据包括股票行情开盘,收盘价 交易时间的每分钟成交价位,笔数等得,也包括公司最新公告这类的,最及时的股票数据你可以去赛股 网参考下,祝您投资愉快!
各类软件都有
股票行情软件就有,很多免费的。
广发证券至强版,东方财富通金融终端,大智慧超强版等等下载后随时可查。
静态数据(如开盘,收盘价)可以通过软件下载,动态数据(如交易时间的每分钟成交价位,笔数)需要软件在线登入查询. 最及时的股票资讯掌握在大户手上,小散轻易不能获取.获取时也是股票在高位了.
股票软件自身有下载数据功能,不用那么麻烦去找,系统菜单里面能找到下载选项,看下就知道了
股票均线数据导出
鼎嘉财富通可以做到 你去百度上搜索一下就能找到 现在是免费使用