title: Yahoo YQL finance API - prices without tickers
body: <p>I'm having a play with the YQL Yahoo finance API and have managed to get json quotes in php.
  One thing I've noticed is that not everything has a yahoo ticker, but yahoo still has a page for the security. E.g. PIMCO unconstrained bond fund has the symbol <a href="http://uk.finance.yahoo.com/q?s=PUBAX&amp;ql=1" rel="nofollow"><code>pubax</code></a> which is a standard quote page. However, M&amp;G Strat Bond fund doesn't seem to have a yahoo ticker but is identified by its ISIN code instead, <a href="http://uk.finance.yahoo.com/q?s=GB0033828137.L&amp;ql=0" rel="nofollow"><code>GB0033828137.L</code></a>.</p>
  
  <p>The format of the url to visit the quotes page of both securities is the same with the <code>s</code> parameter in the url being the ticker or the isin.</p>
  
  <p>Now, regarding the YQL API. If I run a query like:</p>
  
  <pre><code>select * from yahoo.finance.quotes where symbol in ("pubax")
  </code></pre>
  
  <p>I get results as expected. See <a href="http://developer.yahoo.com/yql/console/?q=show%20tables&amp;env=store://datatables.org/alltableswithkeys#h=select%20%2a%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22pubax%22%29" rel="nofollow">test console</a></p>
  
  <p>However, if I run the same query using an ISIN of a security without a ticker:</p>
  
  <pre><code>select * from yahoo.finance.quotes where symbol in ("GB0033828137.L")
  </code></pre>
  
  <p>The results array contains null values and <code>Ticker not available</code> error is raised. <a href="http://developer.yahoo.com/yql/console/?q=show%20tables&amp;env=store://datatables.org/alltableswithkeys#h=select%20%2a%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22GB0033828137.L%22%29" rel="nofollow">See console</a></p>
  
  <p>Is there a way to get quotes from yahoo using ISIN in cases where a ticker is non-existant?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>This issue also occurs with the csv API:</p>
  
  <p><a href="http://download.finance.yahoo.com/d/quotes.csv?s=pubax,GB0033828137.L&amp;f=d1l1&amp;e=.csv" rel="nofollow">http://download.finance.yahoo.com/d/quotes.csv?s=pubax,GB0033828137.L&amp;f=d1l1&amp;e=.csv</a></p>