Calculating ATR based Stop Loss in an Excel Sheet

Excel for finance tutorials

There is no denial of the fact that Stop Loss is an integral part of any trading strategy. Trading without a stop loss is analogous to jumping off the plane without a parachute. The most common stop loss strategy is… Continue Reading

Options Premium Calculator using Black Scholes Model: Excel Sheet

Options Premium Calculator

Options belong to the derivative family of financial instruments and are considered relatively ‘complex’ when compared to stocks and commodities. The complexity arises due to the unique option pricing methodology which depends on several factors. In this post, we’ll explore… Continue Reading

Sharpe Ratio Calculator Excel Sheet

Excel for finance tutorials

Sharpe Ratio is an indispensable metric to assess the performance of a trading system or a mutual fund. Usually expressed as decimals, it gives an indication of the reliability and sustainability of your investment returns over time. In this post,… Continue Reading

CPR Spreadsheet with Narrow Range Indicator : Free Download

Trading Excel Sheet

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

How to Calculate SIP Returns in an Excel Sheet?

Excel for finance tutorials

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