+ Reply to Thread
Results 1 to 6 of 6

offset function that I cannot get to work properly

  1. #1
    Registered User
    Join Date
    07-04-2012
    Location
    Phoenix
    MS-Off Ver
    Excel 2003
    Posts
    3

    offset function that I cannot get to work properly

    so a litlte background on what I am doing:

    making candlestick charts that contain open(first), high, low, and close(last) price of a stock for a certain period. I have 95000 1 minute data ranges, and from these ranges I could derive any time frame I wish (If I wanted to make a 5 minute candle I would use the open from the 1 minute, the range of next four 1 minute highs/lows, and the close of the 5th minute.)

    heres a pic to better illustrate: (I am using openoffice instead of excel but its works identically)

    \1


    So, I can get it to display the wanted data in another sheet, but I cannot get it to offset the data by 5 rows every time to get what the data would be on a 5 minute chart, for all 95000 1 minute bars.

    I hope it is clear what I want to do, feel free to ask questions if you need to.

    THANKS!
    Attached Images Attached Images

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: offset function that I cannot get to work properly

    Please upload a sample worksheet with expected results
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    07-04-2012
    Location
    Phoenix
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: offset function that I cannot get to work properly

    Quote Originally Posted by Ace_XL View Post
    Please upload a sample worksheet with expected results
    Here you go, thanks for the reply
    excel example.xls

  4. #4
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: offset function that I cannot get to work properly

    Please refer attached. I took the liberty of moving the solution to Columns H to M
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-04-2012
    Location
    Phoenix
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: offset function that I cannot get to work properly

    Wow I have absolutely no idea what is going on there I don't know what to do to convert it.

  6. #6
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: offset function that I cannot get to work properly

    Does it work my friend or not? Let me know if you've run into any specific issues.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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