Ankur Mohan The United States enjoy a massive mutual fund base. The availability of so many mutual fund investment opportunities, however, comes with the challenge of proper market analysis. Considering that past performances are no longer an indicator of improved dividends and capital gains in the future, mutual fund investors need to base their analysis on the … Read moreMutual Funds Prices in Excel (With MarketXLS Addin)
As an Options trader, you want to be as efficient as possible in finding the best option contracts to trade. With thousands of options contracts even on a few stocks, it becomes overwhelming and time-consuming to go over various contracts quickly. So, we have added an Option Scanner in MarketXLS which essentially lets you choose … Read moreOption Scanner
For years, Google Finance portfolio tracker has been the goto portfolio by many investors to help them monitor the markets and their portfolios. However, due to some significant changes in Google Finance in 2017, it does not seem to provide the full coverage of the markets any longer and lacks the many investors will like. … Read moreGoogle Finance Portfolio Alternative
Black Scholes Excel model as described in this article comes along with MarketXLS as a template. Black Scholes Excel model is perhaps the most famous formula in all of the finance. The Black-Scholes Formula is sometimes also called the Black-Scholes-Merton Formula Blacksholes model puts an analytical framework and mathematical model to answer to question on … Read moreBlack Scholes Excel
Option trading gives you great leverage while trading where you are able to control many more shares for your investment than if you were to just invest in shares. However, with this leverage comes a lot more risk as well. This Option Profit Calculator Excel template will provide you with the ability to quickly find … Read moreOption Profit Calculator Excel (Template)
How to Build an Understanding of Real Estate Stocks The first step to understanding real estate stocks is to try not to be intimidated by all the information you’ll find offline and online. Here on MarketXLS we believe that intimidating financial concepts like cryptocurrency and real estate stocks, while inherently complex, are actually not that … Read moreHow to Build an Understanding of Real Estate Stocks
High Yield Dividend Stocks Searching for High Yield dividend stocks has never been easier with MarketXLS.com. Current market volatility, has driven investors to search for alternative choices. High yield dividend stocks can help provide valuable income in a down market or cover normal expenses during retirement. Additional benefits come from the compounding effect of monthly … Read moreHigh Yield Dividend Stocks
On Balance Volume in Excel MarketXLS.com offers On Balance Volume excel based utilities to enhance your personal spreadsheets. Utilizing the security identifier and a date rage, we can generate OBV trend lines allowing us to enhance our charting capabilities by provide a powerful analytical tool. Historically the On Balance Volume indicator has been a valuable … Read moreOn Balance Volume (formula in Excel)
Time value of money is the change in value or purchasing power of money with the time. In the period of inflation purchasing power of money is going down day by day. If we invest or deposit some money in the bank, then we receive a return or interest on such money. Such return or … Read moreTime Value of Money (Excel Formula – Calculator)
Ratio Analysis, also known as Financial Statement Analysis, involves evaluating the financial statements of companies, and comparing those results to similar companies; typically within the same sector or industry. Because ratios are most useful when compared to other ratios, and it is important to compare relevant ratios. Example; Ratio Analysis would not be useful in … Read moreFinancial Ratio Analysis in Excel (Download Excel Template)