I’m a small-cap share trader and would like an Excel-based tool that calculates Volume-Weighted Average Price (VWAP) on the fly. The sheet only needs to work with two columns fed by my data provider: trade price and corresponding volume. As new ticks stream in, the VWAP should update instantly without requiring manual refresh. Core requirements • Accept a real-time data feed (I can pipe prices and volumes into designated cells; your solution should listen to those cells). • Perform continuous VWAP calculation during the session, resetting automatically at the start of a new trading day. • Keep the workbook fast and light—no charts or extra visuals, just the running VWAP output and today’s cumulative totals. • Solution can be built with native formulas, VBA, a lightweight add-in, or Power Query—whichever delivers the smoothest live update. Please comment the code clearly so I can tweak ticker lists later. Deliverable A ready-to-use .xlsx or .xlsm file plus any supporting VBA modules or add-in files, along with a brief usage note showing where to paste my streaming data and how the daily reset is triggered. I’m happy to test with sample data the same day you send it and will confirm acceptance when the VWAP updates in real time without lag.