I have an idea, and it proves that you CAN do it in Monarch, but it doesn't mean you SHOULD do it in Monarch.
Note that this solution uses External Lookups which weren't in V7, so I won't take the time to list it here.
There's also a few key issues to address:
1)Do you want values filled in before/after the range date in your report? For example should the report carry the last price down to 12/31/2007?
2)How to handle January 1st, if the previous year's data is not available.
3)Whether to handle leap year or not?
4)What is the largest stretch that data would need to be carried down? Is a 5 day weekend/holiday the largest time span that should be considered.
My opinion is the program that generates this report is the best place to handle your need. But Monarch might be able to handle it if you had V8 or above.
Thanks for the reply Joey. Unfortunately, there's no program that's generating the list, it's just a dump out of a price file, which is why I was hoping that Monarch could help, but alas I'm stuck with the 7.0 for the time being. This is kind of what I thought but wanted to run it by the experts out there, thanks again!