# Slope of Moving Average off Indexed Lookups

1. ## Slope of Moving Average off Indexed Lookups

I need to create the slope of function of relationship between time and price. I am trying to make it between the two most recent days. On the 'Analysis' sheet, the cell I have been trying to do this in is K5.

Please see formula by JBeaucaire in cell I5. I wasn't sure how to break it down to do this next step. Here was my original thread: http://www.excelforum.com/excel-form...ml#post4190426

Would anyone be kind enough to help me out?

I've attached my work. Thanks very much.  Register To Reply

2. ## Re: Slope of Moving Average off Indexed Lookups

Hello all. I wanted to bump this thread and add a spreadsheet that shows the SLOPE formula in K5. I want to make this a lookup similar to cell I5 so that I can eventually drag it down for all of the different stocks. Does anyone know how to do this?V3.xlsm  Register To Reply

3. ## Re: Slope of Moving Average off Indexed Lookups

On the SPY sheet, which column would represent Y and which would represent X in the formula?

=SLOPE(known_y's, known_x's)  Register To Reply

4. ## Re: Slope of Moving Average off Indexed Lookups

Y would be Column A and X would be Column E.  Register To Reply

5. ## Re: Slope of Moving Average off Indexed Lookups

Hm, ok, then the formula would be the same as before but once for each range:

=SLOPE(OFFSET(INDEX(INDIRECT("'" & \$A5 & "'!A:A"), MATCH(\$A\$1, INDIRECT("'" & \$A5 & "'!A:A"), 0)-4), , , \$I\$2, ), OFFSET(INDEX(INDIRECT("'" & \$A5 & "'!E:E"), MATCH(\$A\$1, INDIRECT("'" & \$A5 & "'!A:A"), 0)-4), , , \$I\$2, ))  Register To Reply