In this post, we are going to look at a Central Pivot Range (CPR) spreadsheet which calculates the CPR as well as support-resistance levels of stock symbols. This fully automated CPR spreadsheet is built on Google sheets platform and fetches… Continue Reading
If I am stranded on a lonely island with a laptop and option to use just one software, then certainly that software will be “Excel”. It is evident that excel can do more than any other software, from simple mathematical… Continue Reading
Most of the modern-day investors prefer a systematic investment plan (SIP) to invest their funds at regular intervals. And it is a really smart way to average out your investment during different phases of the market. On a long-term SIP… Continue Reading
Expectancy is an important metric that tells you how much profit each trade is going to produce. It can be both a positive or negative number. A positive expectancy signifies a net profitable trading system. In this post, we’ll learn… Continue Reading
While designing trading systems, it is imperative to have a stop loss to prevent capital erosion. It helps traders to protect their capital in the event of high volatility and whipsaw signals. In this post, we are going to learn… Continue Reading
Drawdown is one of the most important measures for evaluating trading systems. A drawdown measures the peak to trough decline of your equity value during a specific period of time. In this post, we’ll learn how to calculate drawdown in… Continue Reading
The Japanese candlestick chart is still one of the important weapons in the arsenal of a technical analyst. If you are a pure price action trader, you can make mighty profits just by analyzing candlestick charts of a stock or… Continue Reading
XIRR stands of Extended Internal Rate of Return. Similar to CAGR, it is another powerful way to gauge the performance of your investments. It is used to calculate the aggregated return when you invest (or redeem) your funds on multiple… Continue Reading