| | |
|---|
| | | |
|---|
| | | import xlwt |
|---|
| | | |
|---|
| | | import gpcode_manager |
|---|
| | | import l2_data_util |
|---|
| | | import l2.l2_data_util |
|---|
| | | import log |
|---|
| | | |
|---|
| | | import l2_data_manager |
|---|
| | | |
|---|
| | | |
|---|
| | | def export_l2_excel(code, date=None): |
|---|
| | |
|---|
| | | |
|---|
| | | # 数据预处理 |
|---|
| | | num_operate_map = {} |
|---|
| | | l2_data_util.load_num_operate_map(num_operate_map, code, datas) |
|---|
| | | l2.l2_data_util.load_num_operate_map(num_operate_map, code, datas) |
|---|
| | | num_dict = {} |
|---|
| | | for data in datas: |
|---|
| | | if data["val"]["num"] not in num_dict: |
|---|
| | |
|---|
| | | num_dict[data["val"]["num"]].append(data) |
|---|
| | | |
|---|
| | | local_time = time.strftime("%Y%m%dT%H%M%S", time.localtime(time.time())) |
|---|
| | | file_name = "{}/{}_{}.xls".format(dest_dir, code, local_time) |
|---|
| | | file_name = "{}/{}_{}_{}.xls".format(dest_dir, code, gpcode_manager.get_code_name(code), local_time) |
|---|
| | | file_name_txt = "{}/{}_{}.txt".format(dest_dir, code, local_time) |
|---|
| | | openfile = open(file_name_txt, 'w') |
|---|
| | | try: |
|---|
| | |
|---|
| | | if cancel_time > 0: |
|---|
| | | cancel_time = "{}".format(cancel_time) |
|---|
| | | if data["cancelTimeUnit"] == 0: |
|---|
| | | cancel_time += "s"; |
|---|
| | | cancel_time += "s" |
|---|
| | | elif data["cancelTimeUnit"] == 1: |
|---|
| | | cancel_time += "m"; |
|---|
| | | cancel_time += "m" |
|---|
| | | elif data["cancelTimeUnit"] == 2: |
|---|
| | | cancel_time += "h"; |
|---|
| | | cancel_time += "h" |
|---|
| | | |
|---|
| | | ws.write(index, 2, cancel_time) |
|---|
| | | ws.write(index, 3, data["price"]) |
|---|
| | |
|---|
| | | |
|---|
| | | |
|---|
| | | if __name__ == "__main__": |
|---|
| | | codes = ["002441"] |
|---|
| | | codes = ["603083"] |
|---|
| | | for code in codes: |
|---|
| | | export_l2_excel(code) |
|---|
