RE: Thoughts about the stock quote database

2000-12-17 Thread Phillip Shelton
> -Original Message- > Doesn't leave much to work with. > > > -Original Message- > > > Your second question: what do we do about stocks that change names > > > and/or ticker symbols? This is an issue we haven't really > > > addressed. > > > > I defintely don't know enough right

RE: Thoughts about the stock quote database

2000-12-17 Thread Phillip Shelton
Doesn't leave much to work with. > -Original Message- > > Your second question: what do we do about stocks that change names > > and/or ticker symbols? This is an issue we haven't really > > addressed. > > If we could associate some unique id with a given commodity, we could > use that

Re: Thoughts about the stock quote database

2000-12-17 Thread Rob Browning
[EMAIL PROTECTED] (Bill Gribble) writes: > Accounts have pointers to gnc_commodities, not just names. If the > problem is picking the right stock for the account, there are plenty > of UI ways to make sure you get the right one. Isn't there still a problem on file load? The file only stores th

Re: Thoughts about the stock quote database

2000-12-17 Thread Rob Browning
[EMAIL PROTECTED] (Bill Gribble) writes: > Yes, I do. Unless you have some other reason not to want to put > purchase/sell quotes in the database, I think we should stick with > the current plan, which is to have a unified database of "net" > quotes and quotes from buys/sells. I don't believe s

Re: Thoughts about the stock quote database

2000-12-17 Thread Jean-David Beyer
Bill Gribble wrote: > > On Sun, Dec 17, 2000 at 08:38:36PM -0500, Jean-David Beyer wrote: > > Do gnc_commodities have unique keys that identify them? E.g., does the > > commodity > > > > {stock, company_name McAfee Associates, ticker MCAF, other_data} > > > > have as one of its keys a unique iden

Re: Thoughts about the stock quote database

2000-12-17 Thread Bill Gribble
On Sun, Dec 17, 2000 at 08:38:36PM -0500, Jean-David Beyer wrote: > Do gnc_commodities have unique keys that identify them? E.g., does the > commodity > > {stock, company_name McAfee Associates, ticker MCAF, other_data} > > have as one of its keys a unique identifier that is the same as the > u

Re: Thoughts about the stock quote database

