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

Re: need advice on a solution

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 years' earning

To complete these tasks

Solution 1: is it possible to use spreadsheet? OpenOffice or other?

Probably not, since the task is too complicated.

Solution 2: use mysql?

Not that evil pseudo-RDBMS, which wouldn't know data and relational integrity from cr@p.

PostrgeSQL is *the* way to go, though it will take a bit more up-front effort to learn what to do.

                       Only sql commands?

Certainly not plain INSERT, UPDATE, DELETE and SELECT statements, but PostgreSQL has the powerful PL/pgSQL.

                                           without a programming
language like jdbc?

jdbc is an API not a language.

Solution 3: programming in java. I find it clumsy.

Why limit yourself to Java? Perl and Python are up to the task, as are C++ and FreePascal. (Yes, I'm pointedly ignoring C.)

I am familiar with java, no training is required for solution 3
For solution 1 and 2, I have to learn spreadsheet, sql and/or jdbc

SQL itself isn't difficult to learn. What you need is a clear head (to see the whole problem) and to learn some data modeling skills.

Actually, DM skills will help you with non-database programming, since what you get out of it are planning and design.

Seek truth from facts.

Reply to: