How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Michael Hannigan Your Own Question

Michael Hannigan
Michael Hannigan, Office Specialist
Category: Microsoft Office
Satisfied Customers: 8163
Experience:  20+ Years Experience in Field. MCSE, ICCP, CNE, Greenbelt
23511658
Type Your Microsoft Office Question Here...
Michael Hannigan is online now
A new question is answered every 9 seconds

Hello.I am in a trouble since I would like to compare three

Resolved Question:

Hello. I am in a trouble since I would like to compare three variable patterns in a table. The important part is that they have to be in sequence. Example: There are numbers: 1 1 0 0 1 1 1 0 1 0 1 0 0 I have very many numbers and would like to seek out all patterns which are at least: 1 0 1 or 0 1 0 they even can be 0 1 0 1 0 1 As long as there are no two same numbers at once. I would be very grateful for help since it is very timeconsuming to find them by myself. Kind Regards Kaido

Submitted: 10 months ago.
Category: Microsoft Office
Expert:  Richard replied 10 months ago.
Thank you for your question, my name is Richard.

I can do this for you.

Can you provide me the sheet please? And I will build you the Macro for this.

- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Thank you
Customer: replied 10 months ago.
Test.xlsx



  • File ID: 560990

  • File size: 15.1 KB

  • Time to live: 7 days



Download link:

http://wikisend.com/download/560990/Test.xlsx

Open, Close and Pips columns are important. Open - Close = Pips
I need to search the Pips column for patterns that are in a sequence.

The first 5 pips results are:

-0.0011
+0.0008

-0.0003

+0.0008

-0.0006

in other words it is

-

+

-

+

-

It would be great if that macro can find here patterns like:

-+

-+-

-+-+

-+-+-

etc..

For me the only important thing here is to find all patterns where there are no positive or negative values in sequence. Like ++ or --, and I need all possible other patterns. -+-+-+ means that it contains a pattern of -+, also -+-, also -+-+ etc. If that macro can calculate all these possible patterns and give me the numeric values for them, I would very much appreciate that and have no problem to buy this service from you.

Info: The numeric values in pips column are not important, important is only whether the value is negative or positive.

Kind Regards,
Kaido







Expert:  Richard replied 10 months ago.
Ok, this is different to your intial request.

Before you wanted the patterns

1 0 1 or 0 1 0

Now, you want to have a total of the pips that are just + numbers or just - numbers?

Customer: replied 10 months ago.

My english is not very good, sorry.

I would like to see the pips column that has different patterns and which has not two same values in sequence.

Expert:  Richard replied 10 months ago.
Its ok, I just need to correctly understand

So for

-0.0011
0.0008
-0.0003
0.0008
-0.0006
-0.0008
-0.0005
-0.0007
-0.0011

The first 4 values you want highlighted, then ignore the rest as these are - in sequence?
Customer: replied 10 months ago.

I am looking these numbers only as positive "+" or negative "-" ones. The numerical values of these are not important. I am only looking for the patterns which this column creates. If there are two ------ or ++++++++ patterns, then these are not important. Only patterns which are like "+-+", "+-", "-+", "+-+-", "-+-+", etc. So that every next value is opposite of previous.

Customer: replied 10 months ago.

Maybe it is easier to speak through phone?

Expert:  Richard replied 10 months ago.
ok, and how are these patterns meant to me shown?

We cannot do phone sorry.

Can you not show example in the file and upload?

Customer: replied 10 months ago.

Ok, Ill try to put that in the file and then i will upload, sec

Expert:  Richard replied 10 months ago.
Thanks
Customer: replied 10 months ago.

Ok it should be here. I am here if you have any questions.


Test.xlsx



  • File ID: 476252

  • File size: 17 KB

  • Time to live: 7 days



Download link:

http://wikisend.com/download/476252/Test.xlsx


Expert:  Richard replied 10 months ago.
ok, I believe I understand, bubt then you add columns with

1,2,3,4,5,6 opposites.

Do you not just want the total opposite next to the value?

Why did you add these extra columns now?
Customer: replied 10 months ago.

