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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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…

10-03-2008 11:57am

#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