| Home | Entdecken | Lernen | Testen | Service & News | Download | |||
|
time
bin/ndreader -sWP
|
nadas reader, Copyright KARIS AG 2007, all rights reserved [V:1.0] (LINUX AMD/INTEL) code_set: ISO-8859-15
|
|
|
|
set timing on set format auto set heading on set nullprint on set colsep ' ' set space 2 set pagesize 40 set feedback on @sqlread/simple.sql
|
|
|
2008-03-01 16:51:28
|
select count(*) from wp_g_base;
|
column[1] ------------ 306516
number of record(s) selected: 1
|
|
2008-03-01 16:51:28
|
select count(*) from wp_m_base;
|
column[1] ------------ 174646
number of record(s) selected: 1
|
|
2008-03-01 16:51:28
|
select count (wkn) from wp_m_base;
|
column[1] ------------ 174646 number of record(s) selected: 1
|
|
2008-03-01 16:51:29
|
select count (distinct(wkn)) from wp_m_base;
|
column[1] ------------ 139367
number of record(s) selected: 1
|
|
2008-03-01 16:51:29
|
select gener, count(*) from wp_m_base group by gener;
|
GENER column[2] --------------------- 91 2 92 10 93 35 94 96 95 366 96 1459 97 6110 98 27203 99 139365
number of record(s) selected: 9
|
|
2008-03-01 16:51:29
|
select wkn from wp_m_base where wkn not in ( select wkn from wp_m_base where gener = '99');
|
WKN --------- 921384 974992
number of record(s) selected: 2
|
|
2008-03-01 16:51:29
|
select wkn,gener,md031 from wp_m_base where wkn ='921384' or wkn='974992';
|
WKN GENER MD031 ------------------------------------------------------------------ 921384 96 American Express Funds SICAV - Euro Liquidity 974992 97 American Express Funds SICAV - US$ Liquidity
number of record(s) selected: 2
|
|
2008-03-01 16:51:30
|
select gd240, count(*) num from wp_g_base group by gd240 having num > 299;
|
GD240 NUM ---------------- 110000 1186 150094 379 150215 348 175150 413 175289 9080 184245 1798 212000 1887 238000 3265 245011 414 268008 505 276000 1135 283000 602 285000 439 290000 455 301000 739 337000 646 346012 2119 390121 5675 396801 403 405322 1666 405670 772 452002 347 456970 318 458509 395 464374 334 464666 307 465244 320 465688 301 467538 443 500610 1133 542387 449 588820 3941 645930 396 659999 666 724230 2009 765420 3726 765818 346 800280 318 802200 761 802500 798
GD240 NUM ---------------- 803200 7376 804010 6845 804140 449 804610 5456 805890 337 807600 539 811510 5148 812500 706 850832 388 856099 5135 871001 321 876872 1982 878481 1282 879150 367 895719 817 915776 6461 968746 2086 968753 960
number of record(s) selected: 58
|
|
2008-03-01 16:51:30
|
select gd245, count(*) num from wp_g_base where gd245 is not null group by gd245 having num > 299;
|
GD245 NUM ---------------- 101288 322 150126 376 150149 512 150215 711 577665 388 581000 1759 622787 492 631708 382 801900 403 807600 411 848737 409 848757 338 848770 338 848771 747 848772 535 848774 426 853132 1128 886923 321 898137 314 901585 397 916408 443 916492 382 919694 542 925239 480 928747 371 940669 373 966604 1201
number of record(s) selected: 27
|
|
2008-03-01 16:51:31
|
select count(gd240) / count (distinct(gd240)) from wp_g_base; |
column[1] ------------ 2,94747 number of record(s) selected: 1
|
|
|
set silent on @sqlread/simple_2.sql
|
|
|
2008-03-01 16:51:31
|
select wkn,gd260 from wp_g_base where gd240 not in (select wkn from wp_m_base);
|
number of record(s) selected: 0 |
|
2008-03-01 16:51:31
|
select wkn,gd260 from wp_g_base where gd245 not in (select wkn from wp_m_base);
|
number of record(s) selected: 0
|
|
2008-03-01 16:51:32
|
select gd240, count(*) num from wp_g_base group by gd240 having num > 1;
|
number of record(s) selected: 19608
|
|
|
set silent off @sqlread/cntemi_V1.sql
|
|
|
2008-03-01 16:51:33
|
select count(*) cnt, gd240 from wp_g_base g group by gd240 having cnt > 500 order by cnt;
|
CNT GD240 ---------------- 505 268008 539 807600 602 283000 646 337000 666 659999 706 812500 739 301000 761 802200 772 405670 798 802500 817 895719 960 968753 1133 500610 1135 276000 1186 110000 1282 878481 1666 405322 1798 184245 1887 212000 1982 876872 2009 724230 2086 968746 2119 346012 3265 238000 3726 765420 3941 588820 5135 856099 5148 811510 5456 804610 5675 390121 6461 915776 6845 804010 7376 803200 9080 175289
number of record(s) selected: 34
|
|
2008-03-01 16:51:40
|
select count(*) cnt, gd240, md031 from wp_g_base g join wp_m_base m on gd240=m.wkn group by gd240,md031 having cnt > 500 order by md031;
|
CNT GD240 MD031 -------------------------------------------------------------------------------------- 1666 405322 ABN AMRO Bank N.V. 798 802500 BHF-BANK AG 1133 500610 BNP Emissions- und Handelsgesellschaft mbH 666 659999 BNP PARIBAS ARBITRAGE ISSUANCE B.V. 1133 500610 BNP Paribas Emissions- und Handelsgesellschaft mbH 706 812500 Baden-Württembergische Bank AG 1920 968753 Basis Trades [Eurex Bonds] 761 802200 Bayerische Hypo- und Vereinsbank AG 1887 212000 Bayerische Landesbank 1887 212000 Bayerische Landesbank Girozentrale 761 802200 Bayerische Vereinsbank AG 798 802500 Berliner Handels- und Frankfurter Bank 798 802500 Berliner Handels-Gesellschaft 798 802500 Berliner Handels-Gesellschaft - Frankfurter Bank 1186 110000 Bundesrepublik Deutschland 817 895719 Centro Internationale Handelsbank AG 3726 765420 Citibank AG 3726 765420 Citibank AG & Co. KGaA 3726 765420 Citigroup Global Markets Deutschland AG & Co. KGaA 14752 803200 Commerzbank AG 3265 238000 DG BANK Deutsche Genossenschaftsbank AG 3265 238000 DZ BANK AG Deutsche Zentral-Genossenschaftsbank, Frankfurt am Main 6845 804010 Deutsche Bank AG 772 405670 Deutsche Bank AG London 1798 184245 Deutsche Bank AG, London Branch 3265 238000 Deutsche Genossenschaftsbank 3265 238000 Deutsche Genossenschaftskasse 539 807600 Deutsche Hyp Deutsche Hypothekenbank Frankfurt-Hamburg AG 5456 804610 Dresdner Bank AG 539 807600 Eurohypo AG 1982 876872 Federal Home Loan Mortgage Corp. 5135 856099 Federal National Mortgage Association 7882 588820 Goldman, Sachs & Co. Wertpapier GmbH 9080 175289 Government National Mortgage Association 5148 811510 HSBC Trinkaus & Burkhardt KGaA 505 268008 Hessische Landesbank - Girozentrale - 674 805890 Hypothekenbank in Berlin AG 534 805910 Hypothekenbank in Essen AG 798 802500 ING BHF-BANK AG 1135 276000 Kreditanstalt für Wiederaufbau
CNT GD240 MD031 --------------------------------------------------------------------------------------------------- 2119 346012 Landesbank Baden-Württemberg 505 268008 Landesbank Hessen-Thüringen Girozentrale 602 283000 Landesbank Rheinland-Pfalz - Girozentrale - 602 283000 Landesbank und Girozentrale Kaiserslautern 602 283000 Landesbank und Girozentrale Rheinland-Pfalz 539 807600 Mecklenburgische Hypotheken- und Wechselbank 539 807600 Norddeutsche Hypotheken- und Wechselbank AG 539 807600 Norddeutsche Hypotheken- und Wechselbank [vormals Mecklenburgische Hypotheken- u 739 301000 Norddeutsche Landesbank Girozentrale 817 895719 Raiffeisen Centrobank AG 1282 878481 SGA Société Générale Acceptance N.V. 5675 390121 Sal. Oppenheim jr. & Cie. 5675 390121 Sal. Oppenheim jr. & Cie. KGaA 2009 724230 Société Générale Effekten GmbH 2086 968746 Strom, Futures, Indizes, Optionen [EEX] 2119 346012 Südwestdeutsche Landesbank Girozentrale 5148 811510 Trinkaus & Burkhardt KGaA 6461 915776 UBS AG [London Branch] 3726 765420 VERMÖGENSVERWALTUNG AG DER CITIBANK 646 337000 WestLB AG 646 337000 Westdeutsche Landesbank Girozentrale 706 812500 Württembergische Bank number of record(s) selected: 62
|
|
2008-03-01 16:51:41
|
select wkn,gener,md031 from wp_m_base where wkn in ( select gd240 from wp_g_base g group by gd240 having count(*) > 500 ) order by md031 ;
|
WKN GENER MD031 --------------------------------------------------------------------------------------- 405322 99 ABN AMRO Bank N.V. 802500 96 BHF-BANK AG 500610 99 BNP Emissions- und Handelsgesellschaft mbH 659999 99 BNP PARIBAS ARBITRAGE ISSUANCE B.V. 500610 98 BNP Paribas Emissions- und Handelsgesellschaft mbH 812500 98 Baden-Württembergische Bank AG 968753 98 Basis Trades [Eurex Bonds] 968753 99 Basis Trades [Eurex Bonds] 802200 98 Bayerische Hypo- und Vereinsbank AG 212000 98 Bayerische Landesbank 212000 99 Bayerische Landesbank Girozentrale 802200 99 Bayerische Vereinsbank AG 802500 97 Berliner Handels- und Frankfurter Bank 802500 99 Berliner Handels-Gesellschaft 802500 98 Berliner Handels-Gesellschaft - Frankfurter Bank 110000 99 Bundesrepublik Deutschland 895719 99 Centro Internationale Handelsbank AG 765420 98 Citibank AG 765420 97 Citibank AG & Co. KGaA 765420 96 Citigroup Global Markets Deutschland AG & Co. KGaA 803200 98 Commerzbank AG 803200 99 Commerzbank AG 238000 97 DG BANK Deutsche Genossenschaftsbank AG 238000 96 DZ BANK AG Deutsche Zentral-Genossenschaftsbank, Frankfurt am Main 804010 99 Deutsche Bank AG 405670 99 Deutsche Bank AG London 184245 99 Deutsche Bank AG, London Branch 238000 98 Deutsche Genossenschaftsbank 238000 99 Deutsche Genossenschaftskasse 807600 96 Deutsche Hyp Deutsche Hypothekenbank Frankfurt-Hamburg AG 804610 99 Dresdner Bank AG 807600 95 Eurohypo AG 876872 99 Federal Home Loan Mortgage Corp. 856099 99 Federal National Mortgage Association 588820 98 Goldman, Sachs & Co. Wertpapier GmbH 588820 99 Goldman, Sachs & Co. Wertpapier GmbH 175289 99 Government National Mortgage Association 811510 98 HSBC Trinkaus & Burkhardt KGaA 268008 99 Hessische Landesbank - Girozentrale - 802500 95 ING BHF-BANK AG
WKN GENER MD031 ----------------------------------------------------------------------------------------------------- 276000 99 Kreditanstalt für Wiederaufbau 346012 98 Landesbank Baden-Württemberg 268008 98 Landesbank Hessen-Thüringen Girozentrale 283000 97 Landesbank Rheinland-Pfalz - Girozentrale - 283000 99 Landesbank und Girozentrale Kaiserslautern 283000 98 Landesbank und Girozentrale Rheinland-Pfalz 807600 99 Mecklenburgische Hypotheken- und Wechselbank 807600 97 Norddeutsche Hypotheken- und Wechselbank AG 807600 98 Norddeutsche Hypotheken- und Wechselbank [vormals Mecklenburgische Hypotheken- u 301000 99 Norddeutsche Landesbank Girozentrale 895719 98 Raiffeisen Centrobank AG 878481 99 SGA Société Générale Acceptance N.V. 390121 99 Sal. Oppenheim jr. & Cie. 390121 98 Sal. Oppenheim jr. & Cie. KGaA 724230 99 Société Générale Effekten GmbH 968746 99 Strom, Futures, Indizes, Optionen [EEX] 346012 99 Südwestdeutsche Landesbank Girozentrale 811510 99 Trinkaus & Burkhardt KGaA 915776 99 UBS AG [London Branch] 765420 99 VERMÖGENSVERWALTUNG AG DER CITIBANK 337000 98 WestLB AG 337000 99 Westdeutsche Landesbank Girozentrale 812500 99 Württembergische Bank
number of record(s) selected: 63
|
|
|
@sqlread/cntemi_V2.sql
|
|
|
2008-03-01 16:51:47
|
select count(*) cnt, gd240,gener, md031 from wp_g_base g join wp_m_base m on gd240=m.wkn
where (m.wkn,gener) in (select wkn,min(gener) from wp_m_base group by wkn)
group by gd240,gener,md031 having cnt > 500 order by cnt; |
CNT GD240 GENER MD031 ---------------------------------------------------------------------------------------------- 505 268008 98 Landesbank Hessen-Thüringen Girozentrale 539 807600 95 Eurohypo AG 602 283000 97 Landesbank Rheinland-Pfalz - Girozentrale - 646 337000 98 WestLB AG 666 659999 99 BNP PARIBAS ARBITRAGE ISSUANCE B.V. 706 812500 98 Baden-Württembergische Bank AG 739 301000 99 Norddeutsche Landesbank Girozentrale 761 802200 98 Bayerische Hypo- und Vereinsbank AG 772 405670 99 Deutsche Bank AG London 798 802500 95 ING BHF-BANK AG 817 895719 98 Raiffeisen Centrobank AG 960 968753 98 Basis Trades [Eurex Bonds] 1133 500610 98 BNP Paribas Emissions- und Handelsgesellschaft mbH 1135 276000 99 Kreditanstalt für Wiederaufbau 1186 110000 99 Bundesrepublik Deutschland 1282 878481 99 SGA Société Générale Acceptance N.V. 1666 405322 99 ABN AMRO Bank N.V. 1798 184245 99 Deutsche Bank AG, London Branch 1887 212000 98 Bayerische Landesbank 1982 876872 99 Federal Home Loan Mortgage Corp. 2009 724230 99 Société Générale Effekten GmbH 2086 968746 99 Strom, Futures, Indizes, Optionen [EEX] 2119 346012 98 Landesbank Baden-Württemberg 3265 238000 96 DZ BANK AG Deutsche Zentral-Genossenschaftsbank, Frankfurt am Main 3726 765420 96 Citigroup Global Markets Deutschland AG & Co. KGaA 3941 588820 98 Goldman, Sachs & Co. Wertpapier GmbH 5135 856099 99 Federal National Mortgage Association 5148 811510 98 HSBC Trinkaus & Burkhardt KGaA 5456 804610 99 Dresdner Bank AG 5675 390121 98 Sal. Oppenheim jr. & Cie. KGaA 6461 915776 99 UBS AG [London Branch] 6845 804010 99 Deutsche Bank AG 7376 803200 98 Commerzbank AG 9080 175289 99 Government National Mortgage Association
number of record(s) selected: 34
|
|
|
@sqlread/groupgd245.sql
|
|
|
2008-03-01 16:51:48
|
select emi.wkn,emi.gener,md031, count(*) num from wp_g_base gat join wp_m_base emi on gd245=emi.wkn where (emi.wkn,emi.gener) in (select wkn,min(gener) from wp_m_base group by wkn) group by emi.wkn,emi.gener,md031 having num > 299 order by num; |
WKN GENER MD031 NUM ---------------------------------------------------------------------------------------- 898137 97 Crédit Agricole Funds SICAV 314 886923 98 J.P. Morgan Bank Luxembourg S.A. 321 101288 99 Eurex (Eurex Frankfurt/Eurex Zürich) 322 848770 98 COMINVEST Asset Management GmbH [Spezialfonds] 338 848757 99 Helaba Invest Kapitalanlagegesellschaft mbH 338 928747 97 Allianz Global Investors Luxembourg S.A. 371 940669 99 Capital International Fund Sicav 373 150126 99 Activest Investmentgesellschaft mbH 376 916492 98 Fortis L Fund SICAV 382 631708 99 Citigroup Asset Management 382 577665 99 Generali Asset Managers Sicav 388 901585 99 Parvest SICAV 397 801900 97 Hypo Real Estate Bank AG 403 848737 97 dresdnerbank investment management Kapitalanlagegesellschaft 409 807600 95 Eurohypo AG 411 848774 99 Universal-Investment-Gesellschaft mbH 426 916408 99 Schroder Investment Management [Luxembourg] S.A. 443 925239 97 Pioneer Investment Management S.A. 480 622787 99 Merrill Lynch International Investment Funds 492 150149 99 Union Investment Institutional GmbH 512 848772 97 Deutsche Asset Management Investmentgesellschaft mbH 535 919694 98 SGAM Fund Sicav 542 150215 99 HSH Nordbank AG 711 848771 98 Deka Investment GmbH 747 853132 99 Dow Jones & Co. Inc. 1128 966604 99 STOXX Ltd. 1201 581000 98 Deutsche Börse AG 1759
number of record(s) selected: 27
|
|
|
@sqlread/preisspanne.sql |
|
|
2008-03-01 16:51:48
|
select count(*) cnt,gd488b-gd488a diff from wp_g_base where gd488a is not null group by diff order by cnt;
|
CNT DIFF --------------- 1 13 1 1,2 1 25 1 50 1 0,5 1 NULL 2 16 2 20 2 4,5 3 12 4 1,3 4 11 5 15 5 9 6 10 7 1 8 8 10 3,5 16 7 16 1,5 16 2,5 21 6 38 2 39 5 48 4 87 3
number of record(s) selected: 26
|
|
2008-03-01 16:51:48
|
select avg(gd488b) , avg(gd488a) from wp_g_base where gd488a is not null;
|
column[1] column[2] -------------------------------------------- 30,2729651162790697 25,6782608695652173
number of record(s) selected: 1
|
|
2008-03-01 16:51:48
|
select sum(gd488a) , sum(gd488b) from wp_g_base where gd488a is not null;
|
column[1] column[2] ------------------------ 8859 10413,9
number of record(s) selected: 1
|
|
2008-03-01 16:51:48 |
select wkn,gd260, gd488a, gd488b from wp_g_base where (gd488b - gd488a ) in (select max(gd488b-gd488a) diff from wp_g_base where gd488a is not null);
|
WKN GD260 GD488A GD488B ----------------------------------------------------------------------- 581005 DEUTSCHE BOERSE NA O.N. 285,0000000 335,0000000
number of record(s) selected: 1
|
|
real 0m21.096s user 0m20.045s sys 0m1.052s |
|
|