MDA - Market Direction Analysis

[hiker]

Tom, here's how I used to do (generically) some of what you are talking about (i.e., downloading a lot of closing figures or aother data at one time)

- Form a list of equities you're interested in on Yahoo & save it as a book mark.

Example:http://finance.yahoo.com/q?s=csco+msft+amat+txn&d=v1

- Click on "save to spreadsheet" (at lower right).
- Click on File - save as - choose quotes.csv and txt file
- Link a column on your main spreadsheet to the quotes.csv file
- Copy that column in the main spreadsheet, then save as values-only elsewhere
- Repeat the same the next day

This is really not as complicated as it looks here in print. All you are really doing each day is saving the days numbers to the csv file, then cut-and-pasting once in your main excel file.

Hope this is clear enough to be useful.