[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[GT] Re: Re: Sort of off topic: update_beancounter under Windows



Robert A. Schmied wrote:
aloha jecxz112

you might want to post your original issue to dirk directly
"Dirk Eddelbuettel" <edd
AT
debian.org> and or to the beancounter (bc)
complaint
lists (methinks they might live at cpan and or debian linux sites).

but as i recall the update script altered some database tables and changed
a version variable that bc uses to tickle the 'run update_bc' message.
(version tuple in beancounter table).
since sqlite was added to bc well after the need for database table changes was known the original sqlite setup schema was already correct. but i think the variable update is still needed ... so long as you ran the script once
things should be ok.

the larger problem i found with stock bc on postgresql (a very long time ago) was when beancounter is initially setup and updated via scripts the types for volume and ave_volume (stockprices, stockinfo) are integer. this type is too small to hold large volume days for indexes like nasdaq 100 or dow 30 back in
the day when trading volumes were larger.

you might want to check that the sqlite type used for these tuples is
sufficiently large enough. for postgresql i'm using bigint. this may
have been factored into more recent versions ...


Thank you, Robert for the information.
I had tried to find a 'proper' place to report/ get feedback on this issue, but had little luck.

Fortunately I had played with Perl a bit in the past and so eventually was able to sort
out the error messages I was getting.

As I'm quite new to this whole financial bit with bc, smtm and GT, I'm just trying to get them to run so I can see what they do and what it all means to me. I'm by no means a heavy trader, but would like to look it over so I can decide whether it is something I want to consider and get at least enough knowledge 'to be dangerous' as one of my former
co-workers used to put it.


--
Fight Spam - report it with wxSR
http://www.columbinehoney.net/wxSR.shtml