Options Trading for Beginners (Management and Tracking)

Option Contracts

Options Trading for Beginners As a beginner options trader, learning how to trade options can be an exciting experience, but it can also be extremely frustrating and very costly. There are some common mistakes that lead to many beginner options traders to lose large sums of money in a very short period of time. Here’s …

Read moreOptions Trading for Beginners (Management and Tracking)

Volatility surface chart (it’s impact on the profitability of option trades)

Implied Volatility Surface for AAPL

Volatility surface is the plot that can help you determine the best combination of the strike and the expiry date to maximize the profits on an Options Trade. Volatility Volatility is basically the fluctuation in the price of a product or a derivative. The more is the swing, the more is the volatility. There are …

Read moreVolatility surface chart (it’s impact on the profitability of option trades)

Unusual Options Activity – How to Identify, Act and Track for Success

Unusual Options Activity Benzinga

Introduction A common investment theory is that securities that are owned by institutional investors tend to trade with a closer correlation to the financial performance of the company or, in the case of futures contracts, with the overall economy. Traders, therefore, will frequently look at volume and implied volatility to determine future price direction.  Investors …

Read moreUnusual Options Activity – How to Identify, Act and Track for Success

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)