| | |
|---|
| | | ws.write(index, 2, cancel_time) |
|---|
| | | ws.write(index, 3, data["val"]["price"]) |
|---|
| | | ws.write(index, 4, data["val"]["num"]) |
|---|
| | | |
|---|
| | | limit_price="" |
|---|
| | | if int(data["val"]["limitPrice"]) == 1: |
|---|
| | | limit_price="涨停" |
|---|
| | | elif int(data["val"]["limitPrice"]) == 2: |
|---|
| | | limit_price="跌停" |
|---|
| | | |
|---|
| | | if int(data["val"]["operateType"]) == 0: |
|---|
| | | ws.write(index, 5, '买') |
|---|
| | | if len(limit_price)>0: |
|---|
| | | ws.write(index, 5, '买 ({})'.format(limit_price)) |
|---|
| | | else: |
|---|
| | | ws.write(index, 5, '买') |
|---|
| | | elif int(data["val"]["operateType"]) == 1: |
|---|
| | | ws.write(index, 5, '买撤') |
|---|
| | | if len(limit_price) > 0: |
|---|
| | | ws.write(index, 5, '买撤 ({})'.format(limit_price)) |
|---|
| | | else: |
|---|
| | | ws.write(index, 5, '买撤') |
|---|
| | | ws.write(index, 6, data["re"]) |
|---|
| | | wb.save(file_name) |
|---|
| | | return file_name |
|---|
