Message Boards Message Boards

1
|
677 Views
|
1 Reply
|
2 Total Likes
View groups...
Share
Share this post:

Inconsistent Missing data in some financial data

Gregor Purdy
Posted 5 months ago

While familiarizing myself with the financial data available in Mathematica (14) I've seen some strange behaviors. Are these known things I need to work around by using the features differently?

For example, I fetched Name and MarketCap for some example securities and got back no MarketCap for one of them.

In[83]:= FinancialData[{"NASDAQ:QCOM", "NASDAQ:LIN", 
  "NYSE:TMO"}, {"Name", "MarketCap"}]

Out[83]= {{"Qualcomm", 
  Quantity[2.1817769317626953`*^11, "USDollars"]}, {"Linde", 
  Missing["NotAvailable"]}, {"Thermo Fisher Scientific", 
  Quantity[2.102417259126953*^11, "USDollars"]}}

That seemed strange, so I checked the Properties of that stock with:

FinancialData["NASDAQ:LIN", "Properties"]

and MarketCap was in the list.

Then, I ran a different command to fetch a few properties of the Linde data:

In[89]:= FinancialData["NASDAQ:LIN", {"MIC", "Exchange", "Symbol", 
  "Name", "MarketCap", "SICCode", "Sector", "Website"}]

Out[89]= {"XNAS", "Nasdaq", "NASDAQ:LIN", "Linde", 
 Quantity[2.1170168927215576`*^11, "USDollars"], "2810", "Chemicals", 
 Missing["NotAvailable"]}

And now MarketCap is filled in.

I'm not going to be able to use the financial data features of Mathematica unless I can rely on them being complete and correct and available.

Am I doing it wrong?
POSTED BY: Gregor Purdy
1 Reply
Sort By:

The calls to EntityValue that feed FinancialData would look like this,

EntityValue[{
  Entity["Financial", "NASDAQ:QCOM"],
  Entity["Financial", "NASDAQ:LIN"],
  Entity["Financial", "NYSE:TMO"]},
 {EntityProperty["Financial", "Name"],
  EntityProperty["Financial", "MarketCap"]}]

Still coming up Missing. The direct call into a single Entity does work.

Entity["Financial", "NASDAQ:LIN"]["MarketCap"]

This example creates a series of direct calls.

AssociationMap[
 #@EntityProperty["Financial", "MarketCap"] &,
 {
  Entity["Financial", "NASDAQ:QCOM"],
  Entity["Financial", "NASDAQ:LIN"],
  Entity["Financial", "NYSE:TMO"]
  }]
POSTED BY: Christopher French
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract