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.


--
To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx with a subject of "unsubscribe". Trouble? Contact listmaster@xxxxxxxxxxxxxxxx
Archive: http://lists.debian.org/4CA974D1.5010501@xxxxxxx

Relevant Pages

  • Re: analyzing stock time series data.
    ... >> My background is in functional magnetic resonance imaging time series ... > stock market model can include or account for such factors. ... influence on what the researcher is trying to determine by analyzing ... Does this mean that stock prices time series don't exhibit ...
    (comp.soft-sys.matlab)
  • Is the sub-prime meltdown bad for stock prices?
    ... Is the sub-prime meltdown bad for stock prices? ... Is the spread of the sub-prime crisis to the commercial paper market ...
    (misc.invest.stocks)
  • Re: analyzing stock time series data.
    ... My background is in functional magnetic resonance imaging time series ... stock market model can include or account for such factors. ... Routine techniques are often applied to fMRI BOLD data to reduce ... Does this mean that stock prices time series don't exhibit ...
    (comp.soft-sys.matlab)
  • Re: need advice on a solution
    ... I put stock prices in file. ... For solution 1 and 2, I have to learn spreadsheet, sql and/or jdbc ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx with a subject of "unsubscribe". ...
    (Debian-User)
  • Re: Now that blue chip stocks...
    ... Stocks are now selling are prices that more closely reflect the actual value of the companies that issued them, and the prices they should have been selling for for the past two decades. ... Last time I checked stock sold for whatever people were willing to pay for it with a hopeful expectation that their value would go up over time. ... I base it on my belief that the inflated stock prices of the last few decades were based upon nothing more than fraud, collusion between accounting companies and corporations, lax enforcement and, of course, greed. ... And, of course, the fact that the fraud and collusion in big business that gets all the media attention is representative of a small percentage of businesses, most of which operate in an honest and lawful manner. ...
    (rec.boats)