Altes Elliott-Wellen-Forum - @sumima: Siemens-Kursdaten

@sumima: Siemens-Kursdaten

verfasst von Uwe, 18.11.2000, 22:29

Hallo sumima!

Nachfolgend die Daten der Kurse für die Siemensaktie, nach den mir zur Verfügung stehenden Aufzeichnungen.

Siemens 1999-2000

Wenn Du in Excel das europäische Dezimalkomma benutzt, mußt die dieses beachten, da die Daten als Dezimaltrenner den Punkt enthalten und das Komma zu Trennung der einzelen Zahlen benutzt wird.

Möglichkeiten zur"Konvertierung" bei dem Einlesen der Daten in Excel über Einlesen als Text bei Komma-Trennungszeichen und anschließend unter Nutzung der Ersetze-Funktion die Wandlung der Punkte in Kommata und dann Zahlenformat wählen, sind vermutlich bekannt.

Das Datum steht als MM/TT/JJJJ
Die Spalte Time kann, wie die Spalte OI übersprungen werden.

"Date","Time","O","H","L","C","V","OI"
08/01/2000,2000,168.00,169.94,166.50,168.87,575445,0
08/02/2000,2000,169.00,169.00,162.31,165.50,1557705,0
08/03/2000,2000,164.12,164.70,154.38,157.70,3806491,0
08/04/2000,2000,160.50,162.80,157.00,157.99,2134255,0
08/07/2000,2000,159.50,164.20,158.47,163.00,1607856,0
08/08/2000,2000,163.10,168.39,163.10,167.16,1926670,0
08/09/2000,2000,166.80,170.35,165.17,168.80,1991264,0
08/10/2000,2000,169.05,171.50,166.15,167.96,1453610,0
08/11/2000,2000,167.51,168.00,162.40,163.50,1637029,0
08/14/2000,2000,164.30,165.50,162.90,165.00,1488054,0
08/15/2000,2000,167.10,167.67,164.01,165.00,1127643,0
08/16/2000,2000,165.90,167.50,164.42,165.40,1113607,0
08/17/2000,2000,165.39,166.17,164.10,165.65,749747,0
08/18/2000,2000,166.99,170.30,165.51,169.84,2865085,0
08/21/2000,2000,170.00,175.00,168.64,174.19,1574297,0
08/22/2000,2000,175.90,176.22,172.50,174.80,1304304,0
08/23/2000,2000,174.55,174.62,170.71,172.70,1448687,0
08/24/2000,2000,173.50,174.55,172.00,174.01,933444,0
08/25/2000,2000,175.10,180.40,174.00,177.25,2115290,0
08/28/2000,2000,178.79,180.36,176.70,178.15,1086826,0
08/29/2000,2000,177.80,179.40,176.20,178.70,1023603,0
08/30/2000,2000,178.00,179.38,176.31,176.50,1112589,0
08/31/2000,2000,176.57,182.25,176.57,181.50,1823732,0
09/01/2000,2000,182.00,188.79,181.60,185.40,2722373,0
09/04/2000,2000,186.90,189.80,186.37,189.20,1652379,0
09/05/2000,2000,189.50,189.74,186.10,188.00,1829906,0
09/06/2000,2000,186.01,187.49,181.66,182.31,1610442,0
09/07/2000,2000,181.20,184.84,178.40,183.80,1747828,0
09/08/2000,2000,183.90,184.40,176.20,177.36,1633344,0
09/11/2000,2000,177.50,182.30,176.32,180.52,1373851,0
09/12/2000,2000,179.74,180.95,178.01,179.18,1289822,0
09/13/2000,2000,179.99,180.25,172.35,175.30,2028011,0
09/14/2000,2000,176.50,179.99,172.30,178.50,1982974,0
09/15/2000,2000,177.10,178.80,175.35,177.66,2089959,0
09/18/2000,2000,177.10,177.99,174.01,174.80,1630639,0
09/19/2000,2000,172.80,174.00,169.80,170.80,1852391,0
09/20/2000,2000,173.25,173.40,163.10,166.04,1761490,0
09/21/2000,2000,167.30,168.85,157.00,158.80,3567281,0
09/22/2000,2000,142.80,152.69,142.00,150.99,8077760,0
09/25/2000,2000,155.00,159.70,155.00,158.35,2268958,0
09/26/2000,2000,156.60,158.45,154.50,156.40,2371068,0
09/27/2000,2000,154.50,159.28,153.00,153.02,1743048,0
09/28/2000,2000,154.90,154.90,148.27,151.20,3027586,0
09/29/2000,2000,149.70,151.50,145.20,146.00,2363770,0
10/02/2000,2000,146.00,147.85,144.65,146.99,1846134,0
10/03/2000,2000,146.40,146.40,146.40,146.40,0,0
10/04/2000,2000,145.75,147.60,137.90,139.33,4577582,0
10/05/2000,2000,141.10,147.00,140.99,146.50,3868555,0
10/06/2000,2000,145.55,149.10,141.71,143.50,2537644,0
10/09/2000,2000,144.40,145.83,139.25,141.99,2251245,0
10/10/2000,2000,142.08,148.99,142.00,144.95,2771509,0
10/11/2000,2000,141.00,141.00,135.70,140.25,4177736,0
10/12/2000,2000,141.20,145.10,137.00,138.75,2227454,0
10/13/2000,2000,137.70,148.25,137.00,148.00,2225335,0
10/16/2000,2000,153.99,154.00,142.90,144.30,3402504,0
10/17/2000,2000,142.30,143.50,135.15,136.50,4164955,0
10/18/2000,2000,135.00,136.86,125.10,130.79,5808030,0
10/19/2000,2000,133.44,139.90,132.75,139.50,3731107,0
10/20/2000,2000,142.50,146.00,139.01,143.00,3769422,0
10/23/2000,2000,142.60,144.90,139.80,144.78,2178452,0
10/24/2000,2000,146.85,147.36,145.70,146.75,636695,0
10/25/2000,2000,146.30,146.30,140.30,142.46,2924741,0
10/26/2000,2000,141.99,145.65,141.45,141.53,2036362,0
10/27/2000,2000,144.90,145.90,142.75,144.75,2187222,0
10/30/2000,2000,146.96,149.29,146.45,147.80,1220234,0
10/31/2000,2000,149.20,150.50,146.77,149.63,2090169,0
11/01/2000,2000,151.29,153.02,148.50,151.75,2155960,0
11/02/2000,2000,152.00,154.90,151.63,153.72,2323866,0
11/03/2000,2000,153.95,156.40,153.35,154.93,1888058,0
11/06/2000,2000,155.51,156.80,153.01,153.90,1788754,0
11/07/2000,2000,153.50,154.09,147.34,148.75,2688297,0
11/08/2000,2000,148.70,150.50,140.02,140.75,6821066,0
11/09/2000,2000,135.60,137.90,131.80,135.60,8246910,0
11/10/2000,2000,138.50,139.00,131.66,132.80,3860750,0
11/13/2000,2000,131.10,132.99,128.45,130.63,3399974,0
11/14/2000,2000,132.20,137.44,132.20,136.60,5053067,0
11/15/2000,2000,137.86,138.78,134.57,137.61,2874652,0
11/16/2000,2000,136.99,137.79,131.00,132.91,2814640,0
11/17/2000,2000,131.50,134.30,130.01,131.01,2407692,0

