I am using R to analyse stock data, using the quantmod
package to get all sorts of data, but here specifically FX data using the function getFX()
. This uses the Oanda database as its source.
This works great, however it returns weekend values - i.e. values for days on which no trading takes place. These values must therefore have somehow been exptrapolated, for example by taking the average over the surrounding period, using a spline...
This is the problem, I can't find out how it is done on the website nor in the quantmod documentation. I can actually just use the Quandl
package to get around this, but I would like to know what I am avoiding or potentially missing out on.
I say that I may be missing out on something here because I may myself need to deal with data imputation, filling in the weekends, so if Oanda has done something half-sensible, I could just swipe there gap-filling skills. Just to make it super clear, compare the two outputs below, first from Quandl {package: Quandl} and then from Oanda {package: quantmod}. Notice the dates and the 'filled values' **
> head(x, n=10)
Rate High (est) Low (est)
2013-01-14 0.749652 0.75838 0.74102
2013-01-15 0.748650 0.75799 0.73942
2013-01-16 0.751178 0.76022 0.74225
2013-01-17 0.751165 0.00000 0.00000
2013-01-18 0.749440 0.75843 0.74056
2013-01-21 0.750220 0.75880 0.74174
2013-01-22 0.750742 0.75993 0.74167
2013-01-23 0.750851 0.75944 0.74236
2013-01-24 0.750387 0.00000 0.00000
2013-01-25 0.747175 0.00000 0.00000
> head(y, n=10)
USD.EUR
2013-01-14 0.7480
2013-01-15 0.7490
2013-01-16 0.7524
2013-01-17 0.7504
2013-01-18 0.7489
2013-01-19 0.7508 ** Saturday
2013-01-20 0.7508 ** Sunday
2013-01-21 0.7510
2013-01-22 0.7506
2013-01-23 0.7510
--> I would have added more links to documentation etc., but I can only add two with my current rep:
www dot quandl dot com/help/r