You can either find a site that posts historical data (often downloadable as a text
or worksheet file), or write a macro that gets the price and puts it next in a column.
Another approach is Stephen Bullen's trick that remembers the last X values. I don't
know how it would work for daily values; I think it's for incoming data that changes
rather frequently. But if you want to try, his site is at http://bmsltd.ie.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______
