+ Reply to Thread
Results 1 to 5 of 5

Slope of Moving Average off Indexed Lookups

  1. #1
    Registered User
    Join Date
    01-21-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    19

    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.

  2. #2
    Registered User
    Join Date
    01-21-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    19

    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

  3. #3
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    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)
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  4. #4
    Registered User
    Join Date
    01-21-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    19

    Re: Slope of Moving Average off Indexed Lookups

    Y would be Column A and X would be Column E.

  5. #5
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    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, ))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 0-indexed or 1-indexed arrays?
    By XmisterIS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2015, 09:25 PM
  2. Replies: 1
    Last Post: 10-20-2014, 03:20 PM
  3. [SOLVED] Weighted Average with Two Lookups
    By BonesE55 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-25-2014, 11:39 AM
  4. Moving data to the same row for lookups
    By smafull in forum Excel General
    Replies: 1
    Last Post: 09-16-2010, 07:22 PM
  5. Charts 5 day moving average, 10 day moving average
    By monalisa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2008, 09:50 PM
  6. Moving average of a moving average in the same cell
    By philroberts1983 in forum Excel General
    Replies: 8
    Last Post: 09-16-2008, 07:36 AM
  7. How do you perform lookups when the info is always moving?
    By Jeze77 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-31-2006, 10:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1