Moving Average Convergence Divergence (MACD) MACD is a popular trend-following momentum indicator. The MACD turns two trend-following indicators into a momentum oscillator by subtracting the longer moving average from the shorter moving average. MACD is calculated by taking difference between 12 day Exponential Moving Average (EMA) and 26 day EMA. A positive MACD means the […]

Read More →## How to do Average Directional Index (ADX) in Excel

Introduction The Average Directional Index (ADX) in combination with Minus Directional Indicator (-DI) and Plus Directional Indicator represent a powerful group of directional movement indicators. Welles Wilder had originally developed these trading indicators for commodities and currencies in mind, but the concept can easily be extended to stock trading. The detailed calculations are complex and […]

Read More →## Artificial Intelligence to drive contract lifecycle management

In early 2018, McKinsey Global Institute estimated that nearly 23% of a lawyer’s job can be automated one way or the other. Automation will tranform multiple aspects of legal tasks. But many experts predict highly paid lawyers on the top of the pyramid will spend most of their time on value added work that demands […]

Read More →## How to do Chande Momentum Oscillator in Excel

Chande Momentum Oscillator Overview Chande Momentum Oscillator or CMO attempts to address few drawbacks of RSI by frequently identifying overbought and oversold price movements. CMO technical indicator was developed by Tushar Chande and is similar to the Relative Strength Index. You can read more about CMO in his book – The New Technical Reader. Unlike […]

Read More →## Relative Strength Index Plot

* Update – Trade and investing models that were designed earlier using Yahoo! Finance API have been rewritten to retrieve quotes from Bloomberg Markets. At this time only US stocks and ETFs can be retrieved from the RSI model plot. See setup instructions. Relative Strength Index Plot Relative Strength Index or RSI is a popular […]

Read More →## How To Perform Nonlinear Regression in Excel

Excel Solver is one of the simple and easy curve-fitting tool around. Its curve-fitting capabilities makes it an excellent tool for performing nonlinear regression. The Excel Solver can be used to find the equation of the linear or nonlinear curve which closely fits a set of data points. Here are few simple steps on how […]

Read More →## Modified Sharpe Ratio

How Sharp is the Sharpe-Ratio? If popularity was the only measurement for risk metrics, the Sharpe ratio would tell us everything we need to know. Modified Sharpe Ratio covers further spectrum of risks in the field of investing. Any discussion on risk-adjusted performance is incomplete without touching on the topic of Sharpe ratio or Reward to Variability which […]

Read More →## Logistics Network Optimizing Warehouse Location

There are many factors to consider when building a new warehouse facility. Making the right decisions with regards to both warehousing and distribution methods could make all the difference for your firm. This can range from storage requirements, the level of automation in material handling, and workforce availability. An important aspect among all is the […]

Read More →## Conditional Value At Risk Calculator

Value At Risk Value at risk or VaR is a statistical measure of the amount of funds a investment, portfolio, or a company might expect to lose over a specified time horizon with a given probability. If you have a portfolio that is expected to lose no more than $100,000, 90% of the time (or 18 out […]

Read More →## Ulcer Index Indicator

* Update – Trading models that were designed earlier using Yahoo! Finance API have been rewritten to retrieve quotes from Bloomberg Markets or an Open Source API. Only US stocks and ETF quotes can be retrieved from the UI model at this time. See setup instructions. Background on Ulcer Index Ulcer Index (UI) is a […]

Read More →## Garch Modeling in Excel and Matlab

* Update – Trade and investing models that were designed earlier using Yahoo! Finance API have been rewritten to retrieve quotes from Bloomberg Markets or an Open Source API. At this time only US stocks and ETF quotes can be retrieved from the UI model. See setup instructions. Introduction to GARCH Modeling GARCH is a […]

Read More →