I was not sure where to represent the opposite total values. Only total opposite is not showing the full information unfortunately, because I need to make several other analyzis later and then I need all possible opposites even if there is a bigger pattern, then it is needed to see the smaller opposite patterns inside the bigger one (all opposites should be seen and counted).

Expert:  Richard replied 10 months ago.
Im sorry, I just dont understand exactly what you want done.

I believed it to be

"Seek out all patterns which are at least: 1 0 1 or 0 1 0 they even can be 0 1 0 1 0 1 As long as there are no two same numbers at once."

Then it switched to totals of + / - per number.

Now we have these additional columns. I just cannot see what it is exactly that you want done.

I will opt out for another expert that may better understand your requirement.
Customer: replied 10 months ago.

Sorry for my english.

I would like to see counted all patterns in Pips column which are opposite to previous direction ( if right now is positive and previous was negative then this is what i am looking for). And it would be great if excel can count these patterns and give a result somewhere on the table.

If there is a pattern like +- then they are opposite to each other and these should be counted. If there is +-+- then these are also opposite ones and should be counted. But this +-+- also contains +- and +-+ and -+- patterns etc.

Sorry for my english Ill try my best.

Expert:  Richard replied 10 months ago.
Its ok, I just dont really understand what you need.

So another expert who may, should be with you soon
Customer: replied 10 months ago.

Ok, thx

Expert:  Richard replied 10 months ago.
Your welcome
Customer: replied 10 months ago.

Richard,

Do you know approximately when somebody can look this situation through? Maybe via phone I can explain better what is needed.

Expert:  Richard replied 10 months ago.
No sorry, as soon as an expert takes up your case, you will be notified.
Customer: replied 10 months ago.

Okay.

In the meanwhile I try to explain again, maybe this time I can explain better:


 


I need a formula or a macro only for the PIPS column which analyzes all opposite data patterns which are together or in a sequence. Important are the cell counts and how many times the cells change their directions.

The reason why I need to calculate the patterns is to use the Martingale System in Day trading. And I need to know how many times I have to invest on one direction until the next direction comes. So I need to calculate the probability from the Pips area and that is the reason why I need to know how often the patterns are different from each other and how long those patterns might expand. For example if I trade on one direction, then for me it is good if the numbers are positive or negative as long as possible. For me it is bad when one cell is positive and next cell is negative. That is the reason why I need excel to find out all the patterns where the direction changes. That way I can enhance my strategy in trading.

Maybe now the information is a little bit more clearer. :)

Customer: replied 10 months ago.

Hey Richard.

I just wanted to know when I might expect this problem to be solved?
The reason why I chose the most expensive solution here was to get the answer during today. Should I start looking from other places or is it possible to get the answer today?

I am sorry for this question but in trading every hour is very impotant.

Looking for a feedback,
Cheers,
Kaido

Expert:  Richard replied 10 months ago.
I also trade, so know the time constraints.

I cannot answer though, how long, as this depends on someone understanding your problem.

But it will be as soon as possible.

Customer: replied 10 months ago.

Okay.

Hopefully somebody can help, since this should not be that hard.

Expert:  Michael Hannigan replied 10 months ago.
Hello. My name is Michael. I can provide you with additional assistance.

I looked at your workbook and I was able to add a column that shows a 1 if the direction reverses (either +- or -+) an then it sums them at the bottom of the column. I've done this in the first column of your example.

Let me know if this is what you are looking for.

Mike
Revised Spreadsheet
SQ10
Expert:  replied 10 months ago.

Was that what you were looking for? Please let me know and also please remember to rate my level of service so I will be compensated for my time. Thank you.

 

Mike

Michael Hannigan, Office Specialist
Category: Microsoft Office
Satisfied Customers: 8163
Experience: 20+ Years Experience in Field. MCSE, ICCP, CNE, Greenbelt
Michael Hannigan and 4 other Microsoft Office Specialists are ready to help you
Customer: replied 10 months ago.

Yes this is exactly what I was looking for. From here I can make further developments.

Good job!

Expert:  Michael Hannigan replied 10 months ago.
Thank you very much! If you need anything else, just let me know!

Mike
Customer: replied 10 months ago.

No problem.

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 

Related Microsoft Office Questions