Need Help extracting bid/ask volume at every tick from posted files.

July 24th, 2011, 10:33 AM

I have downloaded some files from the following link provided by Mike (thanks Mike)...I am not a user of NT, I use MultiCharts and DTN-IQ feed...

https://nexusfi.com/elite-circle/7279-official-gomrecorder-data-sharing-thread.html

I brought them into excel and cannot see how the volume for the bid or the ask is presented.

There seem to be 3 sets of prices and 2 columns with zeros to the far right in the txt file I am looking at.

Following the first price column, I see numbers that appear to be volume, with a column to the right with what appears to be a cumulative volume count.

Then the 3rd last column is a large number that does not seem to correspond to any other column...while the 2 columns to the left of this large number appear to be price, but the spread betweem these price prints seems much too large for the ES.

I have viewed the video Mike posted for NT users that use the NT reader, but the data is not lining up the same it seems when trying to view it in simple txt or csv format.

I am looking at ES 09-11 (a txt file) from the thread herein...

I need historical bid/ask tick data that has corresponding volume at the bid and the ask for every tick...trying to do some research.

I am new at this process, can someone help please?

Thanks in advance for your time.

Cheers,

G.

July 27th, 2011, 11:47 PM

I believe your question is what the format of QCollector output is?

That video I made shows the columns from the program itself. If it doesn't line up, then I'm afraid I can't help further as I don't use the data -- am just providing it to Elite members.

@gomi might know, as he wrote the program to convert the data to NinjaTrader.

Mike

July 28th, 2011, 04:37 AM

if the data you're looking at looks like this :

Volume Ladder for NT (Gomi)

Here's a new version of the file converter. please give it a try
Caution : You must remove first line and use semicolumn as a separator

Date,Time,Last,LastSize,TotVol,Bid,Ask,TickID,BidS ize,AskSize
05/26/2010,00:00:00,1078.00,5,105556,1078.00,1078.50,188 57644,0,0
05/26/2010,00:00:00,1078.00,1,105557,1078.00,1078.50,188 57649,0,0

You don't get bid/ask volume.
Maybe you need level2 access or something like that.

July 28th, 2011, 04:45 AM

here's the help file , does any one know how to get time to format correctly in Excel, i have tried a million ways except the one that works ? thanks

Need Help extracting bid/ask volume at every tick from posted files.

Discussion in Traders Hideout

Need Help extracting bid/ask volume at every tick from posted files.