Exploring Chartless Trading with an Excel Sheet Demo!

In this video, Mr Sagar Singh discusses an effective trading strategy for market highs, buying at 20-day or 10-day highs, with Fridays yielding better results. Manage risk, use Excel and StockEdge, and consider a Nifty-gold portfolio. Mr Sagar Singh is a quantitative trader and Excel aficionado, utilizing data-driven strategies to uncover profitable trade ideas. With a meticulous eye for consistency, he navigates the financial markets armed with his trusty spreadsheets. Combining his expertise in quantitative analysis and my dedication to data-driven decision-making, he strives to generate optimal trading outcomes. 

He discusses in this video why it is crucial to backtest the trading strategies. He also shows us methods of backtesting in the excel sheet. He gives is method of how to conduct backtesting in the excel sheet.A critical stage in analysing and improving trading strategies is backtesting. It entails evaluating a strategy's performance and potential profitability using past market datHe tells us to determine the metrics we will use to evaluate the strategy's performance. Common metrics include profitability measures like returns, risk-adjusted metrics like the Sharpe ratio, drawdowns, and win/loss ratios.Also, For the assets you plan to trade, gather historical market data. This information normally consists of pricing and volume details, along with any other pertinent data points required for your plan.

He also says to utilise historical market data to test your strategy while simulating transactions and monitoring portfolio performance over time.  Watch the video torade wisely and explore recommended books.