Monitor financial markets and asset performance

I need the daily market watch ready for the investment committee on Friday. Pull the closing prices for our core equity and bond holdings from the raw feed, recalc the portfolio-level returns for yesterday and month-to-date, and attach a one-line change explanation for any holding down more than 2%. Send it to Mark in portfolio strategy and then to Jenna in risk for e-signature, signers in that order. Check the NAV and formulas are correct before you send.

Before I circulate the market snapshot to executives, make it quick to read under time pressure: move the largest MTD losers to the top, put the three-week trend sparkline beside each asset, surface total portfolio drawdown as the first line, and flag any holdings with stale prices or missing trade tickets that would make a reviewer email me at 7 a.m.

Last night the automated price refresh returned a zero for our smallest municipal bond, and the dashboard now reports a 1.2% portfolio swing. I do not know whether the feed failed, the trade ticket is missing, or the broker adjusted the price. I am worried Mark will hold me responsible for an incorrect NAV if I send the briefing. What is the most likely cause and the best next move to resolve it before the 9 a.m. call?

Every month we lose half a day to manual fixes when late vendor prices and split corporate actions break the dashboards. I am tired of firefighting at month end and losing credibility with traders. What habit should I change in how I stage or validate incoming price data so we stop scrambling and can hand a clean NAV to Mark and Jenna on schedule?