title: YQL yahoo.finance.xchange historical data
body: <p>This query is working from me</p>
  
  <pre><code>select * from yahoo.finance.xchange where pair in ("EURUSD","GBPUSD") 
  </code></pre>
  
  <p>can be seen in the following link:</p>
  
  <p><a href="https://developer.yahoo.com/yql/console/?q=show%20tables&amp;env=store://datatables.org/alltableswithkeys#h=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22EURUSD%22%2C%22GBPUSD%22)" rel="nofollow">https://developer.yahoo.com/yql/console/?q=show%20tables&amp;env=store://datatables.org/alltableswithkeys#h=select+*+from+yahoo.finance.xchange+where+pair+in+(%22EURUSD%22%2C%22GBPUSD%22)</a></p>
  
  <p>But i am looking to get the rates for a specific date, such as the following query:</p>
  
  <pre><code>select * from yahoo.finance.xchange where pair in ("EURUSD","GBPUSD") and date = "2009-09-11"
  </code></pre>
  
  <p>What is wrong with my query</p>