All-In-One Percentage Based Backtesting Spreadsheet

Test your system and find out its historical performance with our spreadsheet before risking any real money in the live markets.

Find out more

Advanced Filtering Technology

Over 20 Detailed Statistics

Risk Different Percentages for Different Trades

Interactive Charts

This spreadsheet was created out of a necessity for a more advanced, fixed-percentage-based trading tool to support our own trading journeys. Previous spreadsheets were outdated, slow, and inefficient, often requiring weeks to filter data due to the constant need for manual data entry. Additionally, the limited statistics provided by older spreadsheets offered insufficient insights into trading performance.

Key Features:

Advanced Filtering Technology:
- All statistics auto-update as you filter within the spreadsheet, transforming a task that previously took weeks into something that can be completed in minutes.
- Saves significant time with 99.44% efficiency improvement
Comprehensive System Analytics:
- With over 20 detailed statistics, you gain a comprehensive understanding of your system's performance over time. This includes a month-by-month breakdown for the entire period you backtested, offering deep insights into your trading data (check the statistics tab to receive a full breakdown)
Website Access and Video Tutorials:
- Exclusive login for access to comprehensive video guides. Detailed explanations on using the spreadsheet and understanding statistics:
  - Introduction to Excel
  - Definitions of different trading statistics (Return on Investment, Drawdown, Maximum Allowable Drawdown, Win Rate, plus more)
Currency Selection:
- Choose between currencies: £, $, €, ¥
Customizable Starting Balance:
- Set and update your starting balance anytime
Adjustable Risk Per Trade
- Customize risk levels for individual trades
- Flexibility to set different risks for different trade types
Progress Tracking Feature
- Monitor trading performance comprehensively
- Keep track of your trading achievements and areas for improvement
Detailed Statistics Summary
- Over 20 detailed metrics including ROI, win rate, streaks, drawdown, and more
- 200% more detailed metrics and insights compared to traditional spreadsheets
Interactive Charts
- Monthly and yearly ROI charts to visualize performance trends
- Win rate chart to monitor trading accuracy
- ROI line graph for continuous performance overview
- Long vs Short trades chart to compare and optimize strategies

The spreadsheet presents statistics in two ways.

1. Overview of The Systems Performance - Statistics Summary (Filtered vs Unfiltered): The table summarising these statistics in the spreadsheet will show you the results BEFORE filtering in one column and the results based on your present filtering AFTER. This allows effective cross-comparing.

Average Yearly Return on Investment: Assess the effectiveness of your strategies
Win Rate: Track the success of your trades
Maximum Winning & Losing Streaks: Understand your trading patterns
Maximum Drawdown: Analyze the largest drop from a peak
Losing Trades: Review the number and percentage of losing trades
Break Even Trades: Evaluate trades that neither gained nor lost
Reward to Risk Statistics: Measure profitability relative to risk
Net Pips and Trade Outcomes: Track net pips, target hits, break-even points, exits, and trailing stops
Average Trade Outcome and Duration: Understand typical results and trade durations
Long and Short Trades: Analyze performance of long vs. short trades
Return on Investment Breakdown by Year: Detailed annual ROI breakdown

2. Detailed Statistical Breakdown by Trade#

Time factors
- Year
- Quarter
- Month
- Day
- Hour
- Duration of Trade
Reward to Risk Factors:
- Positions 1 & 2 Reward to Risk
- Overall Reward to Risk for the trade
Risk Statistics:
- Percentage risked for the trade
- Risk in pips
- Risk in currency
- Losing streak
- Percentage Drawdown
Risk Statistics:
- Position 1 & 2 Reward in pips
- Position 1 & 2 Reward in Currency
- Overall Reward in Currency
- Value Per Pip
- Winning Streak
Trade Outcome
- Rolling return on investment
- Total Percentage Outcome
- Total Outcome in Pips for Position 1, 2 and overall
- Total Outcome in Currency for Positon 1, 2 and overall
Equity
- Starting balance prior to entering the trade
- Ending balance post exiting the trade

Graphs Featured:

