Ankur Mohan
In this article, we will look at how you can use MarketXLS’s portfolio beta calculator template to easily calculator Beta of your portfolios. What is Beta? Beta is a way to measure the Systematic Risk. Let’s say you are considering investing in an Amazon INC. Stock AMZN and you want to find out the total …
In most of the situations, it’s always better to trade options that are highly liquid and active. In this article, I will show you how you can use MarketXLS’s inbuilt option scanner to quickly find out the most active options from the list of all option contracts of stocks in your list. In very simple …
Read moreHow to find the Most Active Options (MarketXLS’s option scanner)
What is a Penny Stock Equity investments are known as “Penny Stocks” are one of the riskiest investments that investors can participate in. Penny stocks are any stock that trades outside of the major stock exchanges and trade at prices generally less than $10.00 per share. Even though Penny Stock Investing can be hugely profitable, …
Read morePenny Stock Investing (Risks, Rewards & Characteristics)
Fundamental analysis of stocks is the key method of determining a stock’s real or “fair market” value. Fundamental analysts search for stocks that are currently trading at prices that are higher or lower than their real value. With the MarketXLS add-in, you will be able to create highly flexible templates for the analysis of companies …
Often times, option traders not only want to see the historical prices for the stocks but also they want to see the Historical Option Prices for the option contract itself. MarketXLS makes it easy for you to get the historical option prices for a specific option contract by using very simple Excel formulas. In this …
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 …
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. …
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 …
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 …