Results 1 to 4 of 4

Thread: Help with VBA Loops with multiple criterias

  1. #1

    Help with VBA Loops with multiple criterias



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I'm relatively new to VBA and would love the community's help

    For the rows that have a "Yes" highlighted, I'd need to run a loop and scan the closing prices from the date and time of the "Yes" row beginning 6:30 AM if it's the Minimum for the "Oversold" columns and if it's the maximum for the "Overbought" columns.
    An example would be on cell P8. The code will check if the closing price 98 is the lowest or highest on the 15/7/2015 from 6:30am to 3:10pm, the code will check from cell F9 - F16 if 98 is the minimum(for the oversold column) or maximum value(for the overbought column). If true, the code will return a "Yes" value , if false , the code will return a "No" value. Thanks so much
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Indicator.jpg 
Views:	23 
Size:	109.6 KB 
ID:	5375  

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    792
    Articles
    0
    Excel Version
    Excel 2010
    And we'd like your help, would you mind typing that into a spreadsheet for us, thanks so much.

  3. #3
    Quote Originally Posted by NoS View Post
    And we'd like your help, would you mind typing that into a spreadsheet for us, thanks so much.
    Hey I'm sorry about that, I've created a spreadsheet, thanks for the response and help.

    Curve sample.xlsm

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,709
    Articles
    0
    Excel Version
    365
    cross posted without links:
    http://stackoverflow.com/questions/3...ith-a-criteria
    AshRhazaly, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

Tags for this Thread

Posting Permissions

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