LYM: A Python CLI Tool for Analyzing Trading Strategies from Excel

说明与用途

LYM 是一个基于 Python 的命令行工具，读取包含交易结果的 Excel 文件，并输出策略统计信息，包括胜率、奖励分布、最佳止盈水平和连胜/连败记录。

问题

Need a quick way to evaluate which trading strategy works from Excel files full of results.

结果

LYM automates the evaluation of trading strategies from Excel, providing key metrics quickly via the command line.

工作流

• Install Python dependencies (pandas, numpy, openpyxl).
• Run the LYM CLI with the path to an Excel file.
• LYM reads the .xlsx file, normalizes data, calculates metrics (win rate, reward distribution, optimal TP, streaks).
• The tool outputs a concise report to the console.

证据

I built LYM to solve a simple problem: I had Excel files full of trading results, but no quick way to see which strategy was actually working.

来源

LYM analyzes trading strategies from Excel files. It calculates win rates, reward distribution, optimal take-profit (TP) levels, and consecutive win/loss streaks — all from the command line.

来源

Built with: Python, Pandas & NumPy for data analysis, openpyxl for reading .xlsx files

来源

Working with real Excel data in pandas taught me a lot about data normalization and building a CLI flow that handles missing files gracefully instead of crashing.

来源