Bollinger Bands Trading Strategy

Bollinger BandsNamed after famous technical analyst John Bollinger in 1983, Bollinger Bands are a notable technical analysis technique used by many investors. Traders use this technique to determine whether a stock is being overbought or oversold. When prices move near the upper band, the more overbought the security is and when the price reaches the … Read moreBollinger Bands Trading Strategy

Dividend Payout Ratio – (Top 10 stocks with highest payout in 2017)

What is Dividend Pay Out Ratio For dividend stock investors, the dividend payout ratio is a core measurement. Using this method to primarily determine whether an investment will be made. The dividend payout ratio is a metric to calculate the total amount of dividends paid to shareholders relative to the total earnings for the same … Read moreDividend Payout Ratio – (Top 10 stocks with highest payout in 2017)

Times Interest Earned Ratio (and 4 more to analyse a company’s debt)

What is Times Interest Earned Ratio Times interest earned ratio indicates a company’s ability to meet interest payments when they come due. The higher the ratio the more easily the company can meet its interest expenses. Times interest earned ratio is also known as Interest Coverage Ratio Typically you would look at this ratio along with … Read moreTimes Interest Earned Ratio (and 4 more to analyse a company’s debt)

Margin of safety analysis of stocks with formula in Excel (with MarketXLS)

Let us find out if there is a fast and easy way to screen stocks that are underpriced by the market using margin of safety analysis of stocks. Margin of safety analysis of stocks Key Concepts Before we get down to the analysis, let us understand the key concepts we will use to perform this … Read moreMargin of safety analysis of stocks with formula in Excel (with MarketXLS)

Change in Working Capital (How to Interpret and Calculate) in Excel with MarketXLS

working capital multiple companies

What is working Capital and how to calculate it in Excel with MarketXLS Analysts and investors will frequently refer to something called the net working capital. Or a lot of times they will just call it working capital for short. So working capital is very simple it’s like the current assets minus the current liabilities … Read moreChange in Working Capital (How to Interpret and Calculate) in Excel with MarketXLS

How to Build an Understanding of Forex Trading

How to Build an Understanding of Forex Trading There is plenty of information on the internet that discusses forex in-depth, making it hard to for new traders in terms of where they should begin their educational journey. The vast amount of information can be quite overwhelming, especially with all the numbers that need to be … Read moreHow to Build an Understanding of Forex Trading

Download Gordon Growth Model in Excel (with MarketXLS™ Template)

Gordon Growth Model in Excel

Gordon Growth Model is a popular valuation model that analysts use to calculate the intrinsic value of a stock based on the expected dividends in the future. In this article we will learn about what Gordon Growth Model is and how we can build the Gordon Growth Model in Excel. Consider a company that is … Read moreDownload Gordon Growth Model in Excel (with MarketXLS™ Template)

Using MarketXLS and Excel to easily see a real time snap shot of your portfolio

I have been learning to invest over the past 2 years—it is so much fun! My investments are spread over 3 different brokerage accounts, but I like to look at all of them together. MarketXLS, combined with my knowledge of Excel, allows me to manage my stock portfolio in Excel. Since I’m only about 2 … Read moreUsing MarketXLS and Excel to easily see a real time snap shot of your portfolio