need advice on a solution

[Long Wind <longwind2009@gmail.com>]

(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?

Solution 2: use mysql? Only sql commands? without a programming
language like jdbc?

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

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