QuotesNow |
| You will need software such as Winzip (to open a new window or go to http://www.winzip.com) to extract the contents. |
|
|
|
NOTES: This is a simple program that will retrieve historical stock quotes from Yahoo. After getting your stock quotes, perform your own analysis to pick winning investments!!! Software users should have some knowledge of Visual Basic coding and Excel Spreadhsheet usage before making changes. Use it, modify it any way you want!! This program was created using Micrsoft Excel 97 Service Release 2. I have no idea if it will work on other releases or versions of Excel. Try it and see!! This code provided herein is provided free of charge and may be used or given away freely. I have experienced the following: 1) Yahoo occassionally changes the required parameters to get quotes. 2) Quotes are usually (but definitely NOT ALWAYS) available by 8:00 AM Eastern time. 3) Yahoo sometimes send duplicate quotes for a given date. This program attempts to eliminate dups. 4) Sometimes a given date is "missing". All of the above could be unqiue to me. Maybe your experience will be different. Basic usage: 1) enter stock symbols in column A of the spreadsheet named "stocks", beginning with cell A1 then A2, etc... 2) do not leave empty cells, as the program will stop looking after the 1st blank cell is encountered in column A 3) If adding symbols, be sure to press enter, or otherwise make sure Excel has accepted your input, or the "Get Stock Quotes" cannot be pushed. 4) press the "Get Stock Quotes" button The date range of quotes is about one year, this can be changed in the procedure named "openCSVWorksheets". |
|
|