[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: sending data from TS2000i to excel?



PureBytes Links

Trading Reference Links

Hi Mike,

ME> Is it possible to send data from TS2000i to Excel?

   Use  the  FileAppend  command in Excel to write to a .csv
   file   whatever   data   you'd  like  to  capture.  (Ref:
   http://www.purebytes.com/archives/omega/2002/msg02156.html)

   Then, in Excel create a VBA routine that will reopen that
   file  ("Read  Only"  so  that  TS can keep writing to it)
   every  so  many  minutes or seconds. If you don't want to
   watch it being refreshed, open it Read Only just once.

   Then,  "do  what  you do" in Excel or even code that with
   some VBA so your 3D chart gets built automatically.

-- 
Dave Nadeau
Fort Collins, CO