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… Read more »
Commodities Trading Technical Indicators
Commodities Trading Technical Indicators This article is an extension of Calculate MACD in Excel and technical indicators covered in an earlier post. The same trend indicators have been applied towards Commodities and… Read more »
Williams R Indicator
Williams R Indicator Named after Larry Williams, %R is a technical analysis indicator that shows current closing price in relation to the high and low for a given look-back period,… Read more »
Sharpe Ratio Calculator
Sharpe ratio is a measure of risk and it is named after Nobel Laureate William F. Sharpe. The Sharpe ratio simply stated is a ratio of return vs risk. Given… Read more »
Plot Candlestick Chart Excel
* 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… Read more »
Implied Volatility Calculator
Implied volatility is a term which is very commonly used in the context of options trading. This is a very important metric to consider for your trading strategies. If you… Read more »
Exponential Moving Average in Excel
Step by Step guide to calculate the Exponential Moving Average (EMA) in Excel and VBA enabled Web Service with free download.
Find Implied Dividend Yield from Option Prices
Dividend estimates are, not only of interest to equity investors who want to earn a steady income, but they also play an important role in derivative pricing for equity forwards, futures,… Read more »
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… Read more »
Adword Budget Optimizer
How much should my AdWords budget be? This is a very common and an important question for advertisers. It is also one that doesn’t have a straightforward answer. If AdWords… Read more »