Manuelle Pflege von Wechselkursen?


#1

Hi,
ich habe 2 Konten in Fremdwährung (1x Rubel, 1x Lari). Während bei dem Rubel-Konto in den Auswertungen der korrekte Wechselkurs verwendet wird, nutzt er beim Lari einen Kurs von 1:1 (schön wärs g). Das dürfte daran, liegen, dass GEL nicht von der EZB angeliefert wird.
Habe ich eine Möglichkeit, den GEL-Tageskurs irgendwo manuell einzupflegen?

VG Frank


#2

Schau mal hier: Benutzerdefinierte Wechselkurse

Du musst auch nicht zwingend eine komplette Historie laden. Es reicht ein einzelner Kurs. Mit dem werden dann die Kurse umgerechnet. Allerdings würde das Deine historische Performance etwas verfälschen - sie besteht ja immer aus zwei Komponenten: Kurserfolge des Wertpapiers / Konto (Zinsen) und Wechselkursänderungen.


#3

Kennt hier jemand einen guten Kurslieferanten für Fremdwährungen? Wenn ich die Fremdwährungen über Yahoo hole werden die ziemlich seltsam behandelt: So kommt von GEL (Symbol EURGEL=X) immer nur der letzte Tageskurs und RUB (EURRUB=X) oder KZT (EURKZT=X) jeweils nur den letzten Tageskurs und dann ab Mitte Juni rückwärts Daten haben, also jeweils in der Ansicht “Historische Kurse” in den Wechselkurs-/Wertpapiereinstellungen. Die historischen Kursdaten füllen sich dann eben nur nach und nach mit dem jeweiligen letzten Tageskurs je nachdem wie oft ich das Programm auf habe. Ist irgendwie etwas unbefriedigend, wobei das vermutlich an Yahoo liegt.

Kennt hier jemand eine Alternative? Meine bisherige Alternative für Kursdaten ist Onvista, aber dort gibt es GEL und KZT leider nicht.

Edit: Ich habe jetzt mal etwas rumprobiert und mir auch mal einen Alphavantage Key geholt. Wenn ich die Abfrage nach Beispiel im Browser mache, bekomme ich wunderbar durchgängige Daten. Wenn ich das alles aber im PP versuche, habe ich sowohl über Yahoo als auch über Alphavantage immer nur dieses letzter Tageskurs und dann erst wieder ab dem 18.06.2018. Mir ist aufgefallen, dass dieses Phänomen auch auf den Screenshots in der verlinkten Hilfeseite auftritt. Eventuell ist das also doch kein Kurslieferproblem sondern ein Verarbeitungsproblem durch PP.


#4

Du meinst die Alpha Vantage Abfrage der Wechselkurse, oder? Poste die doch mal hier (ohne Deinen Key natürlich). Vielleicht mache ich da noch was falsch - ich habe das für die Wechselkurse auf Alpha Vantage gar nicht ausprobiert.

Sehr komisch. In der Tat tut es für VND (Vietnamesischer Dong) aber nicht für GEL. Muss ich mir anschauen was ich da anders machen muss. Danke für die Rückmeldung!


#5

Über https://www.alphavantage.co/query?function=FX_DAILY&from_symbol=EUR&to_symbol=KZT&apikey=… kommt folgendes Ergebnis:

{
“Meta Data”: {
“1. Information”: “Forex Daily Prices (open, high, low, close)”,
“2. From Symbol”: “EUR”,
“3. To Symbol”: “KZT”,
“4. Output Size”: “Compact”,
“5. Last Refreshed”: “2018-08-14”,
“6. Time Zone”: “GMT+8”
},
“Time Series FX (Daily)”: {
“2018-08-14”: {
“1. open”: “414.9400”,
“2. high”: “415.3000”,
“3. low”: “411.9200”,
“4. close”: “412.6200”
},
“2018-08-13”: {
“1. open”: “407.1300”,
“2. high”: “415.6900”,
“3. low”: “406.5000”,
“4. close”: “414.5100”
},
“2018-08-12”: {
“1. open”: “406.7400”,
“2. high”: “406.9000”,
“3. low”: “406.7400”,
“4. close”: “406.9000”
},
“2018-08-10”: {
“1. open”: “409.5700”,
“2. high”: “411.1300”,
“3. low”: “406.6100”,
“4. close”: “407.2700”
},
“2018-08-09”: {
“1. open”: “407.6700”,
“2. high”: “412.3000”,
“3. low”: “407.4900”,
“4. close”: “409.7300”
},
“2018-08-08”: {
“1. open”: “404.3400”,
“2. high”: “407.7000”,
“3. low”: “403.8000”,
“4. close”: “407.4600”
},
“2018-08-07”: {
“1. open”: “403.0300”,
“2. high”: “404.4300”,
“3. low”: “402.1900”,
“4. close”: “403.7200”
},
“2018-08-06”: {
“1. open”: “403.8800”,
“2. high”: “404.6000”,
“3. low”: “402.1600”,
“4. close”: “402.6500”
},
“2018-08-05”: {
“1. open”: “404.0100”,
“2. high”: “404.0100”,
“3. low”: “403.9200”,
“4. close”: “403.9600”
},
“2018-08-03”: {
“1. open”: “405.5400”,
“2. high”: “405.9100”,
“3. low”: “403.9700”,
“4. close”: “403.9700”
},
“2018-08-02”: {
“1. open”: “406.8000”,
“2. high”: “407.1500”,
“3. low”: “405.3600”,
“4. close”: “405.4200”
},
“2018-08-01”: {
“1. open”: “405.8000”,
“2. high”: “407.7600”,
“3. low”: “405.6700”,
“4. close”: “406.8000”
},
“2018-07-31”: {
“1. open”: “405.5400”,
“2. high”: “407.5900”,
“3. low”: “404.2700”,
“4. close”: “405.8300”
},
“2018-07-30”: {
“1. open”: “403.0600”,
“2. high”: “405.8300”,
“3. low”: “403.0600”,
“4. close”: “405.5700”
},
“2018-07-29”: {
“1. open”: “404.2700”,
“2. high”: “404.2900”,
“3. low”: “404.2000”,
“4. close”: “404.2600”
},
“2018-07-27”: {
“1. open”: “402.7800”,
“2. high”: “404.3700”,
“3. low”: “402.4900”,
“4. close”: “404.2800”
},
“2018-07-26”: {
“1. open”: “404.6500”,
“2. high”: “405.8000”,
“3. low”: “402.8300”,
“4. close”: “402.9200”
},
“2018-07-25”: {
“1. open”: “403.2500”,
“2. high”: “405.8100”,
“3. low”: “403.2500”,
“4. close”: “405.7900”
},
“2018-07-24”: {
“1. open”: “403.6800”,
“2. high”: “404.1300”,
“3. low”: “401.9000”,
“4. close”: “403.0900”
},
“2018-07-23”: {
“1. open”: “406.5800”,
“2. high”: “406.7100”,
“3. low”: “403.5000”,
“4. close”: “403.7400”
},
“2018-07-22”: {
“1. open”: “406.1200”,
“2. high”: “406.4200”,
“3. low”: “406.1200”,
“4. close”: “406.4200”
},
“2018-07-20”: {
“1. open”: “402.8700”,
“2. high”: “406.4800”,
“3. low”: “402.8700”,
“4. close”: “405.9700”
},
“2018-07-19”: {
“1. open”: “401.6900”,
“2. high”: “403.8500”,
“3. low”: “400.6200”,
“4. close”: “402.8800”
},
“2018-07-18”: {
“1. open”: “400.3100”,
“2. high”: “401.9900”,
“3. low”: “399.9300”,
“4. close”: “401.2800”
},
“2018-07-17”: {
“1. open”: “400.6300”,
“2. high”: “402.9600”,
“3. low”: “400.1400”,
“4. close”: “400.3300”
},
“2018-07-16”: {
“1. open”: “401.1500”,
“2. high”: “401.3100”,
“3. low”: “399.5600”,
“4. close”: “400.8500”
},
“2018-07-15”: {
“1. open”: “399.9700”,
“2. high”: “399.9800”,
“3. low”: “399.9000”,
“4. close”: “399.9800”
},
“2018-07-13”: {
“1. open”: “401.5100”,
“2. high”: “401.7000”,
“3. low”: “397.1600”,
“4. close”: “400.0900”
},
“2018-07-12”: {
“1. open”: “401.2600”,
“2. high”: “402.3300”,
“3. low”: “401.1600”,
“4. close”: “401.3900”
},
“2018-07-11”: {
“1. open”: “401.9400”,
“2. high”: “403.2800”,
“3. low”: “400.8700”,
“4. close”: “401.2800”
},
“2018-07-10”: {
“1. open”: “403.0000”,
“2. high”: “404.1300”,
“3. low”: “400.5600”,
“4. close”: “402.0100”
},
“2018-07-09”: {
“1. open”: “404.1300”,
“2. high”: “404.1300”,
“3. low”: “403.4300”,
“4. close”: “403.9300”
},
“2018-07-08”: {
“1. open”: “403.6600”,
“2. high”: “403.7100”,
“3. low”: “403.6100”,
“4. close”: “403.7100”
},
“2018-07-06”: {
“1. open”: “401.6900”,
“2. high”: “404.0900”,
“3. low”: “401.4400”,
“4. close”: “403.4300”
},
“2018-07-05”: {
“1. open”: “399.8900”,
“2. high”: “402.2800”,
“3. low”: “399.7300”,
“4. close”: “401.6400”
},
“2018-07-04”: {
“1. open”: “399.4500”,
“2. high”: “400.4000”,
“3. low”: “399.0000”,
“4. close”: “399.9100”
},
“2018-07-03”: {
“1. open”: “397.1500”,
“2. high”: “399.8600”,
“3. low”: “397.1100”,
“4. close”: “399.7400”
},
“2018-07-02”: {
“1. open”: “398.1600”,
“2. high”: “398.3700”,
“3. low”: “395.7700”,
“4. close”: “397.2600”
},
“2018-07-01”: {
“1. open”: “396.9200”,
“2. high”: “398.2100”,
“3. low”: “396.8300”,
“4. close”: “398.2100”
},
“2018-06-29”: {
“1. open”: “394.0900”,
“2. high”: “398.7500”,
“3. low”: “394.0500”,
“4. close”: “398.6100”
},
“2018-06-28”: {
“1. open”: “393.9900”,
“2. high”: “395.2100”,
“3. low”: “393.2900”,
“4. close”: “394.0200”
},
“2018-06-27”: {
“1. open”: “395.3400”,
“2. high”: “397.0000”,
“3. low”: “393.4900”,
“4. close”: “394.1400”
},
“2018-06-26”: {
“1. open”: “397.0600”,
“2. high”: “397.0900”,
“3. low”: “394.8400”,
“4. close”: “395.2700”
},
“2018-06-25”: {
“1. open”: “396.1000”,
“2. high”: “397.1300”,
“3. low”: “394.5000”,
“4. close”: “396.7700”
},
“2018-06-24”: {
“1. open”: “396.3800”,
“2. high”: “396.4100”,
“3. low”: “396.3000”,
“4. close”: “396.4100”
},
“2018-06-22”: {
“1. open”: “396.2600”,
“2. high”: “396.8700”,
“3. low”: “394.8700”,
“4. close”: “396.1100”
},
“2018-06-21”: {
“1. open”: “394.0600”,
“2. high”: “396.8900”,
“3. low”: “392.8700”,
“4. close”: “396.2600”
},
“2018-06-20”: {
“1. open”: “395.3200”,
“2. high”: “395.3600”,
“3. low”: “393.3200”,
“4. close”: “394.0700”
},
“2018-06-19”: {
“1. open”: “395.0600”,
“2. high”: “395.3200”,
“3. low”: “392.6400”,
“4. close”: “395.1500”
},
“2018-06-18”: {
“1. open”: “390.2500”,
“2. high”: “394.8100”,
“3. low”: “389.6100”,
“4. close”: “394.6900”
},
“2018-06-17”: {
“1. open”: “390.1800”,
“2. high”: “390.2200”,
“3. low”: “390.1800”,
“4. close”: “390.2200”
},
“2018-06-15”: {
“1. open”: “388.7200”,
“2. high”: “391.1800”,
“3. low”: “388.0700”,
“4. close”: “390.5600”
},
“2018-06-14”: {
“1. open”: “396.2300”,
“2. high”: “397.3200”,
“3. low”: “388.2700”,
“4. close”: “388.5000”
},
“2018-06-13”: {
“1. open”: “392.7400”,
“2. high”: “396.2200”,
“3. low”: “392.3900”,
“4. close”: “396.0000”
},
“2018-06-12”: {
“1. open”: “393.0300”,
“2. high”: “394.6800”,
“3. low”: “392.0700”,
“4. close”: “392.6400”
},
“2018-06-11”: {
“1. open”: “393.5100”,
“2. high”: “394.6200”,
“3. low”: “392.9000”,
“4. close”: “393.0700”
},
“2018-06-08”: {
“1. open”: “393.2300”,
“2. high”: “394.5600”,
“3. low”: “392.2600”,
“4. close”: “393.3300”
},
“2018-06-07”: {
“1. open”: “391.0200”,
“2. high”: “394.8000”,
“3. low”: “390.0000”,
“4. close”: “393.3100”
},
“2018-06-06”: {
“1. open”: “388.8400”,
“2. high”: “391.3800”,
“3. low”: “388.3600”,
“4. close”: “391.0100”
},
“2018-06-05”: {
“1. open”: “387.0900”,
“2. high”: “388.9400”,
“3. low”: “386.8100”,
“4. close”: “388.6500”
},
“2018-06-04”: {
“1. open”: “386.2800”,
“2. high”: “388.4100”,
“3. low”: “385.8600”,
“4. close”: “387.1300”
},
“2018-06-03”: {
“1. open”: “385.8800”,
“2. high”: “385.8800”,
“3. low”: “385.7600”,
“4. close”: “385.7600”
},
“2018-06-01”: {
“1. open”: “385.3600”,
“2. high”: “387.5400”,
“3. low”: “385.1700”,
“4. close”: “385.6800”
},
“2018-05-31”: {
“1. open”: “384.7800”,
“2. high”: “386.0000”,
“3. low”: “383.4900”,
“4. close”: “385.3800”
},
“2018-05-30”: {
“1. open”: “380.3000”,
“2. high”: “384.8400”,
“3. low”: “379.8600”,
“4. close”: “384.7900”
},
“2018-05-29”: {
“1. open”: “383.1300”,
“2. high”: “383.3100”,
“3. low”: “379.8300”,
“4. close”: “380.4900”
},
“2018-05-28”: {
“1. open”: “383.3800”,
“2. high”: “386.6400”,
“3. low”: “382.9400”,
“4. close”: “383.1100”
},
“2018-05-27”: {
“1. open”: “383.1700”,
“2. high”: “383.2700”,
“3. low”: “383.0200”,
“4. close”: “383.1900”
},
“2018-05-25”: {
“1. open”: “381.9400”,
“2. high”: “385.1400”,
“3. low”: “381.5200”,
“4. close”: “382.1400”
},
“2018-05-24”: {
“1. open”: “382.4200”,
“2. high”: “382.5200”,
“3. low”: “381.9100”,
“4. close”: “381.9100”
},
“2018-05-23”: {
“1. open”: “384.6600”,
“2. high”: “384.8500”,
“3. low”: “380.7900”,
“4. close”: “381.4100”
},
“2018-05-22”: {
“1. open”: “387.7100”,
“2. high”: “388.1300”,
“3. low”: “384.3000”,
“4. close”: “384.5100”
},
“2018-05-21”: {
“1. open”: “385.9800”,
“2. high”: “388.0400”,
“3. low”: “385.2700”,
“4. close”: “388.0000”
},
“2018-05-20”: {
“1. open”: “386.8500”,
“2. high”: “386.8500”,
“3. low”: “386.6400”,
“4. close”: “386.6400”
},
“2018-05-18”: {
“1. open”: “386.4400”,
“2. high”: “388.0600”,
“3. low”: “386.1100”,
“4. close”: “386.7700”
},
“2018-05-17”: {
“1. open”: “388.5100”,
“2. high”: “389.6600”,
“3. low”: “385.6700”,
“4. close”: “386.4300”
},
“2018-05-16”: {
“1. open”: “388.1200”,
“2. high”: “389.8700”,
“3. low”: “387.0700”,
“4. close”: “388.5800”
},
“2018-05-15”: {
“1. open”: “389.5700”,
“2. high”: “391.3600”,
“3. low”: “388.1300”,
“4. close”: “388.2300”
},
“2018-05-14”: {
“1. open”: “390.5400”,
“2. high”: “393.2400”,
“3. low”: “390.5400”,
“4. close”: “391.2600”
},
“2018-05-13”: {
“1. open”: “390.4400”,
“2. high”: “390.5400”,
“3. low”: “390.4100”,
“4. close”: “390.5400”
},
“2018-05-11”: {
“1. open”: “389.5800”,
“2. high”: “391.5400”,
“3. low”: “387.6300”,
“4. close”: “390.3000”
},
“2018-05-10”: {
“1. open”: “390.4200”,
“2. high”: “390.9400”,
“3. low”: “387.2500”,
“4. close”: “389.5500”
},
“2018-05-09”: {
“1. open”: “390.7100”,
“2. high”: “391.3600”,
“3. low”: “390.2300”,
“4. close”: “390.4300”
},
“2018-05-08”: {
“1. open”: “392.7300”,
“2. high”: “393.1000”,
“3. low”: “390.3700”,
“4. close”: “390.7900”
},
“2018-05-07”: {
“1. open”: “393.8600”,
“2. high”: “394.4800”,
“3. low”: “391.9000”,
“4. close”: “392.7300”
},
“2018-05-06”: {
“1. open”: “393.7200”,
“2. high”: “394.0200”,
“3. low”: “393.7200”,
“4. close”: “393.9100”
},
“2018-05-04”: {
“1. open”: “395.3600”,
“2. high”: “395.4000”,
“3. low”: “392.8900”,
“4. close”: “393.9400”
},
“2018-05-03”: {
“1. open”: “396.2600”,
“2. high”: “396.6600”,
“3. low”: “394.1100”,
“4. close”: “395.3100”
},
“2018-05-02”: {
“1. open”: “392.6200”,
“2. high”: “396.8400”,
“3. low”: “392.5900”,
“4. close”: “395.0200”
},
“2018-05-01”: {
“1. open”: “395.3800”,
“2. high”: “395.3800”,
“3. low”: “392.3800”,
“4. close”: “392.5100”
},
“2018-04-30”: {
“1. open”: “396.7400”,
“2. high”: “396.9700”,
“3. low”: “395.0400”,
“4. close”: “395.3400”
},
“2018-04-29”: {
“1. open”: “396.9100”,
“2. high”: “396.9700”,
“3. low”: “396.7300”,
“4. close”: “396.7500”
},
“2018-04-27”: {
“1. open”: “397.3000”,
“2. high”: “397.4500”,
“3. low”: “394.8800”,
“4. close”: “396.9000”
},
“2018-04-26”: {
“1. open”: “396.5600”,
“2. high”: “400.2500”,
“3. low”: “396.5600”,
“4. close”: “397.4100”
},
“2018-04-25”: {
“1. open”: “398.6600”,
“2. high”: “399.2100”,
“3. low”: “396.3100”,
“4. close”: “396.3100”
},
“2018-04-24”: {
“1. open”: “399.8800”,
“2. high”: “400.2400”,
“3. low”: “396.8000”,
“4. close”: “398.7500”
},
“2018-04-23”: {
“1. open”: “400.6600”,
“2. high”: “401.3600”,
“3. low”: “399.2100”,
“4. close”: “400.2200”
},
“2018-04-22”: {
“1. open”: “400.9800”,
“2. high”: “400.9800”,
“3. low”: “400.8100”,
“4. close”: “400.8200”
},
“2018-04-20”: {
“1. open”: “401.5700”,
“2. high”: “402.5300”,
“3. low”: “400.2800”,
“4. close”: “400.9900”
},
“2018-04-19”: {
“1. open”: “405.9600”,
“2. high”: “406.0900”,
“3. low”: “401.4600”,
“4. close”: “401.7100”
}
}
}

Und in PP kommt das, da scheint irgendwie der 18.06./19.06. hardcodiert zu sein und die Zahlen passen auch nicht wirklich zur obigen Abfrage:


#6

Gibt es irgendwelche neuen Erkenntnisse zu dem Problem? Der 18.06. ist jedenfalls auch weiterhin immer der zweite Tag in der Liste.


#7

Dieses Thema wurde automatisch 30 Tage nach der letzten Antwort geschlossen. Es sind keine neuen Nachrichten mehr erlaubt.