Monthly Return on Investment Bar Chart:
- Select the year you want to look at and receive a breakdown of the monthly return for your system
- Gives you a detailed, shorter-term insight into how your system has performed
- Often traders see e.g. a 40% return per year but that number doesn't tell you how you arrived at that throughout the year, it doesn't tell you anything about system volatility

Win Rate Chart:
- Discover the percentage split between winners, losers, break even trades

Yearly Return on Investment Chart:
- Select the year you want to look at and view the annual performance

Win Loss Ratio (by day):
- View the breakdown of Break Even, Win and Lose trades by day (Monday - Friday)

Yearly Breakdown Chart
- Side-by-side comparison across all years and the percentage return delivered

Long vs Short Trades
- Side-by-side comparison of how many trades long and short that broke even, won or lost

THETRADERSTRIBE
Advanced Backtesting Spreadsheet PLUS course videos

£499.00

Add to Cart

1. Unleash the Power of Data:
Our Backtesting Spreadsheet is your key to unlocking the power of historical market data. With a user-friendly interface and intuitive design, it allows you to import, organize, and analyze vast datasets effortlessly.

2. Dynamic Filtering for Precision Insights:

What sets our spreadsheet apart is its advanced filtering capabilities. You can customize your analysis by applying various filters, such as date ranges, asset classes, trading conditions, and more. As you apply filters, watch in real-time as the statistics and metrics update dynamically, providing you with immediate insights into the performance of your trading strategies.

3. Automatic Statistical Analysis:

No more manual calculations. Our Backtesting Spreadsheet features dynamic statistical tools that instantly compute key performance metrics like profit and loss, win rate, risk-to-reward ratios, and drawdowns as you adjust your filters. This means you can fine-tune your strategies on the fly, making data-driven decisions at every step.

4. Visualise Your Success:

In addition to dynamic tables and statistics, our spreadsheet offers visually engaging charts and graphs that help you gain a deeper understanding of your trading performance. Visualize equity curves, drawdowns, and trade distribution, allowing you to spot trends and opportunities at a glance.

5. Enhanced Decision Making:

With the ability to filter, analyze, and visualize your trading data in real time, our Backtesting Spreadsheet empowers you to make informed decisions, optimize strategies, and maximize your trading potential.

6. Lifetime Access:

Ensuring that users have access to resources and updates even after they complete the program, allowing them to continue learning and adapting to changing market conditions.

Don't rely on guesswork or outdated methods. Take control of your trading journey with our Backtesting Spreadsheet. It's the ultimate tool for traders who demand precision, flexibility, and actionable insights. Elevate your trading to new heights today.

Digital Products:

All digital products are non-refundable and non-exchangeable. Please review the sample of the digital product above, on the product page, before completing your purchase.

Online Courses:

All Online Courses are not downloadable and are non-refundable. Once purchased, this course does not have an expiration. You will get unlimited viewing access in your account.

DISCLAIMERS:

The following disclaimer is designed to clarify the nature of our trading education website and its content:

General Information: The content provided on this website is intended for informational purposes only. It does not constitute financial, investment, or trading advice, and should not be considered as such.

No Financial Advice: We are not financial advisors, and the information provided on this website should not be interpreted as personalized financial or investment advice. You should seek professional advice from a qualified financial advisor before making any trading or investment decisions.

Educational Content: Our website offers educational content related to trading, financial markets, and investment strategies. This content is designed to inform and educate visitors on various aspects of trading and investing.

Risk Disclaimer: Trading and investing in financial markets carry inherent risks, and the potential for substantial financial losses. Past performance is not indicative of future results. The educational content on this website does not guarantee profits or protection against losses.

Independence and Responsibility: All trading and investment decisions are the sole responsibility of the individual. We do not assume any liability for the consequences of your trading or investment decisions.

Accuracy and Timeliness: While we strive to provide accurate and up-to-date information, we do not guarantee the accuracy, completeness, or timeliness of the content on our website. Financial markets are dynamic, and information can change rapidly.

