Serving the Quantitative Finance Community

 
User avatar
player
Topic Author
Posts: 2290
Joined: August 5th, 2002, 10:00 am

excel and reuters

January 30th, 2012, 8:01 am

Im currently getting data from reuters into excel. It is a live feed and everytime there is an new trade an extra row gets printed into excel. My question is is there a way that after say 10 rows have come up the oldest row gets deleted the rest of the list is moved up/down and the latest row then gets printed....So I will always have a maximum of n ( in my example 10)rows (if that makes sense)
 
User avatar
rmax
Posts: 6080
Joined: December 8th, 2005, 9:31 am

excel and reuters

January 30th, 2012, 8:25 am

Call a sub routine on the update event so that it counts the rows and moves the data up a row if the rowcount >n