Excel formula question.

I've got it just at 3 months, that's about enough time to catch a minimum of 2 waves.
Old data over 3 months is peeled off.

 

Still baffled by what specific calculation you are trying to obtain, but that's ok. Carry on.

 

i think he’s trying to determine the peaks and troughs in a stock price sequence.

 

So the hidden rows are crunching raw data and placing (in this case) either a number or an "*" in the row/column for that symbol/date... a new column is auto-added to the 16 rows every day... so the spreadsheet will continuously expand to the right...but you are only using a 3 month lookback to determine peaks/valleys?

If so, for the lookback period, you want to aggregate all the numbers in each row to see them side-by-side, segregated for each symbol, so you can easily visualize peaks/valleys?

Or something close to that?

 

Yes, think about it @SunTrader, when you view a chart, what are you looking for most of the time?
The trends, higher highs, higher lows.... etc
What are those higher highs and lows, well they are the Peaks and Troughs.
I'm surprised you are wondering.

 

Yes I that is plainly obvious.

 

I get what you are trying to accomplish. I don't get how are trying to accomplish it.

But like I said, carry on.

 

The spreadsheet won't continually expand to the right, the sheet is 93 columns wide and it will forever be 93 columns, unless I wish to add more lookback.

Yes, I want finally a table where last 2 peaks are identified so I can calculate rising or falling trend.
It's not so much visualizing, it's more calculating, I will have a cell result which calculates the trend.
I'm gunning for start of trends and end of trends result.

 

You mean how it's done mathmatically?

 

That is what I have been getting at from my first post in this topic, yes.

What mathematically are you trying to do?