No Endorsement: Any mention of specific financial products, services, or trading platforms is for informational purposes only and should not be interpreted as an endorsement. We do not endorse or promote any particular trading or investment platform.

Third-Party Links: Our website may contain links to third-party websites or resources. We are not responsible for the content, accuracy, or availability of these external sources. Visiting external links is at your own risk.

Legal Compliance: The trading and investment activities discussed on this website may be subject to regulations and legal requirements that vary by jurisdiction. Visitors are responsible for ensuring compliance with applicable laws in their region.

Changes to Content: We reserve the right to modify, update, or remove content on our website without notice. It is your responsibility to stay informed about any changes to the content.

No Guarantee of Results: Participation in trading and investment activities involves uncertainties and the potential for losses. The outcomes of your trading or investment efforts may differ from those suggested by the information on our website.

By accessing and using this website, you acknowledge that you have read and understood this disclaimer. You further agree to use the information provided here solely for informational purposes and acknowledge that any trading or investment decisions are made at your own risk and discretion. We recommend consulting a qualified financial advisor or professional for personalized guidance related to your specific financial situation and goals.

1. What programme do you need to run the spreadsheet?
Microsoft Excel

2. Can I use the spreadsheet for any market?
Yes.

3. Do you need experience in Excel to use this?
No. The spreadsheet is basic and everything is pretty self-explanatory. You just need to enter your data. The spreadsheet also comes with videos that guide you through the entire process and explain what each metric (e.g. return on investment) means.

4. How does it work?
There is a detailed explanation of each section within the backtesting spreadsheet in the videos located inside the platform.

5. Do I get lifetime access?
Yes, it is a one-off payment.

6. What if I have questions once I have bought it?
You can email us any mechanical questions about the spreadsheet and you will receive a response within 24hours if you email contact@thetraderstribe.com

7. Why do I have to sign a non-disclosure agreement?
Because it is out work, we want to protect it. This means not sending or sharing login details with another party, or copying and selling the work. If so, legal action can be enforced.

Best Practice #1: "Successful traders backtest their strategies thoroughly, learning from historical data to improve their trading decisions in the future."

Ed Seykota, professional commodities trader

SMB Capital

Proprietary Trading Desk, Manhattan

"The ideal backtest chooses sample data from a relevant time period that reflects a variety of market conditions."

Steve Burns

Trader & Founder of NewTraderU

"Trading back tested signals filters out the emotion of trying to decide what to do each day from your own perspective."

Dr Brett Steenbarger

Trading Psychologist & Coach

"The very simple strategies tested and/or designed with candle by candle backtesting are still a cornerstone of my trading methodology."

All-In-One Percentage Based Backtesting Spreadsheet

Test your system and find out its historical performance with our spreadsheet before risking any real money in the live markets.

Advanced Filtering Technology

Over 20 Detailed Statistics

Risk Different Percentages for Different Trades

Interactive Charts

Key Features:

The spreadsheet presents statistics in two ways.

1. Overview of The Systems Performance - Statistics Summary (Filtered vs Unfiltered): The table summarising these statistics in the spreadsheet will show you the results BEFORE filtering in one column and the results based on your present filtering AFTER. This allows effective cross-comparing.

Graphs Featured:

Trading Plans:

Filtering Your Data:

THETRADERSTRIBE
Advanced Backtesting Spreadsheet PLUS course videos

£499.00

Best Practice #1: "Successful traders backtest their strategies thoroughly, learning from historical data to improve their trading decisions in the future."

All-In-One Percentage Based Backtesting Spreadsheet

Test your system and find out its historical performance with our spreadsheet before risking any real money in the live markets.

Advanced Filtering Technology

Over 20 Detailed Statistics

Risk Different Percentages for Different Trades

Interactive Charts

​

Key Features:

​

THETRADERSTRIBE Advanced Backtesting Spreadsheet PLUS course videos

£499.00

Best Practice #1: "Successful traders backtest their strategies thoroughly, learning from historical data to improve their trading decisions in the future."

THETRADERSTRIBE
Advanced Backtesting Spreadsheet PLUS course videos