Hello All

first time on
learning excel slowly but stuck on the below

I have a fixed amount of shares listed in a column
The prices of these shares are constantly changing throughout the trading day
On sheet 1 I need to rank the shares in the column - highest to lowest - (by price - or - %)
On sheet 2 I need to rank the shares in the column - lowest to highest - (by price - or - %)

As the RTD - prices change dynamically
I require the best performing share (by price - or - %) to be ALWAYS at the top of the list in the column
Then the columns next best performing share is required to be listed in the row below
and so on
down to the bottom row of the column - listing the worst performing stock

So as a stock/share price improves on the day - so should its ranking UP the dynamically changing list of shares in the column

VISA- VERSA

for sheet 2 lowest to highest


I would like this to all happen automatically - NO refreshing as such

If any body has an idea for a formula that would enable the above
I would be rather grateful


thanks

Scott