Stock Valuation – Dividend Discount Model - Click Here For Details
A two-stage discounted dividend model. In stage one, explicitly forecast the firm’s dividend over a five-year horizon. In stage two, forecast the firm’s dividend from year six to infinity and calculate its
continuation value as the present value of this infinitely growing annuity. Then, discount the future dividends and the date 5 continuation value back to the present to get the stock’s value.
Technical analysis - Custom Trading Tool
We use technical analysis functions for used with Microsoft Excel.
It allows us to create many types of technical indicators used in trading systems like Moving Average, Bollinger Bands, Average Directional Movement Index, Oscillators, True Range, Standard Deviation, Donchian Channels and many more. With these indicators you can easily perform end-of-day analysis or back-testing of historical stock data. The software comes with both formulas for Excel and a built-in Wizard to help you create the indicators. TraderCode is a very useful toolbox for stock traders. You can use it to compute technical indicator values for stock prices and plot them in Excel. TraderCode supports some of the most popular and successful indicators used by many analysts. Current implementations include Accumulation / Distribution Line (ADLINE) Average Directional Movement Index (ADX) Average True Range (ATR) Chaikin Money Flow (CMF) Commodity Channel Index (CCI) Directional Movement Index (DX) Donchian Lower Band Donchian Middle Band Donchian Upper Band Exponential Moving Average (EMA) Fibonacci Extension (FIBE) Fibonacci Retracement (FIBR) Fibonacci Fan (FIBF) Linear Regression Indicator (LRI) Lower Bollinger Band (LBB) Momentum (MOM) Money Flow Index (MFI) Moving Average Convergence/Divergence (MACD) Negative Directional Movement Indicator (NDMI) On Balance Volume (OBV) Percentage Price Oscillator (PPO) Percentage Volume Oscillator (PVO) Positive Directional Movement Indicator (PDMI) Rate of Change (ROC) Relative Strength Index (RSI) Simple Moving Average (SMA) Sine Weighted Moving Average (SWMA) Stochastic Oscillator (%K) Triangular Moving Average (TMA) True Range (TR) Upper Bollinger Band (UBB) Wilder s Moving Average (WMA) Williams %R
Excel- Technical Analysis
