Simulation Game – Stock Market in Excel

Creating Stock Market Simulator using simple Excel functions

How boring the words Excel and Stock Market sound? With those sheets and numbers, they give a feeling of work-related environment, correct?
Welcome to the Simulation Course of Stock Market. Irrespective you are a student, working professional or a freelancer, Excel is a tool you will or are using on daily basis. On top of that, gaming and simulation add excitement and fun in whatever we do. This course combines all of these factors to provide a quick, project-based learning experience.

What you’ll learn

  • Project based course – End of the course you will have your own Real Time Stock Market Console.
  • Cover variety of functions – vlookup, sumif, iferror and much more through simulation.
  • Learn how to integrate live data from web in excel.
  • Create your own portfolio and watch it grow!.
  • How to create Data Validation List and autopopulate values across the excel.
  • Buy Sell Trade! Anytime with your own simulator.

Course Content

  • Introduction –> 1 lecture • 1min.
  • Setting up our Stock Market! –> 1 lecture • 6min.
  • Buy and Sell Section –> 3 lectures • 20min.
  • Calculating the Net Worth –> 3 lectures • 9min.
  • Real-Time Stock Market –> 1 lecture • 18min.

Simulation Game - Stock Market in Excel

Requirements

  • MS Excel – preferably the latest version installed.

How boring the words Excel and Stock Market sound? With those sheets and numbers, they give a feeling of work-related environment, correct?

Welcome to the Simulation Course of Stock Market. Irrespective you are a student, working professional or a freelancer, Excel is a tool you will or are using on daily basis. On top of that, gaming and simulation add excitement and fun in whatever we do. This course combines all of these factors to provide a quick, project-based learning experience.

The course begins by creating your own Stock Market with just 3 stocks and a dummy account. Here you will create buy and sell operations and calculate your net worth. Once you are familiar with this environment, we move on to real time stock market investment.

By accessing data from National Stock Exchange (NSE), we scale our game to real time investments. You will get to place your buy and sell orders of stocks from NSE and see your portfolio’s worth in real time.

You will learn functions like vlookup, sumif, iferror and much more apart from integrating real time data from National Stock Exchange.

All you need to do is, keep your excel workbooks open and follow the instructions.

The latest version of Microsoft Excel is preferred for this course.

How long will it take? Well, we are done in an hour!

Happy Investing and Gaming!