,

Analyzing Stock Trades(Total).

Unlocking Trading Insights: Analyzing Your Portfolio

If you’re into stock trading, you know that understanding your performance is key to making informed decisions. You want to know how well your trading strategy is working, and that’s where data analysis comes in.

Full code and all necessary setups you will find on my GitHub:

https://github.com/KsenoLv/PLpgSQL-portfolio-statement.

We’ll break down the key metrics you should be tracking and explain how they can help you make smarter trading choices. So, grab your notebook and let’s dive in!

1. Total Trades

First things first, let’s count your total number of trades. This gives you a sense of how active your trading has been.

2. Total Net Profit

Money matters, right? Calculate the total net profit from all your trades. This is your bottom line – what you’ve gained or lost.

3. Total Drawdown

Ever heard of drawdown? It’s the money you’ve lost during losing trades. We’ll also calculate it as a percentage of your initial deposit.

4. Percentage Profitable

Are you making more money than you’re losing? We’ll calculate the percentage of profitable trades to answer that question.

5. Profit Factor

This tells you how well your strategy is working. A higher profit factor suggests better trading performance.

6. Winning vs. Losing Trades

How many times have you come out on top? We’ll count your winning and losing trades separately.

7. Zero Trades

There are trades that don’t make or lose money. We’ll tally those too.

8. Average Trade Net Profit

What’s the average amount you’re making or losing per trade? This helps gauge consistency.

9. Largest Wins and Losses

We’ll identify your biggest wins and your largest losses. It’s essential to know where you’ve excelled and where you need improvement.

10. Total Position Value

Lastly, we’ll calculate the total value of all your positions. This can give you insights into your portfolio’s size.


We’ll use these metrics to analyze your trading strategy during a specific period. You can customize this analysis by setting your trading dates, starting deposit, and the stocks you’re interested in.

This data-driven approach will empower you to make more informed decisions about your trading strategy. Remember, knowledge is power in the world of trading!

So, are you ready to delve into your trading performance? Plug in your data and let the analysis begin. Happy trading!

Kseno avatar

Leave a Reply

Your email address will not be published. Required fields are marked *