Pls Help excel vba codes.
I wish to find out hourly HIGH and LOW. my data is in following columns.
Stock name in A1 to A100
I have HIGH VALUE in column "B1 to B100"
I have LOW VALUE in column "C1 to C100"
and LIVE PRICE price in column "D1 to D100"
I wish to find out hourly HIGH and LOW means at
LIVE PRICE will keep moving up / down in Column D1 to D100.
but if LIVE PRICE > HIGH VALUE then HIGH VALUE should get replace by LIVE PRICE.
but if LIVE PRICE is < LOW VALUE then LOW VALUE should get replace by LIVE PRICE.
Pls refer excel sheet attachment.
There will be 50 stock in columns "A"
9 KB Views: 22