Rajandran R Founder of Marketcalls and Co-Founder Algomojo. Full-Time Derivative Trader. Expert in Designing Trading Systems (Amibroker, Ninjatrader, Metatrader, Python, Pinescript). Trading the markets since 2006. Mentoring Traders on Trading System Designing, Market Profile, Orderflow and Trade Automation.

How to Build Simple Metrics using Excel from Amibroker Backtesting Report

32 sec read

Here is a video tutorial which explains how to make use of your Amibroker backtesting report by building simple metrics and visualize your trading strategy with MS Excel Pivot tables. Some of the metrics built in this video include total profitable months, total losing months, Max Profitable Month, Max Profitable Loss and the visualization of the month on month profitability using condition-based coloring and pivot table charts for a better understanding of risk-reward ratio involved in your trading strategy.

For more in-depth insights into a trading strategy consider attending Online Workshop on Trading Strategies for Active Traders

Here are the data visualization and simple metrics that got created from Amibroker backtesting report. In this example 1000000 initial capital used and the tested time period is almost 7.5 years on Bank Nifty 5min charts.

Monthly Trading Stratgegy Profit/Loss Heatmap

Monthly Profit Visualization

Rajandran R Founder of Marketcalls and Co-Founder Algomojo. Full-Time Derivative Trader. Expert in Designing Trading Systems (Amibroker, Ninjatrader, Metatrader, Python, Pinescript). Trading the markets since 2006. Mentoring Traders on Trading System Designing, Market Profile, Orderflow and Trade Automation.

Angel Broking Multi-Client Amibroker Trading Module

Got frequent requirements from Angel Broking Customers to automate Amibroker based trading system where one single generation from charts could punch orders in multiple...
Rajandran R
6 min read

Option Button Trading to Trade ATM, ITM, OTM Options…

Here is a simple button trading module which can be used to send option trading order with buttons. Users can configure the button to...
Rajandran R
7 min read

Multi Broker – Multi Client Algomojo Trading – Amibroker…

Here are simple Amibroker AFL - Button-based Trading modules which help traders to route their orders to different brokers simultaneously. Here is the prototype...
Rajandran R
4 min read

Leave a Reply

Get Notifications, Alerts on Market Updates, Trading Tools, Automation & More