Look at
Chip Pearson's website.

'Excel Redirect' (http://www.cpearson.com)


I think you also want to look at the effective data to be the data
which is closest to the activity date since the price may change a
couple of times. I cn easily do this with a macro but it appears you
are looking for a formula solution?


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=190056

http://www.thecodecage.com/forumz