Is there a native and free API and DB to request information such as:

  • All the companies which their P/E ratio is greater than 50

  • The closing prices of stock $XYZ

  • 1
    $\begingroup$ Mathematica has lots of this built into their FinancialData[] function. $\endgroup$
    – Jagra
    Jul 13, 2013 at 20:47
  • $\begingroup$ @Jagra, How do you get the data into the Array, my question is how to collect the data rather than how to process it. thanks $\endgroup$
    – 0x90
    Jul 13, 2013 at 20:56
  • 1
    $\begingroup$ @0x90 - That is exactly what FinancialData[] does. Please refer to its documentation. $\endgroup$ Jul 13, 2013 at 22:04
  • $\begingroup$ @acheong87 add this as an answer. is there anything similar for matlab? $\endgroup$
    – 0x90
    Jul 13, 2013 at 22:09
  • $\begingroup$ Like I said last time I closed your question, this is a site for people who work in quantitative finance. $\endgroup$ Jul 14, 2013 at 0:52

1 Answer 1


Try the yahoo screener: http://screener.finance.yahoo.com/newscreener.html

The java version will run on windows/osx/linux and you can download to a csv.

Edit: the java version no longer works.

This link is the best yahoo has. https://screener.finance.yahoo.com/stocks.html

Quandl has all of this data as well so people can generate their own data.


Not the answer you're looking for? Browse other questions tagged or ask your own question.