Graphing fund closing prices from Bloomberg using time series with different dates

I (my boss) want to create an excel sheet which streams closing prices on six different mutual funds, from Bloomberg. The sheet has to be able to create one chart with all the funds in it for comparison (thus the funds will be indexed, all starting on 100. Don't worry about the indexing part - it's been taken care of). The problem is that the funds doesn't quote closing prices in a standardized way. Some quote daily, others weekly, and the funds are traded on exchanges open at different times. When the funds quote new closing prices, the prices are added to the existing column of historical prices.

The data should be charted automatically as the closing prices are updated, and the issue with the different dates in the time series needs to be addressed, in order for the chart to compare the funds to each other on the different dates. I almost solved this by looking at this post: http://peltiertech.com/WordPress/plo...fferent-dates/, however, this will only chart the data over a specific fixed period, and it does not work if more data is added in automatically on a daily/weekly basis.

FYI: In order to get the actual prices, you need a Bloomberg terminal, however this problem can still be solved even though you don't have one. I use =BDH(security_ticker_in_Bloomberg;"PX_LAST";start_date;end_date), where end_date is set to a cell =TODAY(), and start_date is set to the end_date cell, minus the chosen number of days I want charted back in time.


All help will be appreciated!

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.