Hi, I am not good at excel. I would like to split buy and sell orders from the live feed and updating when new feeds come in.
LIVE FEED
BUY/SELL QTY PRICE BUY QTY PRICE SELL QTY PRICE
B 4 150
S 6 200
S 4 300 CHANGE TO
B 3 350 B 4 150
B 2 180 B 3 350 S 6 200
S 2 220 B 2 180 S 4 300
B 1 120 B 1 120 S 2 220
Hope you guys can help me.
Thanks in advance
Bookmarks