Hi
I am using the following live feed to provide me with live bid, offer and last trading prices
Bid Offer Last
1800 1940
1837.5 1838 1838
6663.75 6665.5 6665.25
30000
400 450
25150
2030 2030
16511 16514 16510
2047 2048.5 2048
23075 23124 23115
1997.5 1998.25 1997.75
i need to use the 'Last' column values to analyse moves and see if they are moving within a 2% tolerance. However, every time it trades the column changes to the trading value so I lose the previous value to compare.
Is there a way that excel can snapshot every second the 'Last' cell into another column so I can monitor the values.
Thanks
Richard
Bookmarks