* 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 →Category: Technical Analysis
Exponential Moving Average in Excel
* Update – Trade and Investing models that were earlier written using Yahoo! Finance Stock API have been rewritten to pull quotes from Bloomberg Markets API. At this time only US stocks and ETF quotes can be retrieved from this model spreadsheet. See setup instructions. A primer on Exponential Moving Average The moving average method is […]
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 →Risk Adjusted Investment Performance Measures
Your portfolio can have a positive long term impact when the risk efficiency of your portfolio is maximized. Many investors tend to be risk averse. So, if you are going to assume some risk in your portfolio as a trade off for a higher return, you should aim to get the most out for your […]
Read More →