I am working on identifying horizontal support and resistance levels on the universe of SP500 stocks using Market Profile. I like market profile to identify the high and low boundaries of consensus value/liquidy/range/chop. Price is watched at these areas for rotation back into the "value area" or, volatility/liquidity search for new value area. I have noticed, of course, that trend is a good thing and possibly it is good when the value area boundaries that I will screen for also converge with the upper and lower trend line ( horz S/R and a sloping S/R simultaneous.) To get to the point: I would appreciate any feedback offered on calculating the sloping trend(not the horz market profile). I am using Eodd data using Excel/VBA. I am am going to calculate linear regression and scan for positive slope on 30,60,120,240 day data seperately. This alone is useful to me. What I am thinking of ( for lower trend line) is sliding the y intercept down in small increments looking basically for when I am no longer tagging data and stop there designating that line as the bottom trend line. I have drawn many chart combos by hand and see that this may have limited value. Is there a simple method(math challenged here) to do a better job at this? Thanks. Believe me, I've considered just looking at the charts but....