Hello everyone,

I am trying to crunch stock market data and need help.

Following is my sample data in the range A1:D11

Time Scrip Quote Volume
10:00 A 10 1000
10:00 B 9 1
10:00 C 20 9876
10:00 D 15 2
10:00 E 8 6543
11:00 A 11 2500
11:00 B 9 1
11:00 C 30 22222
11:00 D 12 3
11:00 E 9 15000

I need an output in sheet2 which is as follows:

Scrip High Low Swing
C 30 20 50.00
E 9 8 12.50
A 11 10 10.00

Here is how I calculate Swing:
Swing = ((Max-Min)/Min)*100

Criteria:
1. Find Swing using the above formula
2. Sort the output on Swing (Descending)
3. Do not show scrips in the output if the volume is less than 0.02%
of the MAX volume.

Can somebody help me with a macro which gives me the above output
based on the three conditions?

Thank you