Exchange rates

dsgee's Avatar


06 Oct, 2018 05:46 PM

I have 2 currencies used in my accounts - GBP and Euros. With Yahoo I was able to set a code to download exchange rates. I want GBP to Euros and Vice versa but have not figured out how to do it with Alphavantage. I have set it to download exchange rates but all it does is GBP to GBP and "null" Can any one give me a simple explanation?

  1. 1 Posted by sth on 06 Oct, 2018 10:16 PM

    sth's Avatar

    I think it is essentially the same as when it downloaded from Yahoo. What is the base currency of your Account Book (i.e. the main data file)

  2. 2 Posted by dsgee on 07 Oct, 2018 06:43 AM

    dsgee's Avatar

    Base currency is GBP

    Sent from my iPad

  3. 3 Posted by dsgee on 13 Oct, 2018 03:38 PM

    dsgee's Avatar

    I have still not solved this. Attached is a screenshot that shows my currencies. I do not know where the line with ":" came from but I can't get rid of it because it says it is in use. When currencies are updated the response is "null" and GBP to GBP = 1. What do I enter and where to get EUR to GBP and vice versa with Alphavantage?

    Where by accident I know not but one of my unlisted securitie that I update myself changed its currency from GBP to EURO. It will not let me change it back. It seems to when I change the tick box but does not save the changes. How do I resolve this?

  4. System closed this discussion on 12 Jan, 2019 03:40 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac