Ankur Mohan
Investing in the stock market is an excellent way to earn extra income. You can be an active trader and watch for dips and surges in the market or be a passive investor and wait for your assets to increase in value in the long run. A lot of people say that investing your money …
Read moreInvesting 101: Basic Steps On How To Buy Stocks Online
Better Investments, Faster Decisions, Better Research Book your demo Meet the #1 Excel-based Investment Research Solution for Serious Investors 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 …
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 …