If anyone is doing this I have a very similar request and you may be able to do both at the same time.
I'm looking for the weighted average price to be calculated in real time. Here is a picture to illustrate what I require:
The total matched is 5059 and the weighted average would be calculated:
......(3.30 x 542/5059)+(3.25 x 914/5059)+(3.2 x 760/5059)......
Ideally the Wap would appear on a column on the "standard" apreadsheet like this
