Calculate MACD in Excel

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 →

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 →