Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

OANDA removed API access to download FX rates #227

Closed
wthielen opened this issue Apr 6, 2018 · 2 comments
Closed

OANDA removed API access to download FX rates #227

wthielen opened this issue Apr 6, 2018 · 2 comments

Comments

@wthielen
Copy link
Contributor

wthielen commented Apr 6, 2018

getFX is not working anymore: it returns a 404 in open.connection.

I checked out the OANDA URL it composes in getSymbols.oanda, and it seems that that URL indeed gives a 404.

The browser-accessible historical rates URL is here: https://www.oanda.com/fx-for-business/historical-rates
The CSV download option seems to be enabled only for Pro users, which requires a $75 monthly membership.

Alternative is to use the Yahoo source:

USDJPY = getSymbols("USDJPY=X", src="yahoo", auto.assign = FALSE)

works OK, but I see discrepancies in the monthly results:

         USDJPY.Close
Jan 2018      108.732
Feb 2018      107.426
Mar 2018      106.479

while I have registered them in my sheet (using the getFX function when OANDA was still working) as:

2018 | 1 | 108.958
2018 | 2 | 106.986
2018 | 3 | 106.235
@wthielen
Copy link
Contributor Author

wthielen commented Apr 6, 2018

Also would probably need to update getSymbols.yahoo to not add the Volume and Adjusted columns as they don't make sense for currency rates.

@joshuaulrich
Copy link
Owner

Closing as a duplicate of #225.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants