MESSAGE
| DATE | 2003-04-09 |
| FROM | Joe Villari
|
| SUBJECT | Re: [hangout] perl script
|
From owner-hangout-desteny-at-mrbrklyn.com Wed Apr 9 09:33:30 2003
Received: from www2.mrbrklyn.com (localhost [127.0.0.1]) by mrbrklyn.com (8.12.3/8.11.2/SuSE Linux 8.11.1-0.5) with ESMTP id h39DXUrt006226 for ; Wed, 9 Apr 2003 09:33:30 -0400
Received: (from mdom-at-localhost) by www2.mrbrklyn.com (8.12.3/8.12.3/Submit) id h39DXUFG006225 for hangout-desteny; Wed, 9 Apr 2003 09:33:30 -0400
X-Authentication-Warning: www2.mrbrklyn.com: mdom set sender to owner-hangout-at-www2.mrbrklyn.com using -f
Received: from smtp10.atl.mindspring.net (smtp10.atl.mindspring.net [207.69.200.246]) by mrbrklyn.com (8.12.3/8.11.2/SuSE Linux 8.11.1-0.5) with ESMTP id h39DXTrt006220 for ; Wed, 9 Apr 2003 09:33:30 -0400
Received: from user-2ivea8l.dialup.mindspring.com ([165.247.41.21] helo=pipeline.com) by smtp10.atl.mindspring.net with esmtp (Exim 3.33 #1) id 193Fk3-0002Uf-00; Wed, 09 Apr 2003 09:35:55 -0400
Message-ID: <3E942174.3090207-at-pipeline.com>
Date: Wed, 09 Apr 2003 09:34:44 -0400
From: Joe Villari
User-Agent: Mozilla/5.0 (X11; U; Linux ppc; en-US; rv:0.9.9) Gecko/20020604
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: nylxsdoer-at-nyc.rr.com
CC: hangout-at-nylxs.com
Subject: Re: [hangout] perl script
References: <200304041754.20198.nylxsdoer-at-nyc.rr.com> <200304082134.21195.nylxsdoer-at-nyc.rr.com> <3E9382C8.3060102-at-pipeline.com> <200304090004.08457.nylxsdoer-at-nyc.rr.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Sender: owner-hangout-at-mrbrklyn.com
Precedence: bulk
Reply-To: Joe Villari
List: New Yorkers Linux Scene
Admin: To unsubscribe send unsubscribename-at-domian.com to hangout-request-at-www2.mrbrklyn.com
X-Evolution: 000002bb-0000
X-Keywords:
X-UID: 10932
Status: RO
Content-Length: 3393
Lines: 126
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
|
|
