I have some historical weekly price data for different products during 4/18/2011 to 9/26/2011. (please check the downloadable file for format)
I need some formulae to check the following:
1) sequence of prices: does the price appear for consecutive weeks? a blank would break the sequence. If yes, I need the number of consecutive weeks the price was quoted for.
For eg: the 1st product (row 2 data) has 2 sequences (0.96,0.96) & {1.02,1.02}; In such cases I also need the number of squences and the longest(most recent) sequence should be considered; in this eg (1.02,1.02) is considered.
2) Price Trend: in a valid sequence whether the price trend is upward or downward or neutral.
row 28 data has a downward trend
row 32 data has a upward trend
row 33 data has neutral/no change trend
3) what is the maximum weekly price shift on in terms of consecutive weeks?
experts please help!
The sample data file could be downloaded using this link:
http://dl.dropbox.com/u/44143116/TrialData.xlsx
I need some formulae to check the following:
1) sequence of prices: does the price appear for consecutive weeks? a blank would break the sequence. If yes, I need the number of consecutive weeks the price was quoted for.
For eg: the 1st product (row 2 data) has 2 sequences (0.96,0.96) & {1.02,1.02}; In such cases I also need the number of squences and the longest(most recent) sequence should be considered; in this eg (1.02,1.02) is considered.
2) Price Trend: in a valid sequence whether the price trend is upward or downward or neutral.
row 28 data has a downward trend
row 32 data has a upward trend
row 33 data has neutral/no change trend
3) what is the maximum weekly price shift on in terms of consecutive weeks?
experts please help!
The sample data file could be downloaded using this link:
http://dl.dropbox.com/u/44143116/TrialData.xlsx
