Saturday, March 27, 2010

Stock Market/Chart Game

This is a stock market game based on real stocks data.

The "Yahoo and Google Downloader" software is used to download the stock data from the internet.

If you have not installed the “Yahoo and Google downloader” yet, please install it from the following link:

                                                                                                                                                         
The real stock data files can be used for other purposes. I am also developing following excel-based toolboxes that use the same stock data files:

·       Bulls vs. Bears Scoring System
·       The Diamondwise Charting
·       The Ranking System
·       The Pairs Trading

The download link is at the end of this note

Prove that you can make money by trading stocks in this game; Start friendly family competition using this game. It is fun.



This excel-based stock market game has 3 sheets: Introduction, DataSource, and Game.

Introduction Sheet:             
height=316                                                                                                                             
DataSource Sheet:                                                                                                                                
 height=316                                                                                   
For the first time use, you have to download data first. Make sure the "Yahoo and Google downloader" installed path is entered and correct in B1 cell, and then click Download Data” button.
All the data files will be stored in the "My documents\edgeme\data\" folder.

Cell B1 is the path you installed the “Yahoo & Google downloader”
Column A is the stock symbols; You can add or delete symbols
                                                                                                                             
                                                                                                                             
Game Sheet:                                                                                                                                                         

height=368                                                                     
Once the data downloaded, you can now play the game                                                                                                                                                                       
A one year stock chart is shown. The symbol and date are hidden and randomly chosen                                                                                                                             
You can buy or sell short the stock by clicking “Buy” or “Sell” button, or you want to see more data before trading, just click the “Move to Next Day” button.

Click “Move to Next Day” to see if your position is losing or winning.

If you don’t like the chart pattern of the current stock, click “New Stock”, a new stock chart will be shown.                                                                                   
                                                                                                                                                                                                                                                                                       
When you buy or sell, the next day's open price is used; when you close the existing positions, the current day's closed price is used.                                                       
                                                                                                                                                                                                                                                                                                                                 
You can change the number of shares to buy or sell  in cell N9
The current position shares are shown in cell N7. Negative shares mean that you sold short on the stock.

                                                                                                                                                         
Enjoy the game and making money

This is the very first version 1.0, and I am planning to improve it by add things like:

·       Allow user to seek specific chart pattern
·       Allow stop loss price
·       Track trade history and calculate the Edge after 100 trades, and analyze the trades and make suggestions to improve

                                                                                                                                                         
                                                                                                                                           
Meanwhile, I welcome any suggestions to make this game more fun. Send any comments and suggestions to me at edgeme88@gmail.com

When you open the ChartGame.xls file, if the following window shows up, you have to choose Enable Macros option:
height=198


Also you can make the chart window bigger or smaller by change the Zoom:

height=368



Download this Excel chart game from here:

http://sites.google.com/site/edgeme88/stockchartgame


Software Disclaimer                                                                                                                                                                                                                               
·       While I make every effort to deliver high quality software, I do not guarantee that the software is free from defects. My software is provided “as is," and you use the software at your own risk.             
·       I make no warranties as to performance, merchantability, fitness for a particular purpose, or any other warranties whether expressed or implied.                                                                     
·       Under no circumstances shall I be liable for direct, indirect, special, incidental, or consequential damages resulting from the use, misuse, or inability to use this software.                           
                                                                                                                                                                                                                                             

blog comments powered by Disqus

My Favorite Books