Re: [GT] Re: gt-d] Trouble with backtest.pl and beancounter

["Nicholas Kuechler" <nkuechler AT gmail.com>]

Hi,

Thanks, Russ.  I should have included that information in my original post.  My beancounter is setup for use with GT and it's currently working with other scripts, such as display_signals.pl and graphic.pl.

Also, my GT subversion checkout is recent: 2008-04-26 is when I updated GT.

It appears I'm only having issues with backtest.pl and backtest_multi.pl.

Here's my beancounter testing:

$ beancounter quote ibm
Name                       INTL BUSINESS MAC
Symbol                                   IBM
Exchange                                NYSE
Date                                20080429
Time                                 12:52pm
Previous Close                        121.69
Open                                  122.04
Day low                               122.04
Day high                              123.20
Close                                 122.55
Change                                  0.86
Percent Change                        +0.71%
Bid                                      N/A
Ask                                      N/A
52-week low                            97.04
52-week high                          125.00
Volume                               2650467
Average Volume                       8675910
Dividend date                         Mar 10
Dividend / share                        1.60
Dividend yield                          1.31
Earnings_per_share                     7.666
P/E ratio                              15.87
Market Capital                        169500


And a test of GT using my beancounter DB data:

$ ./display_signal.pl --start=2008-04-01 --end=2008-04-07 S:I:RSIDown IBM
Testing signal RSIDown[70, 14] ...
RSIDown[70, 14]     [2008-04-01] = no
RSIDown[70, 14]     [2008-04-02] = no
RSIDown[70, 14]     [2008-04-03] = no
RSIDown[70, 14]     [2008-04-04] = no
RSIDown[70, 14]     [2008-04-07] = no



Thanks,
Nick

--
Nicholas Kuechler

On Tue, Apr 29, 2008 at 12:10 PM, R P Herrold <herrold AT owlriver.com> wrote:

On Tue, 29 Apr 2008, Nicholas Kuechler wrote:

DBD::mysql::st execute failed: MySQL server has gone away at ../GT/DB/
bean.pm line 161.
MySQL server has gone away at ../GT/DB/bean.pm line 161.
Long position
real    0m29.489s
user    0m28.410s
sys     0m0.090s

To me a threshold question has to be:  are the database access credentials set up properly, and can you do a simple query with the beancounter tool, like:

  $ beancounter quote ibm

getting back something like:

[herrold AT centos-5 ~]$ beancounter quote ibm
Name                       INTL BUSINESS MAC
Symbol                                   IBM
Exchange                                NYSE
Date                                20080429
 ...

Once you know the database connection works, you can drill in further.

- Russ herrold