Excel formula question.

newwurldmn said:
This is tricky as your data set is expanding but you need to see the latest point to know if you are in a new peak or not.
More...
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.
 
themickey said:
On a chart they are identified visually but human bias only sees things the brain wants to see.
On a spreadsheet you see them as values, you know exactly date and size, it gets rid of bias and noise.

I think I've mentioned this a number of times previously, for my way of trading, I prefer to look at numbers rather than charts, I can only view one chart at a time, in a spreadsheet I can view hundreds of stocks simultaneously and number crunch them into priorities/rankings.
More...
Still baffled by what specific calculation you are trying to obtain, but that's ok. Carry on.
 
themickey said:
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.
More...

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? :)
 
newwurldmn said:
i think he’s trying to determine the peaks and troughs in a stock price sequence.
More...
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. :)
 
themickey said:
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. :)
More...
I get what you are trying to accomplish. I don't get how are trying to accomplish it.

But like I said, carry on.
 
ondafringe said:
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?
More...
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.

ondafringe said:
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?
More...
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 must log in or register to reply here.
Back
Top