Excel coding for report generation.
Budget: ₹600 – ₹1,500 INR
On the basis of attached excel entries and exits with slippage + brokerage(variable), I need the following things at one place as a report.
1- Total number of trades
2- Net points
3- Average winning points
4- Average losing points
5- Winning percentage (days)
6- Losing percentage (days)
7- Risk to reward ratio
8- Max. number of winners in a row.
9- Max. number of losers in a row.
10- Max. Drawdown in points (days)
11- Return to MDD ratio ( CALMAR ratio)
12- Expectancy
1- Total number of trades
2- Net points
3- Average winning points
4- Average losing points
5- Winning percentage (days)
6- Losing percentage (days)
7- Risk to reward ratio
8- Max. number of winners in a row.
9- Max. number of losers in a row.
10- Max. Drawdown in points (days)
11- Return to MDD ratio ( CALMAR ratio)
12- Expectancy