TrueTrade, Java/IB trading & backtesting

Discussion in 'Automated Trading' started by tyro_t, May 3, 2007.

  1. tyro_t

    tyro_t

    I looked around briefly to see if there was an easy way to create a new google group, but I didn't see anything. Sourceforge allows each project to create a forum, but I'm not thrilled about using SF.

    I think this thread is of value to the ET crowd and they're gracious enough to let us continue.
     
    #41     May 7, 2007
  2. Janhaus

    Janhaus

    Heya Tyro,

    I re-ran the create_tables.sql script, and it shows:
    --
    e_tables.sql
    Query OK, 6 rows affected (0.02 sec)

    Query OK, 1 row affected (0.00 sec)

    Database changed
    Query OK, 0 rows affected (0.00 sec)

    Query OK, 0 rows affected (0.02 sec)

    Query OK, 0 rows affected (0.00 sec)

    Query OK, 0 rows affected (0.00 sec)

    Query OK, 0 rows affected (0.01 sec)

    Query OK, 0 rows affected (0.00 sec)

    Query OK, 0 rows affected (0.02 sec)

    mysql>

    Seems ok to me. How else to check? Other than that, when I run the program, this is what it looks like:
    (unfortunately, no error file in runtime-EclipseApplication/.metadata/.log)

    P.S. I don't know about Google code groups, but it's fairly easy to create normal Google groups in general:
    http://groups.google.com/groups/create?lnk=gcf
     
    #42     May 7, 2007
  3. tyro_t

    tyro_t

    This looks just like a DB issue.

    Have you made sure that the database is named correctly? Have you created the guest user and granted it permissions (like at the top of the script)?

    Other than that, you can go into Window>Preferences in the ATS Client and configure the database preferences if you have something different.
     
    #43     May 7, 2007
  4. tyro_t

    tyro_t

    Huh, cool. I'll have to think about that.

    Does anyone else have a preference for using a Google Group over an ET thread?
     
    #44     May 7, 2007
  5. I think an ET thread would become unwieldly pretty quickly and the forums at IB are even worse.

    I don't really have a better suggestion other than a standard mailing list. Does Google code allow you to set one of those up?
     
    #45     May 7, 2007
  6. tyro_t

    tyro_t

    Okay, let's see how this works.

    I created two new Google discussion groups:

    TrueTrade General, for a general discussion and support of TrueTrade. Probably most appropriate for most users.
    http://groups.google.com/group/truetrade-gen

    TrueTrade Development, for those people that want to contribute to the code base and need to co-ordinate with the other developers.
    http://groups.google.com/group/truetrade-dev


    I see a real danger that with all of these different sources of discussion and support, there will be a lot of duplication and it will become hard to find things. Still, I'm curious to see which will survive. I'll read all sources regularly (except maybe the IB forums, ick) so it's up to the users to pick which will win out.


    Personally I like the extra control & independence that Google Groups gives us. Let's see how it works.
     
    #46     May 7, 2007
  7. thrunner

    thrunner

    I still have the same error as Janhaus which I reported earlier as a newbie error (nice to know I am not the only one having this error :) ). No solution yet, but MySQL seems to be running and the ats database and guest permission ok, as reported by this useful MySQL front end: http://www.heidisql.com/download.php.
     
    #47     May 7, 2007
  8. tyro_t

    tyro_t

    What I wouldn't give to be sitting over your shoulder right now...

    What errors do you get in the eclipse console? (Same question to Janhaus.)

    Line 136 in InstrumentView is an attempt to iterate over the instruments returned from the DB. The only way this could be null (as opposed to 0-length) is if the DB query fails for some reason, it's just a matter of figuring out what that reason is.
     
    #48     May 7, 2007
  9. Off the top of my head, perhaps some people don't have the MySQL JDBC driver.

    Also suggest they try the following:

    1) Don't use the named pipe URL so instead of:

    jdbc:mysql://localhost/ats?enable-named-pipe&socketFactory=com.mysql.jdbc.NamedPipeSocketFactory

    use

    jdbc:mysql://localhost/ats

    2) For the username and password, try using root to see if that works first.
     
    #49     May 8, 2007
  10. Ignore that bit, I see it's bundled in the com.ats.resources project
     
    #50     May 8, 2007