+ Reply to Thread
Results 1 to 7 of 7

Find pattern in data

  1. #1
    Registered User
    Join Date
    05-14-2010
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    14

    Find pattern in data

    Hi everyone

    I would like to find certain correlation patterns in data so i will try to explain exactly what I am lookin for.

    Suppose your data looks like this:

    Price1 Price2

    26,29 24,03
    26,39 24,47
    26,53 24,75
    26,15 25,20
    26,25 25,29
    25,86 25,20
    25,71 25,29
    25,39 25,00
    25,60 24,84
    25,42 24,56
    25,49 24,04
    25,53 23,82
    25,55 23,88
    25,71 23,54
    25,81 23,25
    25,33 23,36
    25,57 23,43
    25,93 23,74
    26,12 23,78
    26,07 24,14
    26,19 23,95
    26,16 23,95

    Now i would like to know if you can program excel to find for example when if price 2 went up when price 1 went up or the other way around. Also if price1 in first 5 days went up, did price 2 went up?

    I really hope somone can help me
    Thanks in advance

  2. #2
    Forum Contributor
    Join Date
    09-21-2009
    Location
    Belgium - Mechelen
    MS-Off Ver
    Office 365 - version 2310
    Posts
    278

    Re: Find pattern in data

    tos ,
    Welcome to the forum.
    I see there is no respons on your post. This is because your question is unclear.

    .... when if price 2 went up when price 1 went up .....

    ......Also if price1 in first 5 days went up, did price 2 went up?....
    Pls provide detailed information and if possible upload a dummy workbook with a before and after page . Give the forum as much info as possible.
    This would help others to help you.

  3. #3
    Registered User
    Join Date
    05-14-2010
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    14

    Re: Find pattern in data

    I added an excel file.

    So you can see two different prices in time. Now I would like to know when price1 went did price 2 follow or did it go down? Over a period of a week, did p1 go up and p2 followed? ...

    My normal data set is pretty large and I would like to find all data when P2 did not follow P1.

    Thanks
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-14-2010
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    14

    Re: Find pattern in data

    Anybody please?
    I hope my question is clear

    Thank you very much

  5. #5
    Registered User
    Join Date
    05-14-2010
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    14

    Re: HELP Find pattern in data

    Is this not possible in excel?

  6. #6
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Find pattern in data

    Hi tos,

    I understand your frustration, but I think the specific question is still unclear. To the best of my knowledge, it would be very difficult to create a data mining tool from scratch in excel vba. If you know what the specific comparisons your are looking for then a code or two may be written but I think what you are looking for is a blanket solution for data mining and exploration.

    Good luck with your problem.

    abousetta

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Find pattern in data

    In D10 and copy down, =CORREL(B6:B10, C6:C10) tells you how the numbers correlated over the last week.
    Entia non sunt multiplicanda sine necessitate

+ 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