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
ABOUT WILMOTT

PW by JB

Wilmott.com has been "Serving the Quantitative Finance Community" since 2001. Continued...


Twitter LinkedIn Instagram

JOBS BOARD

JOBS BOARD

Looking for a quant job, risk, algo trading,...? Browse jobs here...


GZIP: On