Daten (Kurs-/Fundamental-) von ariva.de importieren

Deutsch Kurse
11

Wenn man die Kurse von Ariva.de herunterläd kann man folgendes Python Script nutzen um die importierbar zu machen:

#!/usr/bin/env python3
import csv
import sys

from os.path import abspath, dirname, basename, join


def main(filename):
    result = []

    with open(filename, encoding='UTF-8') as f:
        reader = csv.reader(f, delimiter=';')

        next(reader)  # Skip header

        for line in reader:
            if not line:
                continue

            day = line[0]
            value = line[4]
            result.append((day, value))

    output_filename = join(dirname(abspath(filename)), 'out-' + basename(filename))

    with open(output_filename, 'w', newline='') as output:
        writer = csv.writer(output, delimiter=';')
        writer.writerow(['Datum', 'Kurs'])
        for t in result:
            writer.writerow([t[0], t[1]])

if __name__ == '__main__':
    main(sys.argv[1])

Ausführen mit python3 script.py kurs.csv. Dann mittels Rechtsklick importieren im Programm

3 Likes