TradingView Backtest to Excel
Export your TradingView strategy test results to a professional Excel workbook. No manual formulas, no Python scripting. Upload your CSV and get 8 sheets of calculated KPIs in one click.
The TradingView export workflow
TradingView's Strategy Tester gives you a clean CSV export of every trade your strategy executed. You get columns like entry price, exit price, P&L, and the date of each trade. It is the raw material for deeper analysis, but it stops there. You get numbers, not answers.
When I first started analyzing my own backtests, I opened that CSV in Excel and spent an afternoon writing formulas for Sharpe Ratio, Sortino, and drawdown calculations. The spreadsheet got messy fast. My Sharpe formula had a bug in the annualization factor for three weeks, and I had no idea. I was looking at wrong numbers and making decisions based on them.
Here is what the raw CSV gives you: trade-by-trade data, nothing else. No risk-adjusted ratios, no Monte Carlo simulation, no drawdown analysis. You have to build all of that yourself, and getting the formulas right is harder than it looks. A single stray cell reference or a wrong column sort can shift every number in your spreadsheet.
What raw Excel can and cannot do with your CSV
Excel is great for basic calculations. You can compute average P&L, win rate, max drawdown, and profit factor with relative ease. A few pivot tables will give you monthly breakdowns. If you know what you are doing, you can even build a passable Sharpe Ratio formula.
But there are things Excel cannot do with just trade data from TradingView. Monte Carlo simulation requires random resampling of your trade list, which means running thousands of trials and collecting percentile statistics. Excel does not have a built-in bootstrap function. You would need VBA or an add-on.
Rolling window analysis is another pain point. To calculate a 20-trade rolling Sharpe, you need to slice the data into overlapping windows, compute the Sharpe for each one, and track how it changes over time. Doable in Excel but tedious, and each new trade requires manually extending your formula ranges. I gave up on maintaining my own rolling analysis sheet after the third time the ranges broke.
Same story with Value at Risk (VaR), Conditional VaR, Calmar Ratio, and the Ulcer Performance Index. These are standard metrics in professional strategy evaluation, but none of them come pre-built in Excel. You have to either know the formulas or find a template that matches your data format. And if you are comparing multiple strategies, the template work multiplies.
This is not an Excel limitation problem. Excel is a general tool and backtest analysis is a specific job. The gap between the raw CSV and a professional-grade report is where weeks of manual spreadsheet work live.
What Pineify does with the same CSV export
You take the exact same CSV you exported from TradingView and drop it into Pineify. Within seconds, you get a full analysis dashboard and a download button for an 8-sheet Excel workbook. Every metric is computed automatically. Every sheet is formatted. No formulas to write, no ranges to maintain.
The KPI Overview sheet alone has 16+ metrics: Sharpe Ratio, Sortino Ratio, Calmar Ratio, SQN (System Quality Number), Recovery Factor, Ulcer Index, UPI (Martin Ratio), Value at Risk at 95%, Conditional VaR / Expected Shortfall, skewness, kurtosis, Kelly Criterion, and more. These are the same metrics quant funds use to evaluate strategies. Getting them all from a single CSV upload takes under a minute.
When I tested Pineify against my own hand-built Excel spreadsheet on a 420-trade EURUSD strategy, the Monte Carlo results were close, within 3% on the 95th percentile drawdown estimate. But Pineify had it in 15 seconds. My spreadsheet took about 4 minutes to crunch the same numbers. The time difference alone was enough to switch.
The workbook also includes sheets you would not bother building by hand: a full Monthly Returns matrix with YTD row totals, Weekly Returns across all 53 weeks, and a Daily Returns sheet that surfaces the best and worst single trading days. The Rolling Statistics sheet tracks Sharpe, Sortino, and Win Rate over every 20-trade window so you can see strategy decay before it hurts.
The 8-sheet Excel workbook, sheet by sheet
Here is exactly what goes into the file you download from Pineify. Each sheet is pre-formatted with headers, proper number formatting, and column widths that do not cut off.
- KPI Overview. All 16+ metrics in one view. Total net profit, profit factor, Sharpe, Sortino, Calmar, SQN, Recovery Factor, Ulcer Index, UPI, VaR (95%), CVaR, Kelly Criterion, skewness, kurtosis, win rate, and trade count. Filtered by All, Long, and Short trades.
- List of Trades. Every trade from your CSV plus calculated columns: Entry Efficiency, Exit Efficiency, MFE (Maximum Favorable Excursion), and MAE (Maximum Adverse Excursion). These let you see exactly how well your entry and exit rules performed on each trade.
- Monthly Returns. A matrix of monthly P&L values with year-to-date totals and yearly running totals. Spot seasonal patterns and bad months at a glance.
- Weekly Returns. Returns broken down by week number (1 through 53) across each year in your dataset. Useful for seeing whether your strategy works in specific weeks of the year.
- Daily Returns. Daily P&L values sorted by date. The foundation for the distribution analysis in the next sheet.
- Rolling Statistics. 20-trade rolling windows with Sharpe, Sortino, and Win Rate for each window. My favorite sheet because it caught strategy decay on a trend follower I was about to deploy. The Rolling Sharpe dropped from 1.4 to 0.6 over the last 10 windows, telling me the edge had eroded.
- Distribution Data. The bucket ranges and frequencies that build the Returns Distribution histogram. Skewness and kurtosis values included so you can see how fat-tailed your returns are.
- Monte Carlo Data. 1,000 bootstrap simulation results ranked by final equity. Includes worst-case, median, and best-case outcomes, plus drawdown percentiles at 95% and 99% confidence. This sheet tells you what kind of losing streak your strategy can survive.
Every sheet shares the same data your CSV had, plus the calculated fields. Nothing is removed.
Your data never leaves your device
A concern I hear from traders every week: "I do not want to upload my trades to some server." I felt the same way when I started looking for backtest analysis tools. My strategies are proprietary. My trade data reveals exactly how I enter and exit positions. Sending that to a cloud server was a non-starter.
Pineify runs entirely in your browser. When you drag in your CSV file, the JavaScript reads it locally. The calculations happen in your browser's memory. The Excel file is generated client-side using a library that never makes a network request. Your data never touches a server, not even for a second.
This is not a privacy promise that depends on policy. It is an architectural constraint. Pineify's backtest report tool cannot access your data even if it wanted to, because no part of the pipeline sends data anywhere. That is the same reason there is no server-side processing: we designed it so the server does not need to see your trades at all.
What Pineify does and does not do
Pineify is an analysis tool, not a backtesting engine. You ran the backtest in TradingView. Pineify reads the result and does deep statistics on it. It does not run strategies, connect to market data, or stream prices. The analysis is post-trade, not real-time.
It is also not a trading journal. Pineify does not sync with your broker, log your trades automatically, or track your psychology. There is no mobile app and no broker API integration. If you need per-trade journaling with notes and screenshots, a dedicated trading journal is a better fit. I use one alongside Pineify.
What Pineify does well is take a TradingView backtest CSV and produce the most complete free report I have seen for this type of data. No Python, no R, no spreadsheet construction. Drop the file, get the workbook.
Deep-dive into individual metrics
If you find a metric in your Excel report that you want to understand better, these calculator pages break down each one with formulas, interpretation guides, and good/bad ranges.
FAQ
Turn your backtest CSV into a real report
No signup, no server uploads, no spreadsheet formulas. Drop your TradingView CSV into Pineify and get an 8-sheet Excel workbook in seconds.
Analyze My Backtest Now