Free Excel Sheet for Tracking PnL (Jeppez Style)
Learn How to use our free excel sheet for tracking PnL.
If you're an active trader or simply aspire to sharpen your skills, you've likely come across the name @Jeppez420 on X. This prolific trader has built a reputation for sharing jaw-dropping results from his systematic trading strategies, often accompanied by detailed screenshots of his Excel sheets. His posts are a goldmine of inspiration, showcasing consistent wins, impressive account growth, and a disciplined approach to trading that's hard to ignore. Today, we're thrilled to announce that we've created a free downloadable Excel trading journal inspired by traders like Jeppez, so you too can track, analyze, and elevate your trading game.
Who is @Jeppez420?
For those unfamiliar, @Jeppez420 is an X user who has taken the trading community by storm with his transparency and success. Specializing in systematic trades—rule-based strategies executed with precision—he frequently shares monthly recaps, daily wins, and detailed breakdowns of his performance. A quick scroll through his posts reveals staggering numbers: a record-breaking +$231,472 in September 2024 (doubling his account with a 103% gain), a +$91,000 single-day haul in October 2024, and a year-to-date milestone of +1,000% by October 2024. These aren't just lucky streaks; they're the result of a methodical approach combining system trades and discretionary plays.
What sets Jeppez apart is his commitment to data. His Excel sheets, often shared as visuals in his posts, display key metrics like net P&L, win percentage, average wins/losses, risk-reward ratios, and the split between systematic and discretionary trades. It's clear he's not just trading—he's analyzing every move to optimize his edge. For example, his November 2024 recap showed a +$200,524 net profit with a 34% account growth, despite a tough end to the month. His ability to break down performance into actionable insights is a lesson in itself.
Why a Trading Journal Matters
Jeppez's success underscores a truth every trader should embrace: record-keeping is the backbone of profitability. A trading journal isn't just a log—it's a tool to identify patterns, refine strategies, and avoid repeating costly mistakes. By tracking metrics like win rates, risk management, and trade outcomes, you gain clarity on what works and what doesn't. Jeppez's posts prove this: his systematic trades often account for the bulk of his gains (e.g., +$216k in September 2024), while discretionary trades add flexibility (e.g., +$100k in October 2024). Without data, he wouldn't know where his edge lies.
That's where our free Excel trading journal comes in. Inspired by the likes of Jeppez, we've designed a simple yet powerful tool to help traders of all levels replicate this disciplined approach.
How to Get Started
-
Download the Free Excel Sheet: Click here to download our free Excel trading journal template.
-
Input Your Trades: Start logging every trade, no matter how small. Include key details like monthly start/end (Putting the initial start balance and end balance should crunch the numbers for the next month and overall charts).
-
Analyze Your Results: Let the built-in formulas crunch the numbers.
-
Refine Your Approach: Use the insights to tweak your strategy, just like Jeppez does to maintain his edge.
Take a Page from Jeppez’s Playbook
@Jeppez420
’s posts are more than flexes—they’re a roadmap. His October 2024 recap, with +$197,686 and a 46% gain, showed a 68% win rate across 115 trades. His best day, a +$91k haul, came from sizing up on a single stock ($DJT). These results don’t happen by accident—they’re the product of tracking, testing, and trusting the numbers.
With our free Excel trading journal, you can start building your own success story. Whether you’re aiming for a 1,000% YTD milestone or just want to stop bleeding cash, it all begins with data. Download it today, channel your inner Jeppez, and take your trading to the next level.
Resources
Stay Updated
Subscribe to our newsletter to receive the latest updates about our AI features and market insights. Join our growing community of data-driven traders and investors who are leveraging AI to enhance their trading strategies.
