Excel 2007 : Percentage above price or below help

[Kiwi06]

Hello

I have created a DDE from my trading system what I am trying to do it analyze how long Bid stays either above or below a certan point ie the bars halfway point. what I 'm looking for is a display as a percentage. eg 75% buy 25% sell.

Example

High=0.8262
Low=0.8062
Middle = 0.8162
Bid = 0.8211

Any Help would be great

[JBeaucaire]

You should probably enter some answers and highlight them so we know exactly where you want the automation to occur and what the values you're looking for would be. Several if you can.

[Kiwi06]

Hello JBeaucaire

Yes your right some examples would not go a miss

in the sheet named Lots vs Accounts there are 2 columns buy and sell
what I'm trying to do is find out how long the bid price stays above or below the Mid Point of the daily high and low.
I am looking for the display as a percentage so if 24hr = 100% how often is the price over or under the MP. you will see my example the 55% the bid was over the MP and 45% below.

The problem is when a new day starts the MP will changes a lot and like wise if the bid sets either a new high or low for the day the MP will move. so I don't know how to solve that problem.

Cheers

Kiwi06

[JBeaucaire]

Sorry if I wasn't clear. In your example(s) you've given 55% and 45% as the answers. I am not able to ascertain HOW you got that answer. Using the 4 cells E2:H2, how did you arrive at the two answers 55% & 45%?

[Kiwi06]

solved thanks for your help

[JBeaucaire]

Care to share?