Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Options For Dummies – With Tools Used By Hedge Fund Managers

Written by  Shubham Shah on 
Wed Feb 03 2021
 about OptionsOptions strategies
Options For Dummies – With Tools Used By Hedge Fund Managers - MarketXLS

Meet The Ultimate Excel Solution for Investors

  • Live Streaming Prices Prices in your Excel
  • All historical (intraday) data in your Excel
  • Real time option greeks and analytics in your Excel
  • Leading data in Excel service for Investment Managers, RIAs, Asset Managers, Financial Analysts, and Individual Investors.
  • Easy to use with formulas and pre-made sheets
Options For Dummies – With Tools Used By Hedge Fund Managers - MarketXLS

Introduction

There has always been an ambiguity around options trading regarding the potential profits and the risks involved. Some find it too risky, while others use it to hedge their portfolios. Investors have always found a way to manage their risk better, which only gets better with time. Today’s tools are not the same as yesterday, and the ones used tomorrow will be much better. The good news is that most of the tools are built around the old ones with mild modifications, and they are easy to understand.

In this article, I explain some of the tools and strategies used by hedge fund managers to negate some risk by including some derivatives in their portfolios. By the way, who are these hedge fund managers? Though the definition has evolved, the basic idea is that they are just like mutual fund managers, only with more diverse portfolios. Unlike mutual funds who like to stick to equities and bonds, hedge funds want to have various asset classes ranging from commodities to derivatives and many more to have a more risk mitigated portfolio.

The VIX

The role of the VIX (volatility index) cannot be overlooked while trading options. VIX gives an idea about the implied volatility of the market over the next month. Volatility in sync with a good expiry date and premiums can work wonders. The best part is there are strategies both for high and low volatilities. The aim is to gain from the swings in a particular underlying and limiting the risk involved. Below is a picture of VIX over the years.

Options For Dummies – With Tools Used By Hedge Fund Managers

There are two peaks major peaks, one during the 2008 global financial crisis and the other when the whole world was shut down because of covid. Therefore, it gives a clear picture of the market sentiment soon.

Strategies

Unlike stocks where strategies are limited, options traders are blessed with flexibility as they can play around with expiry date, premiums, and volatility to forge a strategy of their own. I have tried to table down some of the most commonly used option trading strategies used by hedge fund managers.

Options For Dummies – With Tools Used By Hedge Fund Managers

As you can see from the table almost all the strategies depend on volatility. Hence, the role of VIX on options trading cannot be negated.

Templates

Just like trading stocks, options trading also requires constant monitoring and adjustments in the trades along the way. Professionals use templates and advanced tools to keep a track of their profit growth. But these tools are very expensive and most of them are not even available for retail traders. MarketXLS comes with excel templates for all types of options strategies. You can not only download option chains directly to MS excel but also chose strategies based on your requirements and risk appetite. You can also track your profits/losses in real-time. These are some samples of how the templates look like and work.

Options For Dummies – With Tools Used By Hedge Fund Managers

You just need to put the stock symbol in the second column and you can know the net investment in a particular trade. This just a glimpse of what marketXLS is capable of as it encompasses all the major options strategies in its template repository.

The bottom line

I would like to end it by saying that options trading is no rocket and anyone can do it. All you need is a basic understanding of derivatives and some tools. Volatility is a major component in options as you have already seen.

Disclaimer

None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person.

The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein.

the article is written for helping users collect the required information from various sources deemed to be an authority in their content. The trademarks if any are the property of their owners and no representations are made

References

Learn more about options strategies here.

Learn more about VIX here.

 

 

 

#1 Excel Solution for Investors

Get Market data in Excel easy to use formulas

  • Real-time Live Streaming Option Prices & Greeks in your Excel
  • Historical (intraday) Options data in your Excel
  • All US Stocks and Index options are included
  • Real-time Option Order Flow
  • Real-time prices and data on underlying stocks and indices
  • Works on Windows, MAC or even online
  • Implement MarketXLS formulas in your Excel sheets and make them come alive
  • Save hours of time, streamline your option trading workflows
  • Easy to use with formulas and pre-made templates
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord