To calculate our VWAP, we want to sum our TPVs to that time point, and divide that total by volume to that time point. Our Excel formula thus looks like this for cell H2: The core thought behind ...