Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I am not sure which language you are using but I have a sample in C#. I think it will give you the idea at least or may be help some one else </p> <pre><code> private string BASE_URL = "http://query.yahooapis.com/v1/public/yql?q=" + "select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20({0})" + "&amp;amp;env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys"; Collection&lt;Quote&gt; quotes; string symbolList = String.Join("%2C", quotes.Select(w =&gt; "%22" + w.Symbol + "%22").ToArray()); string url = string.Format(BASE_URL,symbolList); XDocument doc = XDocument.Load(url); Parse(quotes,doc); </code></pre> <p>What we are doing here is appending "," to each array item then passing that symbol list to yahoo. I have successfully fetched prices for 700 symbols in each call. Hitting yahoo servers for each ticker is a pain. I fetch stock prices for all of 6500+ tickers everyday. Earlier it use to take 3 hours now it is less than 2 mins.....sweet</p> <p>Source link for that code is here - <a href="http://www.jarloo.com/get-yahoo-finance-api-data-via-yql/" rel="nofollow noreferrer">http://www.jarloo.com/get-yahoo-finance-api-data-via-yql/</a></p> <p>P.S. Please get a <a href="https://developer.apps.yahoo.com/dashboard/createKey.html" rel="nofollow noreferrer">api key</a> to work smoothly. The above url is a public link where tables are timed out most of the time. Once you get an api key then your url will be (minus "public")</p> <p><a href="http://query.yahooapis.com/v1/yql" rel="nofollow noreferrer">http://query.yahooapis.com/v1/yql</a></p>
    singulars
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload