WELCOME

I discovered http://finance.yahoo.com/ on Good Friday in 2006. I had taken a week off from work and as usual I had become bored. Stumbling upon this site I began downloading historical stock data for various stocks. I opened up the historical data into Microsoft Excel. I soon found myself performing numerous and repeated calculations in an effort to "look for patterns" that might predict performance (called Technical Analysis).

I've been programming computers for a very long time so I began experimenting with "automating" this process. I had a lot of success with both the original and subsequent versions of my Excel applications. I decided that my automated process was still a bit cumbersome. I wanted to give the user of Excel a way to write scripts that would automate the loading and 'crunching' of data. Thus was born Stock Market Evaluation Program (SMEP).

SMEP is an Excel spreadsheet bundled with some .EXE files to manage downloading of data. It supports the "Stock Market Scripting Language (SMSL)". This is a work in progress. Please take a look around this site, download the program (you'll need Excel 2007 as a minimum), and give it a whirl.

Look at two samples below to get a sense for how SMEP works.

Regards,
Chuck

Case Study #1

SMEP Forum

The SMEP forum is dedicated primarily to the Stock Market Evaluation Program. Please stop by and visit. You can ask questions about SMEP, report bugs, and request features for future versions. I'm always interested in meeting other software developers so feel free to share your projects. I'm always open to learning about algorithms and other techniqes to evaluate stocks.

CAUTIONPlease don't spam the forums or post anything offensive. Thanks, Chuck

Download latest version [560 KB]

The zipped file contains the above folder and file structure.
smep.xls is the starting point. The spreadsheet contains numerous macros so you must accept them when prompted. dlfile.exe and dl.exe are used by SMEP to download historical stock data from finance.yahoo.com. The subfolders may be explored by curiousity seekers but is not necessary.

This is a work in progress. The charting is incomplete and therefore unreliable. The links available in SMEP have not been verified to be valid.

Download latest SMSL Manual [201K]

The Stock Market Scripting Language (SMSL) is a scripting language that I created. The manual provides number samples of how the program may be used.

Sample 1 - Download Historical Stock Data from Yahoo [YHOO]

1. Open SMEP in Excel. Click Run Script.

2. Select Script.

3. Run the Script.

4. Yahoo data is saved to "history" folder. Data saved as a CSV (comma separated values) file.

The "Download" command will download 12 months of historical stock data for YHOO. There are several download options covered in the SMSL Manual.

Sample 2 - Download Historical Stock Data from Gamestop [GME]

1. Run the Script.

2. Data is loaded into StockData spreadsheet and calculations are performed.

The script above accomplishes several things very quickly. It downloads the stock data, clears the StockData worksheet, adds column lables, fills two columns with '1s', performs calculations, and determines buying and selling based upon the user defined parameters. The SMSL Manual will explain each of these lines.

Sample 3 - Download Historical Stock Data from Apple [GME]

1. Run the Script.

2. Display the results of all the buys and sells based upon this script.

Here's an example that tests the users calculations, buy and sell rules, against Apple during a rise in stock value.