Trendlines in Excel

Cana anybody help with the formula for projecting a trendline value in Excel. I have two points defined and draw a line from high to high, if this trendline was drawn several hours ago, how can i get the value it is at the current time?

Citizen2007 said:

Cana anybody help with the formula for projecting a trendline value in Excel. I have two points defined and draw a line from high to high, if this trendline was drawn several hours ago, how can i get the value it is at the current time?

Click to expand...

I am not an expert in coding or Excel, but have you tried simple geometry? Now you have two points, I suppose you can just use y = mx +c to find that out. c is the starting price of the trendline. m can be found with the two points, and x is the number of bars from the starting bar.

Thanks for your reply GCC . I will have a play about with the idea.

Thank you GJ, that has made it a lot clearer.

Much appreciated.