Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Volume Weighted Average
My data table looks like this:
Date Price Volume 20070904 17.3 10 20070904 17.3 10 20070904 23.8 5 20070904 23.8 5 20070905 5.7 10 20070905 5.7 10 20070905 1.55 11 20070905 1.55 11 I am looking for a formula for this table Date WeightedPrice 20070904 20070905 So for each day, calculate the volume weighted average price. Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weighted Average | Excel Discussion (Misc queries) | |||
Weighted average | Excel Worksheet Functions | |||
weighted average | Excel Discussion (Misc queries) | |||
Weighted Average | Excel Discussion (Misc queries) | |||
Non zero weighted average | Excel Worksheet Functions |