Crude oil prices: value conversion

Hi everyone,
as part of a research project, I need to conduct an analysis of crude oil prices.

The attached excel project contains Brent Europe daily spot prices from Datastream for the past twenty years. Unfortunately, I am having difficulty converting the daily values into weekly numbers.

I have tried implementing some of related advice that has been posted to this forum, but it was no help. Any help would be greatly appreciated!

Cheers,
onze

Hi onze,

Welcome to the forum.

See the attached file where I have converted the data into weekly format starting from Mon to Fri.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hey Dili,
http://www.youtube.com/watch?v=30dXrUm3o6g
thank you so much, it I can apply =IF(C7="Mon",SUM(OFFSET($B7,0,0,5,1))/5,"") now to all of the remaining 38 crude oil types.

The only thing I changed (which is basically my fault, as i didn't explicitly say i need average values) is add the /5. Not an elegant solution, but it is efficient .

cheers
onze

You are welcome onze... Cheers

You can simply avoid following formula to avoid division by 5:-

[code
=IF(C7="Mon",AVERAGE(OFFSET($B7,0,0,5,1)),"")
[/code]Please Login or Register to view this content.[/code]

regards,
DILIPandey

<click on below 'star' if this helps>