Hello all, hoping for some help on this problem. Apologies if the title is not very descriptive, but I'm not sure how to describe this....
I have a spreadsheet that calculates stock trading signals using the daily stock price data as the input data.
I column C is the daily "high" price. Increasing the value in one row of column C causes (via a series of intermediate calculations) the figure in column M in the same row to increase, and the figure in column N to decrease. Initially, the value in N is higher than M, but I need to calculate the reversal point. At a certain value in column C, the values in column M and N will be equal - this is effectively the "crossover" point, where M becomes higher than N.
I can of course find this value of C by plugging in numbers using trial and error, but I need to do this multiple times and so want to automate it.
Can this be done automatically in Excel? I can't use Goal Seek since there is no fixed value for M or N, the "goal" is to make M and N equal.
Any help would be greatly appreciated! I don't really want to post the spreadsheet as it's huge and somewhat confusing!
Thanks!
Bookmarks