I'll add them; it's easier and faster done by myself. Will post the sheet here. You can see the formulas but on some sheets i used shortcuts to create the correct timeframes.
OK. I can see the formulas written by you now. Thanks for your perfect work. Now I am verifying all the data.
no problem. just check out the formulae and see if you can extrapolate how to apply them to various output timeframes. if you can get the last one with the nested if statements (Column I) to work for the various timeframes, that will be impressive and you'll learn along the way. if you need some help, just ask and i'll explain how you can convert them to any desired output timeframe. take a look at how spike put it all together. very nice and neat. he also gives good advice about locking the output cells, etc.
I dont know, how can I thank you spike. But one think I am quite sure, your perfect work will be the center-stone of my future analysis. God bless you
for 3/4 months i was searching how to do this i wanted to convert daily ms data to yealy data for the last 15 years hope your this utily will help me do this i have exported the quaterly data to excel from my sware will try ur utilty. Thanks in advance. -sanjayt