Professor Excel

Comments 25

  1. Rene

    Hallo Henrik

    Bei mir funktionert der Professor_Excel_Currency_Converter leider nicht. Das Pugin erscheint zwar im Menü aber er kennt die Formel =PROFEXCurrentExchangeRate(“USD”,”EUR”) nicht.
    Ich habe Windows10 und Excel 2016 Proffesinal Plus

    Viele Grüße


    • Henrik Schiffner

      Hallo Rene,

      was für eine Fehlermeldung erhältst du denn (#NAME, #VALUE etc.)? Darüber hinaus: Wann hast du das Add-In runtergeladen (vor etwa zwei Wochen habe ich eine Version mit Fehlerbehebungen hochgeladen)?

      Du kannst schon mal die folgenden Dinge probieren:

    • Was ist dein Dezimal-Trennzeichen, Punkt oder Komma? Falls es ein Punkt ist, müsstest du “;” anstatt “,” in der Formel eingeben.
    • Sicherstellen, dass die Internetverbindung funktioniert…
    • Falls das Problem weiterhin besteht, schaue doch einmal in den Sicherheitseinstellungen, ob Makros zugelassen sind. Sowohl Add-Ins als auch Makros müssen zugelassen sein (Gehe zu File –> Options –> Trust Center –> Trust Center Settings und dann auf der linken Seite jeweils Add-Ins und Makros zulassen).
    • Falls das Problem dann immer noch besteht, schaue einmal ob die Add-In-Datei zugelassen ist. Finde Sie dazu im Windows Explorer (den Speicherort kannst du unter File –> Options –> Add-Ins auslesen). Klicke dann mit Rechtsklick auf die Datei und aktiviere “Unblock” wie auf diesem Screenshot
    • Es wäre toll, wenn du mir kurz eine Rückmeldung geben könntest, ob das Add-In jetzt funktioniert.

      Vielen Dank und beste Grüße

  2. Rene

    Hallo Henrik

    Danke für den Tipp. Mit dem Semikolon funktioniert es super!
    Gibt das auch als plug in für MS Excel auf Mac. Leider nutze ich meine Excelsheet über die Dropbox auch oft mobil mit meinem Macbook. Dort läuft MS Excel 2016.
    Gibt es dafür auch etwas. Wenn nicht, dann mach eich es lieber manuell mit Tabellen sonst funktioniert die Datei ja auf dem Mac nicht.

    Viele Grüße


  3. Marie-Claude

    I love your tool! I was wondering if the date can be used as an monthly average and if so, how can that be done?

    Thanks again!!

    • Henrik Schiffner

      Dear Marie-Claude,
      What about setting up a new worksheet, having the dates from 1st of January 2017 (or whatever date you need to start with) until today in column A. Column B has the number of month, column C the year and Column D has the exchange rate with from the currency conversion tool. Then you could use the AVERAGEIFS formula for calculating the average exchange rate. Does that solve your question?
      Best regards,

  4. Confucius

    Dear Hendrik,

    I believe you developed a great tool.

    Is it possible to extend the current currency list. Secondly, is there a way to include cryptocurrencies?

    Thanks in advance. Your time is appreciated.


    • Henrik Schiffner

      Dear Confucius,
      Thanks for the feedback! Unfortunately, the current currency list is determined by the data input, which is provided by the European Central Bank. I can only add more currencies if the daily input file contains more currencies.
      Concerning cryptocurrencies: I don’t expect the ECB includes them into their exchange rate files. Which currencies are you looking for? Probably you’d also need intra-day exchange rates for them…?
      However: Do you know another source for historical exchange rates, which already provides the data in a “manageable” format (e.g. csv, xlsx)? If yes, I could take a look at it.
      Best regards,

  5. Peter

    Hi Hendrik,

    Thank you for an excellent piece of software.

    I have been using the add-in and up until recently it has been working fine, but the last few days excel is locking up and not responding after the data is updated. I have to reload the spreadsheet.

    Please advise.

    Many thanks,


    • Henrik Schiffner

      Hi Peter,
      Thanks for the message, I’ll take a look at it and update the version if necessary.
      Best regards,

  6. Stephen

    Halo Henrik,

    I’ve been using your currency converter with good success for the first couple days. After that clicking the “Update” button in Excel failed. I emailed you the error messages, one of them is Error 150, where it says the update failed. I am using Office 365.

    After the update fails, the formulas are changed to a directory link to the .xlam file. Something seems to have confused Excel in how to handle the updates. When typing a formula manually and NOT clicking the update button, the correct conversion is returned.

    I would like to either make a small donation or purchase the Excel Tools if you could please provide me some support with this issue.

    Thank you,

    • Henrik Schiffner

      Hi Stephen,
      I’ve sent instructions to you by e-mail for the particular problem. I’ve also updated the version for all other users here so that it should hopefully not happen again.
      Best regards,

  7. Ian Whitehead

    G’day Henrik from AUS,

    I have been using PROFEX successfully but, today the calculations have failed their update. The exchange rate is not updating into the cell – the current value is “0”. I cant find a solution in help. could you please advise?

    • Henrik Schiffner

      Hi Ian,
      Which formula is not working? PROFEXCurrentExchangeRate or PROFEXExchangeRate?
      Best regards,

    • Henrik Schiffner

      Hi Ian,
      I’ve updated the add-in. Now it should work. Just download it and install it again (don’t forget to close Excel before). Please let me know if you run into any other problems.
      Best regards,

  8. Colin

    Hi Henrik,

    I have just installed your utility. Thank you.

    I am having the same issue as Ian.
    PROFEXExchangeRate returns a value OK.
    PROFEXCurrentExchangeRate returns 0.

    Thanks in anticipation.


    • Henrik Schiffner

      Hi Colin,
      I’ve updated the add-in. Now it should work. Just download it and install it again (don’t forget to close Excel before). Please let me know if you run into any other problems.
      Best regards,

  9. John

    What’s the syntax for the date field? I want to get an exchange rate for April 20, 2018. Would I use:


    Something else?

    Thanks! love the tool!

  10. David

    Hi Henrik, Having some issues.
    1/ New worksheet, completely blank,, nothing entered, “Remove PROFEX” finds 3 formula cells to be replaced.
    2/ Pasting in the formula “=PROFEXCurrentExchangeRate(“USD”,”EUR”)” gives #VALUE1. “Update” does not change this.
    Excel 2010

  11. Ken Eichman

    I installed the add-ins last week and they worked great. However this week neither function is updating. I downloaded the file again today and reinstalled it, but the function is still not updating.

  12. Ken Eichman

    To be more specific, for dates of April 30, 2018 and later the function returns the same value, for dates prior to April 30 the function works fine.

  13. Ian Whitehead

    Hi again Henrick,

    same problem as before I’m afraid. Value remains “0” after selecting “Update Data”. I noticed that when i select “Update Data” a receive an xls showing currency calculations. This data enters the clipboard. I then receive a XLS message requesting me to delete the large data in the clipboard. In an effort to help you and although I am in AUS I work for a NL company. Can direct email or TeamViewer with you outside normal hours.

  14. Karl

    Hi, I’ve downloaded your tool. Checked the trust center to make sure it’s ok. When I click update a screen with currencies and rates flashes up for a few seconds then disappears leaving me with a blank workbook. I’m using office 2016. Can you help?

  15. Michael

    Hi Henk
    Id just like to inform you that the currency conversion tool is not extracting the correct currency data. The result reflected by the Excel 2016 function =PROFEXExchangeRate(“USD”,”ZAR”,TODAY()) and any other specified date does not reflect the correct corresponding value according to Yahoo Exchange or Google exchange data rates. Is it possible that the date calculation information is incorrect?

  16. Dave

    I found when using the historical date range you need to use Excel’s 5 digit date(serial) code…

    for example July 31 2019 is 43677


  17. Saif Haddad

    Hello Henrick,

    Thank you for this very useful tool, and impressive skills!

    Is there any way you can update this to include 2018 and 2019 data? Happy to make a donation!

    Thanks and best regards,

Leave a comment

%d bloggers like this: