Len,
Here's and idea that wouldn't be too hard to do: assuming that we can consistently download stock .csv file from somewhere...
Set up your indexes using Excel, and Paste Link the individual stock files into your first Excel worksheet. This way, when you open the Excel file each day, it will automatically update the stock files from the latest version of the individual .csv files.
Then, insert a new worksheet into your Excel file, and create a formula on this page that calculate the index weighted value using whatever type weighting you think is necessary. Also, make it reference the date from the previous page, and make appropriate columns to match the .csv file that we download for Neurostock normally.
Then, save your worksheet as an Excel file first, and then Save just the index page as a .csv file, into your Neurostock folder.
After this is set up, all you have to do is open the main file each day after downloading the stock files, and Excel will automatically load the new info. Creating a macro to do the .csv Save operation would make this easier also.
I've done this (except for the macro, which I just thought of) for those Rate of Change calculations we talked about a few days ago - and its worked pretty well.
The only hassle to this is just having to open the file and save it to the .csv file. Anyway, its just a thought - since I don't have any other means of doing it at this time such as that WOW program Jay's using, its worked for me.
Bill |
