We can't do much with regards to Pages shelf, but would the view make sense using a date filter instead of pages? The "Latest Date Presets" with Date filter in 10.3 might help out for your case: Filter Data from Your Views. This is specific to date filters at the moment, so it is not an option for pages shelf or for other data types.
Default selections is a newer concept that our development team is tackling - the date filter concept was the most common on we heard, but its worthwhile to get more feed back. If you think this concept applies elsewhere or to other data types, I strongly encourage adding your notes and examples to the Ideas to help our developers understand the scenarios that may require further enhancements in this area.
Thanks Wilson for the quick reply.
It's a good suggestion, which normally would work but in our case we are want the functionality that the page shelf offers which is allowing the user to see the data day by day through the animation functionality.
In essence, the same "filter to latest date value when workbook is opened" functionality would be great on the page shelf.