Viel Vergnügen mit den Daten
Uwe

<center>

<HR>

</center>

Thread gesperrt

gesamter Thread:

Topp, die Wette gilt - sumima, 18.11.2000, 21:31
- Re: Topp, die Wette gilt - JüKü, 18.11.2000, 21:36
  - Re: Topp, die Wette gilt / ABER... - JüKü, 18.11.2000, 21:37
    - 90? (owT) - lentas, 18.11.2000, 21:39
  - Wetten das....? mkT - Das Orakel, 18.11.2000, 22:08
    - Re: Wetten das....? mkT - JüKü, 18.11.2000, 22:14
      - Re: Wetten das....? mkT - Das Orakel, 18.11.2000, 23:52
        Re: Wetten das....? mkT - JüKü, 19.11.2000, 00:17
        Erklärung.... - Das Orakel, 19.11.2000, 02:22
    - Re: Wetten das....? Vertex / Logo - Toni, 18.11.2000, 22:39
      - Re: Wetten das....? Vertex / Logo / Toni - JüKü, 18.11.2000, 22:55
        Re: Vertex / Logo - peinlich - LOL - Toni, 18.11.2000, 23:19
        Vertex - LogoAnalysen... - Das Orakel, 19.11.2000, 02:13
      - Vertex / Logo? LOL - Mitnichten.... - Das Orakel, 18.11.2000, 22:56
        Re: Vertex / Logo? LOL - Mitnichten.... - JüKü, 18.11.2000, 23:09
        Re: Vertex / Logo? LOL - Mitnichten.... - Das Orakel, 19.11.2000, 00:32
        Re: Vertex / Logo? LOL - Mitnichten.... So, so... - Lullaby, 19.11.2000, 10:06
        Re: Und auchn das, bittschön: - Lullaby, 19.11.2000, 10:14
        An from the horses mouht: - Lullaby, 19.11.2000, 10:22
        Re: @Orakel - Jetzt hat Dich der Lullaby auch grad noch"erschlagen" (owT) - Toni, 19.11.2000, 11:19
        Re: Vertex / Logo? LOL - Mitnichten.... - Toni, 19.11.2000, 11:15
- @sumima: Siemens-Kursdaten - Uwe, 18.11.2000, 22:29
  - @Uwe, danke - Import o.k., aber.-Konvertierung kapiere ich nicht - sumima, 18.11.2000, 22:48
    - Re: @Uwe, danke - Import o.k., aber.-Konvertierung kapiere ich nicht - Uwe, 18.11.2000, 23:54
  - @Uwe - Kursdaten - Sascha, 19.11.2000, 17:35
    - OI = Open Interest = Anzahl offener (ausstehender) Kontrakte (Fut./Opt. only)owT - Tobias, 19.11.2000, 17:43
- Siemens - meine EW-Zählung lautet: - sumima, 19.11.2000, 20:04
  - Re: Siemens und andere - ASCII-Datenreihen: Kurse im Textformat - Uwe, 19.11.2000, 20:35