Rounding of prices in YQL/historical finance query results
Hi folks, I'm using the YQL console to retrieve historical forex prices using a query like this:
select * from yahoo.finance.historicaldata where symbol in ("EURUSD=X") and startDate = "2012-07-01" and endDate ="2012-07-16"
My problem is that the prices returned are rounded by Yahoo to 2 decimal places, which is not very useful for forex since forex quotes are usually (at least) four decimal places. For example here is a fragment of the result of that query: