Interactive Course

Options Trading in Spreadsheets

Learn how to price options contracts and visualize payout of various options strategies using spreadsheets.

  • 4 hours
  • 16 Videos
  • 60 Exercises
  • 1,058 Participants
  • 5,200 XP

Loved by learners at thousands of top companies:

ea-grey.svg
roche-grey.svg
intel-grey.svg
t-mobile-grey.svg
uber-grey.svg
ebay-grey.svg

Course Description

Options are an extremely important part of the financial markets. They matter not only to traders and asset managers, but also to anyone that receives stock options from their employers as part of their benefit packages. Understanding what options are — and, indeed, how they can make you money — can be made a lot easier with the use of technology. Throughout this course, you'll work with data and formulas to help you get the most out of trading via Google Sheets. By the end of this course, you will be able to use Google Sheets to build a valuation model from scratch and use it to price actual option contracts. Come along on this fun and interactive journey with Google Sheets!

  1. 1

    Introduction to options

    Free

    In this chapter, you'll take your first steps on the path to mastering option valuation models in spreadsheets. In this chapter, you will learn the basics of derivative contracts known as options. You will find out how to use spreadsheets to perform basic operations to compute the value of different types of option contracts.

  2. Option Greeks

    In the third chapter, you will take a trip to the United States and then to Greece to learn the main elements of the Black-Scholes model, which enables you to calculate the fair value of an option contract and to work out its sensitivities to various factors, such as changes in the price of the underlying asset and time decay.

  3. Options (and Strategies), Illustrated

    Things get slightly more complex in this chapter. You will learn option strategies, or combinations of option contracts designed to profit from your view of the markets. By the end of the chapter, you will gain knowledge of some of the most popular strategies such as bull and bear spreads and learn how to use spreadsheets to visualize possible outcomes of your strategies, while learning several useful spreadsheet functions along the way!

  4. Binomial Model for Option Pricing

    In the final chapter of the course, you will master the binomial option pricing model. It is a very useful tool, which enables you to compute the present value of an option contract based on the likelihood and magnitude of changes in the price of the underlying asset. You will utilize advanced spreadsheet formulas to build the model and expand it by an additional period.

  1. 1

    Introduction to options

    Free

    In this chapter, you'll take your first steps on the path to mastering option valuation models in spreadsheets. In this chapter, you will learn the basics of derivative contracts known as options. You will find out how to use spreadsheets to perform basic operations to compute the value of different types of option contracts.

  2. Options (and Strategies), Illustrated

    Things get slightly more complex in this chapter. You will learn option strategies, or combinations of option contracts designed to profit from your view of the markets. By the end of the chapter, you will gain knowledge of some of the most popular strategies such as bull and bear spreads and learn how to use spreadsheets to visualize possible outcomes of your strategies, while learning several useful spreadsheet functions along the way!

  3. Option Greeks

    In the third chapter, you will take a trip to the United States and then to Greece to learn the main elements of the Black-Scholes model, which enables you to calculate the fair value of an option contract and to work out its sensitivities to various factors, such as changes in the price of the underlying asset and time decay.

  4. Binomial Model for Option Pricing

    In the final chapter of the course, you will master the binomial option pricing model. It is a very useful tool, which enables you to compute the present value of an option contract based on the likelihood and magnitude of changes in the price of the underlying asset. You will utilize advanced spreadsheet formulas to build the model and expand it by an additional period.

What do other learners have to say?

Devon

“I've used other sites, but DataCamp's been the one that I've stuck with.”

Devon Edwards Joseph

Lloyd's Banking Group

Louis

“DataCamp is the top resource I recommend for learning data science.”

Louis Maiden

Harvard Business School

Ronbowers

“DataCamp is by far my favorite website to learn from.”

Ronald Bowers

Decision Science Analytics @ USAA

Sergei Balashov
Sergei Balashov

Chartered Financial Analyst

Sergei Balashov is a Chartered Financial Analyst based in London, UK. A former financial journalist, Sergei left that career to fully focus on the technical side of the financial profession. He is a data science enthusiast with a keen interest in the impact of data science techniques on economic analysis.

See More
Collaborators
  • Chester Ismay

    Chester Ismay

  • Sara Billen

    Sara Billen

  • Maggie Matsui

    Maggie Matsui

Icon Icon Icon professional info