Analyze market activity and trends

I compiled the weekly market activity spreadsheet and annotated the topline trends. Send the slide of key indicators to Maya in research and then to Tom in strategy for review, in that order, with feedback requested by Monday. Before sending, ensure the price change calculations are correct, the date ranges align, and that any outliers are explained or called out.

Before I share this market-trends file with research, make it easy for Maya to interpret — put the three most important trend numbers at the top, make the timeframe for each chart explicit, and flag spikes or drops with a short possible cause. Also list any data-quality concerns that would make a reader hesitate to act on the numbers.

While updating the market activity sheet I saw a sudden trading-volume spike on July 12 that looks anomalous. Maya in research needs to decide whether to treat it as a real signal and Tom in strategy may react. I’m worried it could be a feed error or a duplicated row, but I don’t have access to the raw vendor feed to confirm. What quick checks should I run in the spreadsheet to diagnose whether this is a real market move or a data artifact, and how should I summarize the uncertainty to Maya so she can decide on action?

Every week we encounter one or two suspicious outliers in the market sheet that demand time-consuming manual verification and slow decision-making for Maya and Tom. Where are we most likely wasting time — in how we ingest feeds, the lack of a raw-data snapshot, or in ad hoc QC — and which single habit should we change so 80 percent of these outliers are resolved or explained before the report goes to research?