If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Trendlines in excel

IrishMike · 2008-03-10 11:57:37

Need some help Below i have an image of what im trying to do Looking to take in a series of points (5000+) Want to examine a series of 30-40 in succession and determine if they have fallen above or below their individual trendline indicated by the red line above. Im looking to do this in excel without actually graphing…

Options

10-03-2008 12:57pm

#1

IrishMike

Closed Accounts Posts: 2,698 ✭✭✭

Join Date: September 2003

Posts: 2567

Need some help
Below i have an image of what im trying to do

Looking to take in a series of points (5000+)
Want to examine a series of 30-40 in succession and determine if they have
fallen above or below their individual trendline indicated by the red line above.
Im looking to do this in excel without actually graphing anything, in other
words i just want to recieve a signal that it has broken above or below this
trendline.
Even help as to how i would determine the trendline would be a great help
as linear regression is not working as there is too much noise and it doesnt
use the appropiate lows.
Thanks for any help
Mike

0