Hello,
I'm having difficulty with a weighted average calculation. I have a list of dates, trade volumes and prices. My task is to create a weighted average price for these dates by month.
For example, for August 2012, I have 12 different trades being executed, 9 in July, 4 in June, etc. I'm trying to find a formula to give in this example 3 different weighted average price calculations, 1 for each month. Any suggestions?
Bookmarks