Ankur Mohan
In this article, we will look at how we estimate the volatility based on the history of a stock price movement. With MarketXLS, you can simply use the stock volatility function to turn Excel into the stock volatility calculator. Volatility comes in various forms and what MarketXLS volatility functions return is the simplest form of …
MarketXLS is the best way to stream reliable real-time stock quotes in excel. In this article, I will show you how you can use hundreds of MarketXLS formulas and custom functions to stream real-time live prices of stocks in your Excel sheets. How does it work? Once you install MarketXLS, a new menu will show …
Key Updates in this release 1 New Function Search UtilityTo make it easier for you to search for a function and get the details on it, in this release, we have a new Search and Help button on the extreme left of the MarketXLS menu. So, instead of browsing through the Excel-based function list, we …
Wondering what covered calls are? In this article, we are going to tell you what a covered call is, when you would use it, and how MarketXLS can help you in applying the strategy. What are Covered Calls? Covered calls are a bullish investment strategy. You would usually consider applying the covered calls strategy when …
Read moreCovered Calls – What They Are & How You Can Profit (with MarketXLS Data)
In this article, we are going to demonstrate what a covered put is, when you would use it, and how MarketXLS can help you in applying the strategy. What are Covered Puts? A covered put is a bearish investment strategy. You would usually consider applying it when you expect that a stock price might fall, …
Read moreCovered Puts – What They Are & How You Can Profit from Them (MarketXLS Options Data)
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 …