2000-12-17 Thread Jean-David Beyer
Bill Gribble wrote (in part): > > On Sun, Dec 17, 2000 at 05:09:55PM -0600, Rob Browning wrote: > > Jean-David Beyer <[EMAIL PROTECTED]> writes: > > > > > Whether or not you store the price database in a formal dbms or not, > > > what would you use as the primary key for the entries? > > > > [.

Re: Thoughts about the stock quote database

2000-12-17 Thread Bill Gribble
On Sun, Dec 17, 2000 at 05:09:55PM -0600, Rob Browning wrote: > Jean-David Beyer <[EMAIL PROTECTED]> writes: > > > Whether or not you store the price database in a formal dbms or not, > > what would you use as the primary key for the entries? > > [...] > > Excellent points. Thank you. In ad

Re: Thoughts about the stock quote database

2000-12-17 Thread Rob Browning
Jean-David Beyer <[EMAIL PROTECTED]> writes: > Whether or not you store the price database in a formal dbms or not, > what would you use as the primary key for the entries? [...] Excellent points. Thank you. In addition the stuff we were already worried about, this seems more than enough ju

Re: Thoughts about the stock quote database

2000-12-16 Thread Rob Browning
Dave Peticolas <[EMAIL PROTECTED]> writes: > It should be splits -- I wasn't being very specific in that email. No problem, just wanted to make sure I was thinking straight myself. -- Rob Browning <[EMAIL PROTECTED]> PGP=E80E0D04F521A094 532B97F5D64E3930 __

Re: Thoughts about the stock quote database

2000-12-16 Thread Dave Peticolas
Rob Browning writes: > Dave Peticolas <[EMAIL PROTECTED]> writes: > > > Rob Browning is going the price database, so he will be posting a > > requirements/design doc soon. > > Getting started on this now, so it's time to talk :> > > > It may be that gnucash doesn't need to use the price db to s

Re: Thoughts about the stock quote database

2000-12-16 Thread Jean-David Beyer
Rob Browning wrote (in part): > > Dave Peticolas <[EMAIL PROTECTED]> writes: > > > Rob Browning is going the price database, so he will be posting a > > requirements/design doc soon. > > Getting started on this now, so it's time to talk :> > > > It may be that gnucash doesn't need to use the p

Re: Thoughts about the stock quote database

2000-12-16 Thread Rob Browning
Dave Peticolas <[EMAIL PROTECTED]> writes: > Rob Browning is going the price database, so he will be posting a > requirements/design doc soon. Getting started on this now, so it's time to talk :> > It may be that gnucash doesn't need to use the price db to store > prices from real transactions.

Re: Thoughts about the stock quote database

2000-12-14 Thread Paul Fenwick
G'day GnuCash developers, On Tue, Dec 12, 2000 at 05:59:12PM -0800, Dave Peticolas wrote: [snippage] > We already do online quotes, but that work is 'outsourced' to the > Finance::Quote program (available on sourceforge). It is a separate > project from GnuCash. Yes, and I've been very bad bec

Re: Thoughts about the stock quote database

2000-12-13 Thread Dave Peticolas
David Merrill writes: > On Wed, Dec 13, 2000 at 06:47:04PM -0800, Dave Peticolas wrote: > > Paul Fenwick writes: > > > > > > The good news is that I'm giving up the day-job to go back to > > > consulting, which should hopefully leave me with much more time > > > for open-source development and ot

Re: Thoughts about the stock quote database

2000-12-13 Thread David Merrill
On Wed, Dec 13, 2000 at 06:47:04PM -0800, Dave Peticolas wrote: > Paul Fenwick writes: > > > > The good news is that I'm giving up the day-job to go back to > > consulting, which should hopefully leave me with much more time > > for open-source development and other things I enjoy. :) The > > r

Re: Thoughts about the stock quote database

2000-12-13 Thread Dave Peticolas
Paul Fenwick writes: > > --LZvS9be/3tNcYl/X > Content-Type: text/plain; charset=us-ascii > Content-Disposition: inline > Content-Transfer-Encoding: quoted-printable > > G'day GnuCash developers, > > On Tue, Dec 12, 2000 at 05:59:12PM -0800, Dave Peticolas wrote: > > [snippage] > > > We alread

Re: Thoughts about the stock quote database

2000-12-13 Thread Dave Peticolas
Tor-Øyvind Gundersen writes: > > What if we annotated quotes with their source? Then quotes for > > particular transactions could be excluded from analysis. > > That could work, yes. But I still fail to see why GnuCash would need > to insert its own prices into a (possibly system-wide) quote rep

Re: Thoughts about the stock quote database

2000-12-13 Thread Tor-Øyvind Gundersen
Dave Peticolas wrote: > > As far as the database itself, it may make sense to eventually > separate it from GnuCash. In the short term, we kind of need it > asap, so it will probably be a part of GnuCash. Starting out as a GnuCash component is fine with me, as long as the design allows it to be

Re: Thoughts about the stock quote database

2000-12-13 Thread Dave Peticolas
Steven Rutter writes: > > A few months back I wrote a perl/gtk program called GtkPortfolio [can be foun > on freshmeat]. It will automatically update quotes for multiple portfolios, > view news, charts and allows you to set price alerts. I released it on > freshmeat under the Artistic License bec

Re: Thoughts about the stock quote database

2000-12-12 Thread Steven Rutter
A few months back I wrote a perl/gtk program called GtkPortfolio [can be found on freshmeat]. It will automatically update quotes for multiple portfolios, view news, charts and allows you to set price alerts. I released it on freshmeat under the Artistic License because I though others might find

Re: Thoughts about the stock quote database

2000-12-12 Thread Dave Peticolas
=?iso-8859-1?Q?Tor-=D8yvind_Gundersen?= writes: > > I don't think I can stop using GnuCash after getting the taste of it. Good > work, guys :) On behalf of everyone, thanks! > I recently joined the gnucash-devel list, so I haven't even had the time to > lurk around a lot, but I've browsed thro