Hello all, From which source do you get live tick data fed into your excel? how do you record all the tick data ?
http://www.iqfeed.net/index.cfm?displayaction=data§ion=services http://www.netfeedtech.com/mlink.htm what do you mean by all tick data? for day? for year? generally speaking-it is up to you. in file,in database,in computer memory..
Not possible with Excel. Reason ? It's STA (single threaded architecture). Most good trading platforms employ sophisticated multi-threaded techniques to insure capturing all ticks for multiple symbols. With Excel, the best you can do: 1) shutdown all unnecessary services from running 2) Run no other applications 3) Make sure Excel is set to REALTIME priority. Then, you have a "shot", albeit a slim one.
why not? he can use build in VBA language, create bunch of arrays, store data in it, then insert either into file or database. i'm wrong?
You are correct. I was referring to collecting data in Excel in REALTIME. It's definitely doable from an existing historical data service.
what about DDE? i used to capture tick data of dja components into an excel sheet, not expecting to be milli-second optimized but it works
Yes, but writing onto an Excel worksheet is a very CPU intensive task. I once benchmarked it....I can write to the Windows registry about 5x faster than to a worksheet. What you need to do is to COUNT THE NUMBER OF DAILY TICKS and then compare that to the exchange reported figures. You'll be amazed at how much you lose.
Actually, even trying to do something with the DDE feed requires some programming. Just putting the DDE on a spreadsheet with a formula doesn't really do much. I guess you could change the background color of a cell when the price goes to a certain level.