+ Reply to Thread
Results 1 to 1 of 1

Formula / Table pulling weekly data to compare daily data

  1. #1
    Registered User
    Join Date
    02-11-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2007
    Posts
    8

    Formula / Table pulling weekly data to compare daily data

    Part 1
    Data in column P / Q is generated once every 5 days
    Once data is generated, every past # from P & Q needs to be compared to the current Hi / Lo in column B / C. When the # is between the range, I want the # from P or Q to appear in column F.
    There will be times when multiple #ís from P / Q are within the Hi / Lo range, but I only need the most recent # to appear in column F.

    Part 2
    The day a # is generated in column F, triggers the analysis of column J / K.
    From this point forward. Each day column J needs to be compared to the current Hi / Lo in column B /C and column K needs to be compared to the current Hi / Lo in column B / C.
    When one of those #ís appears between column B / C that ends that part of the analysis. Then if current close > # from J or K = Up in column I, if current close < # from J or K = down in column I, if inside range = neutral in column I.

    Thank you for your time in getting me going in the right direction. BJW
    Attached Files Attached Files

+ 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