How can I use filters to extract infos?
I encountered some complicated problems course studies.
take this for example:
under /home/data/stockdata
we have 1999,2000,2001,.......2004 these sub-dirs
and, each sub-dir has its mothly(for Jan~Dec) transaction records,
i.e. they are all named "foo.txt", like this:
Date Reported Reported Dollar Value Report
(YYYYMMDD) Shares Trades (Millions) Warrants
20041201 1,814,064,993 4,831,438 $60,504.4 143,100
20041202 1,827,212,240 4,752,578 $58,765.8 171,900
20041203 1,616,531,208 4,415,100 $52,247.2 100,000
20041206 1,382,706,054 4,037,349 $44,575.7 47,600
20041207 1,559,078,876 4,502,252 $51,147.6 56,100
20041208 1,583,381,807 4,314,708 $51,443.2 32,700
20041209 1,653,821,567 4,604,882 $53,229.1 14,900
20041210 1,492,678,438 4,085,627 $49,452.7 43,500
20041213 1,482,850,076 4,067,646 $49,550.9 50,100
20041214 1,560,225,424 4,044,484 $51,014.6 59,900
20041215 1,781,564,964 4,315,705 $58,730.0 76,500
20041216 1,828,546,117 4,501,391 $61,874.2 66,400
20041217 2,690,208,018 4,760,662 $89,080.2 113,200
20041220 1,444,379,371 4,177,083 $48,010.5 79,700
20041221 1,514,658,596 4,211,666 $50,352.0 48,700
20041222 1,432,828,621 3,988,031 $48,742.2 20,900
20041223 970,265,038 2,848,277 $33,114.8 20,400
20041227 937,874,825 3,051,715 $31,724.6 14,500
20041228 1,004,285,168 3,052,967 $33,677.0 49,800
20041229 944,707,712 2,880,070 $31,899.6 23,700
20041230 847,366,998 2,673,357 $28,208.8 51,800
20041231 823,660,146 2,546,746 $27,339.3 23,400
Q1.How can we extract infos form these huge amount for data for highest daily volume in terms of Dollar Value from Jan.1999 to Dec 2004 ?
(note: some months may change dollar values from the form provided above to absent of dollar sign , i.e. $123,456 -> 123,456)
Q2.There were consecutive trading days when the exact same number of warrants were being traded. List the years and months when this occurred.
thanks a lot for all your help.
Last edited by virii; 09-28-2005 at 12:08 AM..