Is it possible ?

Quote from andrey_tech:

Perfect. It works. How can I add also 8, 13 and 21 days ? I can
not see the formula which you created.

Thank you very much for the vital help.:)
More...

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.

Quote from spike500:

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.
More...
 
Quote from andrey_tech:

You are right. Thanks for the help.
More...

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 :)

Quote from spike500:

More...
 
Quote from andrey_tech:

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 :)
More...

:D
 
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
 
You must log in or register to reply here.
Back
Top