Quotes CSV import with KMM

Help
1

Dear all,

I’m seeking your help for clarification on KMM 5.2.1 running on Opensuse Tumbleweed.

I have a CSV file containing quotes as follows:

isin;nom;date;cours
FR0000121014;LVMH;30/09/2025;520,5
FR0000121972;SCHNEIDER ELECTRIC;30/09/2025;237,6
FR0000121972;SCHNEIDER ELECTRIC;30/06/2022;112,9
FR0011400T5U9;AIR LIQUIDE PRIME FIDEL 2027 - FR0011400T5U9;30/09/25;176,86

To import this file using the CSV import wizard, my understanding of this import process is to run it three times : one per each different securities (i.e. one for LVMH, one for SCHNEIDER ELECTRIC and one for AIR LIQUIDE PRIME FIDEL 2027).

Am I right ?

Is there a possibility to run this import all the securities in only one import process ?

Many thanks for you attention.

René

2

Hi Rene, I would be surprised if that were the case. Are these quotes for an investment account? And where did the quotes come from? A

3

This is currently not possible. A similar feature request already exists, though.

4

Many thanks for your question. This file is issued from downloading data from a same securities portfolio from my bank account website from a monthly report.

With this download procecss, I get a lot of data, corresponding to different securities appearing once in such data. Therefore I would like to import all of them in one import command using KMM. To separately import each security quote is the as doing it by hand.

Many thanks for your attention.

René

5

IPWizard knows the capabilities of the software far better than I do. I have never used CSV import for quotes. Like most people, I download them from the Tools tab in KMM. So, I am amazed that you cannot import multiple stock quotes using CSV. Is it not possible to export them in another format? OFX, for example? Or why can’t you use the same quote sources that is built in to the software? Sorry I am not more helpful. A

6

The CSV importer can only handle transaction data for one account at a time, so I am not surprised the stock price data is restricted to one security at a time.

As for using other sources, that might work, but I can see the desire to use prices provided by you own institution. However, if those new prices are for days where there were actual transactions that include the price, they might not actually be necessary. Unfortunately, for now, it is necessary to divide the source file by security. Converting it into an OFX file is certainly possible, but likely much more difficult. (I face the same issue with importing investment account transaction data from Merrill Lynch, currently only available as csv for all accounts at once.)

7

I’d go a different route: create an external application/script (e.g. bash/perl/python/your-choice-of-language) and call it e.g. $HOME/.local/bin/extract-price-from-csv. That script simply finds your most recent data file on your local drive (in case the name contains a date) or even downloads it from an online source (your imagination is the barrier here). Then it takes that file and greps out the lines for the symbol in question. The symbol will be provided as the first argument to the script.

Once you have that, you create a new online source in the online quotes configuration, lets call it csvimport and simply configure the URL to

file:/home/user/.local/bin/extract-price-from-csv %1

Then price and date regular expressions may look something like this based on the data provided in the original post:

price: ^[^;]+;[^;]+;[^;]+;([^;]+)$
date:  ^[^;]+;[^;]+;([^;]+);[^;]+$

image
image800×744 57.6 KB

As a last step assign the new source to all the securities contained in the file as online source. Voilà.

image
image615×567 24.2 KB

Note: I wrote this without testing any of it. So you may have to tweak the instructions where necessary. But I hope you got the idea. Please feel free to update this post with your success message :slight_smile: or any adjustments you had to make it work so that others can benefit.

8

Thank you so much for your replies. I gonna work on the script you kindly provide me with.

Before your reply, my intention was to write a SQL script to update the kmmPrices table with the csv quote file as an entry, after some processing using python.

Your script will undoubtedly facilitate fixing the issue.

I’ll keep you informed.

Thank you so much.

René

9

After a number of tries, I’m close to solve my problem. I remains an issue I can’t fix. So I’m seeking your help. Please find below all the parameters:

Input csv quote file:

isin;nom;date;price
FR0000121014;LVMH;30/09/2025;520,5
FR0000121972;SCHNEIDER ELECTRIC;03/01/2026;300,67
FR0000121972;SCHNEIDER ELECTRIC;30/06/2022;112,9
FR0011400T5U9;AIR LIQUIDE PRIME FIDEL 2027 - FR0011400T5U9;30/09/25;176,86

Python script Ouput (script name: sanstitre17.py) : only one quotation

FR0000121972 300.67 2026-01-03 00:00:00

KMM parameters:

URL file:/mnt/path to directory/sanstitre17.py %1

Downloading mode: By Default

Data Format: HTML épuré

Identifiant: (^[A-Z0-9]+) [0-9]+?.[0-9]+? \d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$

Selected by : Symbole

Price: ^[A-Z0-9]+ ([0-9]+?.[0-9]+?) \d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$

Decimal separator : Legacy

Date: ^[ A-Z0-9]+ [0-9]+?.[0-9]+? (\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2})$

Date Format: %Y-%m-%d %H:%M:%S

Identifiant by default: empty

Distant source : not quoted

Security parameters:

Account name: SCHNEIDER ELECTRIC - FR0000121972

Investment type: Action

Symbole: FR0000121972

Fulle name: SCHNEIDER ELECTRIC - FR0000121972

Fraction: 1/1000

Market: EUREX

Id No: FR0000121972

