* 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 →Category: Charts
Garch Modeling in Excel and Matlab
Introduction to GARCH Modeling GARCH is a time series modeling technique that uses past variances to predict future variances. This post demonstrates how to do a simple GARCH modeling Excel and Matlab. GARCH stands for Generalized Autoregressive Conditional Heteroskedasticity. The series is heteroskedastic when the time series is said to have GARCH effects – when […]
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 Precious Metals here. The idea behind investing in precious metals is that it protects your portfolio against high inflation. Historically, people look to commodities like […]
Read More →Williams R Indicator
* Update – Trading models that were earlier written through Yahoo! Finance Stock API have all been rewritten to pull quotes from Bloomberg Markets or an Open Source API. At this time only US stocks and ETF quotes can be retrieved from this model spreadsheet. See setup instructions. Williams R Indicator Named after Larry Williams, […]
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 and ETFs can be retrieved from the RSI model plot. See setup instructions. A primer on Candlestick charts Candlestick charts originated in Japan during the […]
Read More →Calculate MACD in 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 and ETFs can be retrieved from the MACD model. See setup instructions. Moving Average Convergence Divergence (MACD) MACD is a popular trend-following momentum indicator. The […]
Read More →