MESSAGE
| DATE | 2003-04-09 |
| FROM | Joe Villari
|
| SUBJECT | Re: [hangout] perl script
|
Ray
I emailed over a .csv version of this before I read this email. I also
placed the file, shares_merged.csv, in my home directory on the server
(wasn't sure which one was yours rayco or rayshah); /home/joe.
Joe
rc wrote:
> Joe,
> I can't thank you enough. Lunch or beers are on me next time we meet up.
> I did not recieve an attachment on this email. Is it on the server
> somewhere? That is fine if so, just tell me where.
> Thanks again!
> ~Ray
>
> On Tuesday 08 April 2003 10:17 pm, Joe Villari wrote:
>
>>Here ya go.
>>
>>It's a tab delimited file.
>>
>>You had a little over 16,000 original rows of data that changed into
>>970 unique ids.
>>
>>Don't worry about $$$, it was a good learning experience.
>>
>>Joe
>>
>>rc wrote:
>>
>>>thanks so much Joe.
>>>
>>>pls let me know what i owe you
>>>
>>>thanks again,
>>>Ray
>>>
>>> On Tuesday 08 April 2003 09:15 pm, Joe Villari wrote:
>>>
>>>>Hey Ray
>>>>
>>>>I've got it done. Just trying to get the data out of mysql into a
>>>>file for ya.
>>>>
>>>>Joe
>>>>
>>>>rc wrote:
>>>>
>>>>>Hi Joe,
>>>>>Sorry on the delayed reply. I was at the board meeting late and
>>>>>the fscc early.
>>>>>Yes you can total the number of shares.
>>>>>
>>>>>Would it be at all possible to complet this by the morning? I will
>>>>>pay you for your time and effort. I can offer you $15 an hour for
>>>>>it. Let me know what you think.
>>>>>
>>>>>I really appreciate your help with this Joe. Thanks again.
>>>>>
>>>>>~Ray
>>>>>
>>>>>On Monday 07 April 2003 06:42 pm, Joe Villari wrote:
>>>>>
>>>>>>Ray
>>>>>>
>>>>>>Some of these files show differnt share amounts for the same
>>>>>>quarter. For example:
>>>>>>
>>>>>>id 140 has 4 different values for 31-Mar-00 (I've only loaded 9
>>>>>>files at this point and checked).
>>>>>>
>>>>>>mysql> select * from ray where id like '140' and date like
>>>>>>'31-Mar-00';
>>>>>>+------+---------------------------+-----------+--------+
>>>>>>
>>>>>>| id | name | date | shares |
>>>>>>
>>>>>>+------+---------------------------+-----------+--------+
>>>>>>
>>>>>>| 140 | AIM MANAGEMENT GROUP,INC. | 31-Mar-00 | 30500 |
>>>>>>| 140 | AIM MANAGEMENT GROUP,INC. | 31-Mar-00 | 30000 |
>>>>>>| 140 | AIM MANAGEMENT GROUP,INC. | 31-Mar-00 | 104600 |
>>>>>>| 140 | AIM MANAGEMENT GROUP,INC. | 31-Mar-00 | 309000 |
>>>>>>
>>>>>>+------+---------------------------+-----------+--------+
>>>>>>
>>>>>>Is this correct? If so, in the new table do you want the toatl
>>>>>>number of shares on 31-Mar-00?
>>>>>>
>>>>>>It's going fast and smooth using mysql especially with all this
>>>>>>data.
>>>>>>
>>>>>>Joe
>>>>>>
>>>>>>rc wrote:
>>>>>>
>>>>>>>Yes Joe, that would be fine.
>>>>>>>Thanks Again.
>>>>>>>~Ray
>>>>>>>
>>>>>>>On Monday 07 April 2003 01:57 pm, Joe Villari wrote:
>>>>>>>
>>>>>>>>Ray
>>>>>>>>
>>>>>>>>Is it possible to have the original input data as a tab
>>>>>>>>delimited file? Excel supports this. The problem is there are
>>>>>>>>commas used with in the names of some funds which causes the
>>>>>>>>splitting to be a bit problematic.
>>>>>>>>
>>>>>>>>
>>>>>>>>>>>140,"AIM MANAGEMENT GROUP,INC.",30-Jun-00,7600
>>>>>>>>>>>2200,"AMERICAN FUND ADVISORS, INC.",30-Jun-00,5150
>>>>>>>>>>
>>>>>>>>Joe
>>>>>>>
>
____________________________
NYLXS: New Yorker Free Software Users Scene
Fair Use -
because it's either fair use or useless....
NYLXS is a trademark of NYLXS, Inc
|
|
