2026 Stock Trading Journal Spreadsheet / Long + Short Trades – Automated Dashboard Built-in Calculations - Excel/Google Sheets - Day Trading
Price:$5.30
4.5 out of 5
315 ratings
You can only make an offer when buying a single item
Highlights
📈 Track your trading with this Stock Trading Journal that allows you to track and analyze both Long and Short positions. The spreadsheet will automatically calculate the result of each trade and automatically generate a dashboard that gives you all the information about your trading performance. As an extra analyzing tool, you can use filters to analyze which trades, stock or strategies are the most successful for you.
🟡 The information per trade is divided into 7 categories:
1. Stock Information
- # number of trade
- Stock name
- Symbol
2. Position Strategy
- Long/Short (drop-down menu)
- Strategy
- Stop loss price
- Target price
- Risk (calculated automatically)
- Risk/Reward ratio (calculated automatically)
3. Entry Data
- QTY (quantity)
- Entry price
- Entry date
4. Exit Data
- Exit price
- Exit date
- Position duration (calculated automatically)
5. Totals
- Total entry (calculated automatically)
- Total exit (calculated automatically)
- Commission
6. Outcome
- Profit / Loss (calculated automatically)
- Yield (calculated automatically)
7. Notes
- Notes
🟡 For all your trades, the dashboard automatically generates the following information:
- Total Profit / Loss
- Number of trades
- Number of Profitable, Breakeven and Losing Trades
- Hit rate
- Average profit / loss per trade
- Largest win and largest loss
- Average position duration (in days)
- Total commission paid
- Circle Chart of Profitable/Losing/Breakeven trades percentage
🟡 This Stock Trading Journal provides an extra analyzing tool in the form of filters. With these you can filter your trades on stock, symbol, Long/Short, strategy, Risk:Reward ratio and Position duration. In this manner you can analyze to find out trading which stock, strategy or risk reward ratio is the most profitable for you.
Looking for a Trading Journal Spreadsheet for just tracking long positions? Please check out:
https://www.etsy.com/listing/1070462539/2026-stock-trading-journal-w-automated?click_key=2d52739a83b73358edafcb062366215282c99db0%3A1070462539&click_sum=ea9a5bc6&ref=shop_home_recs_4&crt=1
Manual:
Most information for each trade is optional. The only data you need to fill in are the quantity (QTY), Long/Short, Entry price and Exit Price. You select Long/Short by clicking on the cell and using the drop-down menu to select either Long or Short. Please note that for the Risk:Reward ratio, you need to fill in both a Stop Loss Price and Target Price.
Product:
This is a digital product. The Stock Trading Journal for Long and Short positions comes in XLSX Format and is usable for both Microsoft Excel, Google Sheets and Open Office.
This spreadsheet is unprotected, so it is fully possible to customize it to your need. If you need help with customizing, have questions about this spreadsheet, or need help to use this spreadsheet after purchasing, please contact me. I try to respond within 24 hours.
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
Reviews for this item
Very nice spreadsheet, exactly as described. However I was of the opinion that this would also look up other stock tickers as well, not in the portfolio?
Great for the price. It works for me
Spreadsheet was very useful. But for the risk and reward column? Can you guide me, after i key in the data, nothing happened.
In my opinion, the formulas are correct and it is a simple and clear Excel table. I have added my points for strategy evaluations based on this. thx.
Photos from reviews
More from this shop
Visit shop-
Digital download
Simple Personal Monthly Income and Expenses Statement in Excel - Easy Monthly Budget Spreadsheet W/ Built-in Calculation - diff. Currencies
$1.14
-
Digital download
2026 Fitness Workout Tracker Spreadsheet Template New Year Resolution – Exercise Log - Excel/Google Sheets – Lifting Cardio Schedule Planner
$2.09
-
Digital download
2026 Personal Income and Expenses Spreadsheet - Budget Template - Excel / Google Sheets - Income, Expenses and Savings - Automated Dashboard
$3.67
-
Digital download
2026 Invoice Tracker Spreadsheet – Excel or Google Sheet Template for Logging Invoices with Built-in Calculations – Suit for Customization
$2.66
-
Digital download
Easy to Use Trading Journal Spreadsheet | Simple Dashboard & Trade Log (Google Sheets)
Sale Price $2.20
Original Price $8.80
-
Digital download
Stock Trading Journal - Downloadable Excel Spreadsheet
$5.00
-
Digital download
Ultimate Trading Journal: Excel P&L Tracker for Options, Futures, Crypto
Sale Price $4.92
Original Price $5.47
-
Digital download
Crypto Trading Journal Google sheets | Trading Dashboard Spreadsheet | Trade Analysis Chart | Annual and Monthly Trading Report
Sale Price $1.25
Original Price $5.00
-
Digital download
Trading Journal Google Sheets Template Stocks Crypto Personal Finance Investment Tracker Financial Stock Market Portfolio Tracker
$5.47
-
Digital download
Forex Trading Journal Spreadsheet | Google Sheets (Digital Product)
$8.90
-
Digital download
2025 Options Tracker | Stock Trading Journal | Profit Tracker | Options Level 1 Dashboard Template | Tax Projections | Google Sheets
$9.99
-
Digital download
Trade Journal Trade Tracker Investment Spreadsheet Excel for Day Traders
$10.00
-
Digital download
Stock and Options Trading Strategy Comparison Tracker
$5.00
-
Digital download
Stock Trading Journal | Google Sheets & Excel Template
Sale Price $11.58
Original Price $46.32
-
Digital download
Swing Trading Spreadsheet: Stock Portfolio Tracker (Digital Download)
Sale Price $4.48
Original Price $11.19
-
Digital download
Comprehensive Stock Trading Journal | Dashboard | Position Sizing | Excel and Google Sheets
$10.99
Shoppers with similar taste loved these
-
Digital download
Selling Call Options | Beginner's Guide to Options Trading: Stock Market Investing Made Simple (PDF)
$2.50
-
Digital download
Simple Trading Book | Beginner Trading Basics eBook PDF | Candlesticks & Risk Management | Educational-Digital Download
Sale Price $2.56
Original Price $9.50
-
Digital download
Trading Basics Notes for Beginners | ~50-Pages of Notes (Digital Download)
$7.30
-
Digital download
1200+ Trading Mastery Ebook Collections Beginner to Advance Trading | MRR Included, Altcoins, Trading, Investing, forex trading
$10.00
-
Digital download
Trading Journal Google Sheets Template Stocks Crypto Personal Finance Investment Tracker Financial Stock Market Portfolio Tracker
$5.47
-
Digital download
Trading Basics Digital Dictionary, Beginner Stock Market Guide, Day Trading Terms Explained
$7.00
-
Digital download
Technical Analysis Guide | Most Used 15 Chart Patterns Trading Workbook (PDF Download)
$5.49
-
Finance stock market Cufflinks and Lapel Tie Pin Brooch Gifts for Him Men, Wall Street Trader Broker
$37.99
-
Crypto & Stock Ticker in Wood Frame | Live Bitcoin Price LED Display | Stock Market Gift for Traders and Investors | Made in Germany
Sale Price $210.95
Original Price $281.26
-
10 Rules for Trading Wall Art | Trading Rules Poster | Stock Market Motivation Print | Trader Office Wall Decor | Canvas or Digital
Sale Price $3.08
Original Price $5.12
-
100-Year DJIA Stock Market Chart – Economic Growth Poster (November 2026 Edition)
$97.00
-
Buy The Rumor Sell The News, Stock Market Art, Trading Decor For Office, Bull Market Trader Gift, Framed Canvas For New Office Wall Decor
Sale Price $132.60
Original Price $189.42