Welcome to the Traders Laboratory Forums.
Automated Trading Black box systems, strategy automation, algorithmic trading, etc...

Reply
Old 07-28-2009, 09:25 PM   #33

Join Date: Mar 2009
Location: Chicago
Posts: 2
Ignore this user

Thanks: 1
Thanked 0 Times in 0 Posts



Re: New Open Source Project - MS Sql Server Market Data Colletor.

Is there anyone out there that has the old OpenTick API or data available? For whatever reasons they shut down, it would be great if we could pick up (parts) of where they left off.
jmayo05 is offline  
Reply With Quote
Old 07-29-2009, 04:44 AM   #34

Join Date: Nov 2007
Posts: 87
Ignore this user

Thanks: 12
Thanked 30 Times in 20 Posts



Re: New Open Source Project - MS Sql Server Market Data Colletor.

I joined OpenTick long ago. It certainly was a nice idea.

But I have to say: Their data was always messy. E.g. if you downloaded a continuous range of ES futures tick data it was always cluttered with holes - worthless for any serious analysis.

It was obviously only a testfield: They used the service to eliminate bugs (with the help of their customers) then moved to commercial.
uexkuell is offline  
Reply With Quote
Old 08-05-2009, 02:05 PM   #35

Join Date: Jan 2009
Location: London
Posts: 1
Ignore this user

Thanks: 0
Thanked 0 Times in 0 Posts



Re: New Open Source Project - MS Sql Server Market Data Colletor.

I am a c# .net developer and familiar with SQL, not so much the admin of db's but familiar with SQL scripts, creating tables, stored procedures. I would be interested in doing some work on this. I am mostly interested in getting tick data, but hourly data would be a good place to start. It would also be nice to have volume data.
magister is offline  
Reply With Quote
Old 08-12-2009, 03:13 AM   #36

Join Date: May 2009
Location: Szczecin
Posts: 32
Ignore this user

Thanks: 0
Thanked 3 Times in 3 Posts



Re: New Open Source Project - MS Sql Server Market Data Colletor.

Stupid question, but what is the sense of that?

THere are numerous APIs allowing access to hourly data rages (google financials for example). Unless one gets down to the roots and collects tick data including bid and ask it is useless for short term analysis and it is in particularly useless for trade simulation, especially during off times.

At least in Futures, data providers allowing the capture of complete exchange data (CME, CBOT) are not that expensive.
NetTecture is offline  
Reply With Quote
Old 08-12-2009, 04:26 AM   #37

BlowFish's Avatar

Join Date: Mar 2007
Location: In Da House
Posts: 3,272
Ignore this user

Thanks: 129
Thanked 1,038 Times in 694 Posts



Re: New Open Source Project - MS Sql Server Market Data Colletor.

I am inclined to agree (as I said earlier in the thread) saving each tick and each order book change would generate something unique and valuable.
BlowFish is offline  
Reply With Quote
Old 08-12-2009, 04:30 AM   #38

Join Date: May 2009
Location: Szczecin
Posts: 32
Ignore this user

Thanks: 0
Thanked 3 Times in 3 Posts



Re: New Open Source Project - MS Sql Server Market Data Colletor.

Not sure about the complete order book (though it may come in handy at times - like to see when it is particularly shallow and then to stay out of the market- happens in the YM at times before news). But at least best bid and ask are conditio sine qua non in some markets.

Try trading emini financial futures during exchange nights. The bid and ask move in perfect sync with forex quotes - obviously, enough arbitrage companeis there.

Sadly, it rarely trades. It trades SO rarely, stops are useless.... one has to program ones own stop mechanism to react on bid/ask running through ones stop price. I had (in simulator) situations where bid and ask passed through my stop about 30 ticks before someone decided to trade one contract (which triggers the stop). Perfect in sync with exchange regulations (trades trigger stops, only), but... in this case the trades only are just not the real representation of the market.
NetTecture is offline  
Reply With Quote
Old 08-12-2009, 05:07 AM   #39

BlowFish's Avatar

Join Date: Mar 2007
Location: In Da House
Posts: 3,272
Ignore this user

Thanks: 129
Thanked 1,038 Times in 694 Posts



Re: New Open Source Project - MS Sql Server Market Data Colletor.

I am not sure about order book but why not collect it at least that would make that sort of analysis possible

It does seem that price tends to move towards order book size. There is an interesting thread over at ET some years back now. I also have a strong suspicion if you look at orders filled vs. orders pulled that you might find interesting information.
BlowFish is offline  
Reply With Quote
Old 09-08-2009, 01:49 PM   #40

Join Date: May 2009
Location: Szczecin
Posts: 32
Ignore this user

Thanks: 0
Thanked 3 Times in 3 Posts



Re: New Open Source Project - MS Sql Server Market Data Colletor.

Well

My RIthmic tests are "on hold" until they fix some issue in their API - it overloads on AMD processors with the full CME feed, works fine on Intel They got an AMD server from me now for testing I Hope they sort it out soonish.

I am now working on order handling and subscribing only to specific instruments for now I hope to start full data capture next month (I really hope) Did my first trade today (on my app against CME test environment) - the whole low level API's are not exactly totally easy Now time for some front end and data storage

I hear a lot of mentioning of OpenTick (defunct as they are) Anyone thinks there is a market for not necessariyl real time historical data (especially if it includes best bid/ask or even full bid/ask)?
NetTecture is offline  
Reply With Quote

Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open ECry Data Feed Tresor Open E Cry 10 04-21-2009 12:04 AM
Open Interest Data Provider on EUREX ? paolfili Market Analysis 2 01-29-2009 04:01 AM
Finance articles source intocatonna Beginners Forum 1 08-06-2007 01:44 AM
Server Issues Resolved Soultrader Support Center 0 06-25-2007 11:03 AM
How to Project Fibonacci Time Cycles willd Trading Articles 0 02-02-2007 12:52 AM

All times are GMT -4. The time now is 04:46 PM.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
CS to VB integration by DeskLancer
©2006-2011 Traders Laboratory, All Rights Reserved.