TradingView Backtest Excel Analyzer
A Python tool that turns TradingView backtest exports into detailed Excel analytics and professional PDF performance reports.
Overview
The TradingView Backtest Excel Analyzer is a Python tool built to make TradingView strategy results easier to analyse.
TradingView provides the raw backtest results, but deeper analysis often requires additional calculations and organisation. This tool takes the exported Excel file and automatically creates a more detailed analysis of the strategy's performance.
Key Features
- Analyse TradingView backtest Excel exports
- Calculate key performance metrics
- Analyse win rate, profit factor and expectancy
- Measure maximum drawdown and risk
- Analyse performance by day of the week
- Analyse performance by hour of the day
- Analyse monthly performance
- Generate equity curves and P&L charts
- Create an enhanced Excel analysis sheet
- Automatically generate a formatted PDF report
- Batch analyse multiple backtests
How It Works
TradingView Backtest → Excel Export → Analyzer → Excel Dashboard + PDF Report
The tool keeps the original TradingView data while adding an Advanced Analysis sheet containing the calculated metrics and charts.
It can also process multiple backtest files at once, making it easier to compare different strategies, stocks, or backtest periods.
Why I Built It
I wanted to go beyond the basic performance numbers provided by a backtest and look at where and when a strategy actually performs well.
Looking at factors such as trading hours, weekdays, monthly results, drawdowns, and the distribution of individual trades can reveal patterns that are easy to miss when looking only at total returns.
Technology
Built using:
- Python
- Pandas
- OpenPyXL
- Matplotlib
- ReportLab
Project Repository
The complete source code and example reports are available on GitHub.
https://github.com/yash-sarawgi/TradingView-Backtest-Excel-Analyzer