• 100% Satisfaction Guarantee

Michael Hannigan, Office Specialist
Category: Microsoft Office
Satisfied Customers: 11120
Experience:  25+ Years Experience in Computers and Electronics. Microsoft Certified MCSE, MCDBA, MCP, Microsoft Partner
23511658
Type Your Microsoft Office Question Here...
Michael Hannigan is online now

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

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

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 2 years ago.
Test.xlsx

• File ID: 560990

• File size: 15.1 KB

• Time to live: 7 days

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

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 2 years 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.

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 2 years 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 2 years ago.

Maybe it is easier to speak through phone?

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 2 years ago.

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

Thanks
Customer: replied 2 years 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

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 2 years 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).

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 2 years 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.

Its ok, I just dont really understand what you need.

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

Ok, thx

Customer: replied 2 years ago.

Richard,

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

No sorry, as soon as an expert takes up your case, you will be notified.
Customer: replied 2 years 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 2 years 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

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 2 years ago.

Okay.

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

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
SQ10

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: 11120
Experience: 25+ Years Experience in Computers and Electronics. Microsoft Certified MCSE, MCDBA, MCP, Microsoft Partner
Customer: replied 2 years ago.

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

Good job!

Thank you very much! If you need anything else, just let me know!

Mike
Customer: replied 2 years ago.

No problem.

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.
...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
< Previous | 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

• ### jstinehelfer

#### Satisfied Customers:

36
A+ Comptia Certified computer repair
< Last | Next >

### jstinehelfer

#### Satisfied Customers:

36
A+ Comptia Certified computer repair

### JasonJames122

#### Satisfied Customers:

0
I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

### Jess M.

#### Satisfied Customers:

552
Computer Software Specialist for more than 10 years

### The-PC-Guy

#### Satisfied Customers:

496
20 years experience providing remote computer support

### James K.

#### Satisfied Customers:

260
Technical Director of IT Company

### IT Miro

#### Satisfied Customers:

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