Ankur MohanYahoo Portfolio is a great way to keep track of your investments and stock purchases online. Yahoo Finance portfolio has a great and intuitive way to add your transactions and then track your portfolio in real-time. And with the “Create New View” screen you can simply add many more parameters in the table and compare …
Read moreYahoo Portfolio – Export Portfolio in Excel (to use with MarketXLS)
There’s more than one way to gain exposure in and profit from the stock market. Investing in stocks as the primary asset is one, and trading contract for differences or CFDs is another. Stock trading and stock CFD trading each come with their own sets of risks and rewards and are suitable for different kinds …
Key Updates in this release 1 New Portfolio Analytics FunctionsIn this release we have added very advanced portfolio analytics functions. All these functions take a portfolio as an input and then return results. The results can be a number or result data table. A portfolio is essentially a range of cells that has the stocks in …
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 earnextra income. You can be an active trader and watch for dips and surges in themarket or be a passive investor and wait for your assets to increase in valuein the long run. A lot of people say that investing your money in the stockmarket …
Read moreInvesting 101: Basic Steps On How To Buy Stocks Online
In this article, we will look at how you can use MarketXLS’s portfolio beta calculator template to easily calculator Beta of your portfolios. MarketXLS has a very strong portfolio analytics engine that can get you all kind of analysis of your portfolio with easy to use Excel functions What is Beta? Beta is a way …
