analyze_trades.py 699 B

1234567891011121314151617
  1. import pandas as pd
  2. df = pd.read_csv('cyb50_optimized_trades_2017-06-01_2026-01-19.csv')
  3. print('资金连续性检查:')
  4. print('='*80)
  5. for i in range(min(10, len(df)-1)):
  6. prev_final = df.iloc[i]['平仓时总资金']
  7. curr_initial = df.iloc[i+1]['开仓时总资金']
  8. diff = abs(prev_final - curr_initial)
  9. status = 'ERROR' if diff > 100 else 'OK'
  10. print(f'{status} Trade#{i+1}->{i+2}: Prev Final {prev_final:,.0f} -> Curr Initial {curr_initial:,.0f} (Diff: {diff:,.0f})')
  11. print(f'\nSummary:')
  12. total_issues = sum(abs(df.iloc[i]['平仓时总资金'] - df.iloc[i+1]['开仓时总资金']) > 100 for i in range(len(df)-1))
  13. print(f'Inconsistent trades: {total_issues}/{len(df)-1}')