View buyer photos
Report this item to Etsy

2026 Stock Trading Journal Spreadsheet / Long + Short Trades – Automated Dashboard Built-in Calculations - Excel/Google Sheets - Day Trading

Price:$5.30

Loading
4.5 out of 5 stars

4.5 out of 5

315 ratings

5 stars
78%
4 stars
11%
3 stars
2%
2 stars
2%
1 star
7%

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

2.8

We calculate this number using a recency-weighted average of all ratings, with a rating's value decreasing by half each year to best reflect the current experience.

(14 reviews)

2.5 Item quality
2.7 Shipping
2.3 Customer service
50% Buyers recommend
Filter by category
4 out of 5 stars 4 This item

Inactive account May 30, 2024

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?

Inactive account May 30, 2024

4 out of 5 stars 4 This item

Levi Mar 29, 2023

Great for the price. It works for me

Levi Mar 29, 2023

4 out of 5 stars 4 This item

Mohamad Aug 1, 2022

Spreadsheet was very useful. But for the risk and reward column? Can you guide me, after i key in the data, nothing happened.

Mohamad Aug 1, 2022

5 out of 5 stars 5 This item

Thomas Apr 23, 2024

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.

Thomas Apr 23, 2024

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 28, 2026