Message Boards Message Boards


How can I display a chart showing historical Price/Earnings Ratios?

Posted 3 years ago
6 Replies
0 Total Likes

I am trying to use:

DateListPlot[FinancialData["GE", "Jan. 1, 2006","PERatio"]] 

but it's not working. Any ideas?

6 Replies

Hi Claudio, I have the same problem with "GE". If you follow the Wolfram Financial Plattform: Quick Start, by Michael Kelly & Samuel Chen (check below the first lines), you get "Missing["NotAvailable"], for "GE". For all other companies it is fine. So the problem must be in in NYSE and not in Mathematca.

stocks = {"MSFT", "AAPL", "GOOG", "GS", "XOM", "GE"}; properties = {"Symbol", "Name", "Price", "PERatio", "MarketCap"} data = Table[FinancialData[s, p], {s, stocks}, {p, properties}] stocktable = Style[TableForm[data, TableHeadings -> {None, Style[#, Bold] & /@ {"Ticker Symbol", "Name", "Current Price", "P/E Ratio", "Market Cap"}}], FontFamily -> "Verdana", 14]

  1. The syntax is not correct. You may have noticed that FinancialData gives an error. That is because the date comes last:

    FinancialData["GE", "PERatio", "Jan. 1, 2006"]

  2. FinancialData returns Missing, meaning that no data exists for the PE ratio from that time.

  3. You can sometimes get FinancialData from Wolfram|Alpha. See here for a tutorial:

  4. Sometimes, you just can't get the financial data you want from free sources. This is why people pay for a bloomberg or reuters subscription.

Sorry. More accurately I meant that Yahoo, the provider of the free data isn't providing that data. They still sometimes provide data on their website that they won't provide through their services. Data licensing issues are complicated and annoying.

Posted 3 years ago

Thank you Sean.

I tried this, but it says data not available: WolframAlpha["Microsoft pe ratios 2011"]

Any other ideas before I look for an API somewhere else?

In the past I've had success with Quandl. There is a Mathematica package online for working with it, although it's fairly easy to use without it as well.

Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
or Discard

Group Abstract Group Abstract