How to find the Most Active Options (MarketXLS’s option scanner)

Most active options

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)

Penny Stock Investing (Risks, Rewards & Characteristics)

Penny Stock Investing

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 with MarketXLS

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 …

Read moreFundamental Analysis of Stocks with MarketXLS

Mutual Funds Prices in Excel (With MarketXLS Addin)

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)

Option Scanner

 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

Black Scholes Excel

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