Yahoo Portfolio – Export Portfolio in Excel (to use with MarketXLS)

Yahoo 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)

MarketXLS New Release Version 9.2

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 …

Read moreMarketXLS New Release Version 9.2

Stock Volatility Calculator

stockvolatility

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 …

Read moreStock Volatility Calculator

Covered Calls – What They Are & How You Can Profit (with MarketXLS Data)

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)

Covered Puts – What They Are & How You Can Profit from Them (MarketXLS Options 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)

Portfolio Beta Calculator

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 …

Read morePortfolio Beta Calculator