Excel logging: Listing data as it updates possible?

[Bomber]

Hey guys, I have just started using the BA and I am particularly interested in the excel logging function.

I have been trying to figure out how to list the data as it updates into a fresh sheet but using the Excel commands alone I have hit a wall.

I have had a read of these forums and was wondering if anyone would be so kind as to supply the VB code and explain how I would get a list going that posted the data into sheet 2 for say 1 horse?

Then I would be able to run formulas and graphs etc on that data more easily and have a better record of what had happened during the time monitored.

A million thanks for any help.

Regards, Dave

P.S. To make sure I am clear here... I am looking for the logged data from BA into Excel Sheet 1 to be then listed into sheet 2 with each update of info going into a new row. So I would have something like:

Time: Back price:
14:02:01 2.98
14:02:02 2.96
14:02:03 2.98

etc... and as the data is updated the list grows longer...

[Ian]

You can do this via the non-Api version - log individual price.