Re: Re: need advice on a solution

2010-10-04 Thread Miles Fidelman
Long Wind mailto:longwind2009%40gmail.com>> wrote: I trade stocks. I put stock prices in file. Often I need compute PE for each day. To cope with stock split, I need to recompute prices as if un-split. Sometimes to compute PE, I want to use average of the last three years' earning To complete

Re: need advice on a solution

2010-10-04 Thread Ron Johnson
On 10/04/2010 04:20 PM, Long Wind wrote: I have heard that sql can do all tasks that a procedural programming language can do so That is manifestly *incorrect*, since SQL is a declarative domain-specific language. However... RDBMSs like PostgreSQL and Oracle offer procedural language extens

Re: need advice on a solution

2010-10-04 Thread Long Wind
I have heard that sql can do all tasks that a procedural programming language can do so I'll try sql -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/aanlkti=cymy0n77a

Re: need advice on a solution

2010-10-04 Thread Ron Johnson
On 10/04/2010 02:33 AM, Doug wrote: On 10/04/2010 03:15 AM, Doug wrote: On 10/04/2010 02:59 AM, Long Wind wrote: I'm rather confused. Another user Ron just say the opposite. Suppose stock prices in an array (or table or database) and annual earnings of 10 years in another array (or table or dat

Re: need advice on a solution

2010-10-04 Thread John Hasler
Ron Johnson writes: > PostrgeSQL is *the* way to go... For his purpose sqlite might be better. -- John Hasler -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/87vd5ij

Re: need advice on a solution

2010-10-04 Thread Ron Johnson
On 10/04/2010 07:08 AM, John Hasler wrote: Ron Johnson writes: PostrgeSQL is *the* way to go... For his purpose sqlite might be better. I thought about that, but it's datatypes are only notional. $ sqlite3 foo.db SQLite version 3.7.2 Enter ".help" for instructions Enter SQL statements termi

Re: need advice on a solution

2010-10-04 Thread Ron Johnson
On 10/04/2010 01:05 AM, Long Wind wrote: (sorry, this is not Linux specific) I trade stocks. I put stock prices in file. Often I need compute PE for each day. To cope with stock split, I need to recompute prices as if un-split. Sometimes to compute PE, I want to use average of the last three yea

Re: need advice on a solution

2010-10-04 Thread Doug
On 10/04/2010 03:15 AM, Doug wrote: On 10/04/2010 02:59 AM, Long Wind wrote: I'm rather confused. Another user Ron just say the opposite. Suppose stock prices in an array (or table or database) and annual earnings of 10 years in another array (or table or database) to compute PE using average

Re: need advice on a solution

2010-10-04 Thread Long Wind
Thank Ron Johnson ! I probably won't waste time on learning spreadsheet. I am new to Perl and Python. (A lot of training required!) -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://li

Re: need advice on a solution

2010-10-04 Thread Doug
On 10/04/2010 02:05 AM, Long Wind wrote: (sorry, this is not Linux specific) I trade stocks. I put stock prices in file. Often I need compute PE for each day. To cope with stock split, I need to recompute prices as if un-split. Sometimes to compute PE, I want to use average of the last three yea

need advice on a solution

2010-10-04 Thread Long Wind
(sorry, this is not Linux specific) I trade stocks. I put stock prices in file. Often I need compute PE for each day. To cope with stock split, I need to recompute prices as if un-split. Sometimes to compute PE, I want to use average of the last three years' earning To complete these tasks Solut

Re: need advice on a solution

2010-10-04 Thread Doug
On 10/04/2010 02:59 AM, Long Wind wrote: I'm rather confused. Another user Ron just say the opposite. Suppose stock prices in an array (or table or database) and annual earnings of 10 years in another array (or table or database) to compute PE using average of last 3 years is like writing a pro

Re: need advice on a solution

2010-10-04 Thread Long Wind
I'm rather confused. Another user Ron just say the opposite. Suppose stock prices in an array (or table or database) and annual earnings of 10 years in another array (or table or database) to compute PE using average of last 3 years is like writing a program Can spreadsheet really do the job?