Currency: EUR

Quote precision : 3

Remaining: Rounded

Entry quote: by default

On line Source : SG-Quotation

Fraction: 1,0000

Triggering on-line quote update results in the following error message:

(Debug) symbol=FR0000121972 id=E000048…

Exécution de /mnt/DC2A40D12A40AA7A/Nos_REPERTOIRES-20190904/Comptes_Bancaires/Tests/Pour_KMyMoney/Assurance-Vie-Développement/sanstitre17.py FR0000121972…

Symbole trouvé : « FR0000121972 »

Cours trouvé : « 300.67 » (300,67)

Date trouvée : « 2026-01-03 00:00:00 »

Format de date trouvé : « 2026-01-03 00:00:00 » / « »

A reçu un cours non valable pour FR0000121972, impossible de le mettre à jour.

In English: Received a non valid quote for FR0000121972, update impossible.

I don’t see what I can do anymore after a number of experiments, including changing the quotation date.

Could you, please, help me?

With many thanks.

René

10

Until the experts can weigh in here, I will just take a stab in the dark. In the past, sometimes problems with quotes were cleared up by using the date format of %u and not what you have above: %Y-%m-%d %H:%M:%S Bon courage, tu as fait de progres!

11

Looks like you need to change your script to get rid of the time information in the date. But without knowing the details of the script this is just a shoot in the dark.

12

I took a long time to respond to your message. I took a while for cleaning KMM tables to avoid redundancies among securities. After these cleaning I get the same error in imputing CSV quotes.

Please find below all the data I used to import a csv quote file:

  1. Python script

#!/usr/bin/env python3

-- coding: utf-8 --

import csv

csv_file = (
“/mnt/6f6c50db-8b4e-475b-9bea-4c7683bc7424/”
“Applications/MILLEIS/”
“MILLEIS-PEA-Positions_20260204-1770223929981-20260204.csv”
)

TARGET_ISIN = “FR0000121972”

with open(csv_file, “r”, encoding=“utf-8”, newline=“”) as f:
reader = csv.reader(f, delimiter=“;”)

for row in reader:
    if not row or row[0] != TARGET_ISIN:
        continue

    isin = row[0].strip()

    price = float(row[3])
    
# Champ 5 = DATE
    dt = row[5].split('-')
    dt1 = dt[2]+'-'+dt[1]+'-'+dt[0]
    
# SORTIE STRICTE KMyMoney
    print(f"{isin} {price:.2f} {dt1}")


2. The csv imput file is as follows: 

ISIN;Titre;Quantité;Cours;Montant;Date
FR0000121972;SCHNEIDER ELECTRIC;32.0;250.40;8012.80;2026-02-10

3. The output of the python script on this file is as follows: 

FR0000121972 250.40 10-02-2026


4. On line cotations pa rameters generated with Alkimia 8.2.1-webengine-qtnetwork are the following:

URL : file:/mnt/DC2A40D12A40AA7A/Nos_REPERTOIRES-20190904/Comptes_Bancaires/Tests/Pour_KMyMoney/Assurance-Vie-Développement/MILLEIS-PEA-Quotes-00.py %1
Mode de téléchargement : Par défaut
Format de données : HTML épuré
Identifieur : ([A-Z0-9]{12})
Sélectionné par : Symbole
Prix : ([0-9]+\.[0-9]{2})
Séparateur décimal pour les valeurs monétaires : Legacy
Date : (\d{2}-\d{2}-\d{4})
Format de date : %d-%m-%Y
Identifiant par défaut : 
Source distante : non vérifié

5. Last update
Nom                                                             Symbole            Quantité Cours      Valeur     Dernière Mise à jour
SCHNEIDER ELECTRIC - FR0000121972 FR0000121972 32,000     237,6000 7 603,20 30/09/2025

6. Here is the message issued from the update attempt:

(Debug) symbol=FR0000121972 id=E000048...
Exécution de /mnt/DC2A40D12A40AA7A/Nos_REPERTOIRES-20190904/Comptes_Bancaires/Tests/Pour_KMyMoney/Assurance-Vie-Développement/MILLEIS-PEA-Quotes-00.py FR0000121972...
Symbole trouvé : « FR0000121972 »
Cours trouvé : « 250.40 » (250,4)
Date trouvée : « 10-02-2026 »
Format de date trouvé : « 10-02-2026 » / «  »
A reçu un cours non valable pour FR0000121972, impossible de le mettre à jour.


I tried to customized differently the quote (250.40 or 250,4, as str or float), the date (%d-%m-%Y or %Y-%m-%d with the corresponding regex). I also changed the date in the csv file. 

I also unified the securities indexes in kmmAccounts, and removes the newly unused indexed from kmmSecurities. No effect of these changes on the results.

I'm missing something. Could you, please, help me. With many thanks. René
13

Changing

%d-%m-%Y

to

%d-%m-%y

results in

(Debug) symbol=FR0000121972 id=E000002...
Executing /home/thb/renepaul.py FR0000121972...
Symbol found: 'FR0000121972'
Price found: '250.40' (250,4)
Date found: '10-02-2026'
Date format found: '10-02-2026' -> 'Di. Feb. 10 2026'
Price for FR0000121972 updated to 250,4000 $ for 10.02.2026 (id E000002)
1 Like