Hello Eveyone,

It is great to be a part of this forum.

I needed some assistance guys. I have an excel sheet where live stock market data stream in. That data gets updates every x seconds.

I wanted to save those ticks which (gets updates) into a text file.

For example: the data would look like -

CompanyX, 100,101,102,103,9999
CompanyY, 200,201,202,203,8999
....

So this ticks which gets updates every 2 or so seconds needs to be saved. Either I write a macro which would do the same or Is there any free ready made small application/macro which would append those data into a text file at regular intervals.

Help will be appreciated.

Thank you,

Cheers,
Jack