I think I have the hardpart done and that is getting the info from Yahoo.
What I am looking to do is to set up a workbook that will get me info, and chart that info every x amount of minutes in the given day, then at the end of the day, to archive the latest price, and then give me a chart of the current week/month/years data for either the complete portfolio, or a given stock.
I have been looking and I am certain that there are workbooks out there that do this, but I have not been able to find them.
I can either roll my own if needed, but I am not sure of the best way to lay out the data, or use an existing one (preferably with unlocked VBA - even if I need to register it, I like to be able to modify things)
So, I am either looking for design suggestions, or an already made workbook, either one.