Is Bullchart ODBC ?

Robert Brain (Brainy)

   rb
Thanks for the feedback.  I've been using the enterprise edition of tradesim for a few years now and found it to be an excellent program.
Lately been testing pairs trading strategies, for which bullcharts+tradesim struggles with, can be done, but not very effectively.  It turns out that the ODBC module for matlab is quite expensive but I found a way around - wrote a simple bullcharts scan to extract the EOD prices for the sectors of interest, which I then read into tradesim.  From tradesim the database can be easily exported to csv format, which can then be easily read into matlab.
Similarly, the trade simulation results from matlab are easily imported into tradesim to allow montecarlo analysis etc.  So, it all worked out well in the end.
CR

Author	Message / View First Unread Post Share Topic Printable Version Delicious Digg Facebook Furl Google Boomarks Google Buzz MySpace Newsvine reddit StumbleUpon Translate Twitter Windows Live Yahoo Bookmarks Topic Search Topic Options Post Reply Create New Topic
chart rider Members Profile Send Private Message Find Members Posts Add to Buddy List Regular Joined: 25 Sep 2004 Location: Australia Posts: 96	Post Options Post Reply Quote chart rider Report Post Quote Reply Topic: Is Bullchart ODBC ? Posted: 01 Dec 2008 at 8:12pm
	rb Thanks for the feedback. I've been using the enterprise edition of tradesim for a few years now and found it to be an excellent program. Lately been testing pairs trading strategies, for which bullcharts+tradesim struggles with, can be done, but not very effectively. It turns out that the ODBC module for matlab is quite expensive but I found a way around - wrote a simple bullcharts scan to extract the EOD prices for the sectors of interest, which I then read into tradesim. From tradesim the database can be easily exported to csv format, which can then be easily read into matlab. Similarly, the trade simulation results from matlab are easily imported into tradesim to allow montecarlo analysis etc. So, it all worked out well in the end. CR

rbbrain Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List BullCharts Staff Joined: 22 Jul 2006 Location: Melbourne Posts: 169	Post Options Post Reply Quote rbbrain Report Post Quote Reply Posted: 25 Nov 2008 at 12:14pm
	Hi, Maybe this is useful info (or maybe we shouldn't be saying these things): The BC data is a Microsoft SQL database, and as such should be ODBC compliant. But you might not get much help with understanding the database structure as the BC team consider it proprietary, and they guard it closely. Re: trading strategies: Have you looked at how nicely TradeSim fits in with BullCharts? You can create the entry and exit criteria in a "TradeSim" type of BC Scan, using the standard BC scanning features. Then run the scan for a date range, and the results end up in a TradeSim "trades" database where you can run the simulation of trading activity with a whole bunch of parameters - I really like it. (It has a plug in for BC and for MetaStock - it deserves more local user support.) TradeSim is pretty cheap (<$200) - check it out here: http://www.compuvision.com.au/ and download for a trial period. It would be good to build up the usage of this great product amongst BC users, and encourage our own support community.
	Robert Brain (Brainy) Convenor - Australian BullCharts User Group Brainy's Share Market Toolbox and BullCharts Tips [/CENTER

chart rider Members Profile Send Private Message Find Members Posts Add to Buddy List Regular Joined: 25 Sep 2004 Location: Australia Posts: 96	Post Options Post Reply Quote chart rider Report Post Quote Reply Posted: 30 Oct 2008 at 1:00pm
	Hello all, I have recently started using Matlab to develop and test trading strategies, currently reading the data from Bullcharts by way of csv files. An add on module is available for Matlab to import data from any ODBC compliant database. Is anybody able to advise if Bullcharts is ODBC compliant and what does this actually mean? CR