in reply to Good use for PDL?

I would suggest staying with MySQL and use it for calculation.

You can calculate everything on the fly, like this:

select *,(`price`+`closingPrice`) / 2 AS `avgshareprice` from `tableNa
+me`

[download]

Your question doesn't give me a clue on where you're stuck at the moment or your MySQL tables structure (notice I've used fields names of the csv file you gave).

And what's the goal of this analysis ?

Replies are listed 'Best First'.
Re^2: Good use for PDL?
by morgon (Priest) on Aug 01, 2010 at 01:34 UTC
    And what's the goal of this analysis ?
    Well, he is analyzing stock purchases, keep track of who sold what and when, probably to derive some trading strategies for himself.

    All in all it's probably a safe bet that the ultimate goal is the furthering of some humanitarian cause.

[reply]

In Section Seekers of Perl Wisdom