10
$\begingroup$

I'm following http://reference.wolfram.com/mathematica/ref/FinancialData.html

I get the following:

In[6]:= DateListLogPlot[FinancialData["^DJI", All]]

During evaluation of In[6]:= DateListLogPlot::ntdt: The first argument to DateListLogPlot should be a list of pairs of dates and real values, a list of real values, or a list of several such lists. >>

Out[6]= DateListLogPlot[Missing["NotAvailable"]]

In[8]:= FinancialData["DJI", All]

During evaluation of In[8]:= FinancialData::notent: DJI is not a known entity, class, or tag for FinancialData. Use FinancialData[] for a list of entities. >>

Out[8]= FinancialData["DJI", All]

In[9]:= FinancialData["^DJI"]

Out[9]= Missing["NotAvailable"]

What's going on here? Is the DJI data unavailable somehow?

Improve this question
$\endgroup$
10
  • $\begingroup$ It appears it's not available right now for me either. Other indices are working. DateListLogPlot[FinancialData["AAPL", All]]. $\endgroup$
    – kale
    Commented Aug 17, 2012 at 2:18
  • $\begingroup$ What happens if you execute FinancialData["^DJI", "Properties"]? FinancialData["^DJI", All]? $\endgroup$
    – J. M.'s missing motivation ♦
    Commented Aug 17, 2012 at 2:18
  • 4
    $\begingroup$ Over the past several weeks lots of glitches have appeared in the curated financial data. e.g., after markets have closed, retrieve all available data for a number of ETF's ("SPY", "TLT", others) and you often find that you get two records with the current date at the end of the list. It appears that the originator of the curated data (Yahoo Finance?) has introduced some changes into their technology infrastructure or perhaps their data base model. One can only hope they clean up the issue. I don't know that we have any leverage in getting them to resolve it excepting reporting to Wolfram. $\endgroup$
    – Jagra
    Commented Aug 17, 2012 at 3:19
  • 2
    $\begingroup$ @Vitaliy: I actually don't need the data for any actual trading; I'm just playing with the API / reading documentation / complaining about things that don't work. :-) $\endgroup$
    – user1602
    Commented Aug 17, 2012 at 5:07
  • 3
    $\begingroup$ Yahoo Finance is the data source that is used. Here is a statement on their website concerning this: help.yahoo.com/kb/… $\endgroup$
    – Searke
    Commented Aug 21, 2012 at 19:23

3 Answers 3

Reset to default
15
$\begingroup$

If one looks for curated data accessible from Mathematica, the WolframAlpha function should always be considered as an option, because it links to curated data bases with frequent continuous updating:

data = WolframAlpha["^DJI price history", 
         {{"HistoryDaily:Close:FinancialData", 1}, "TimeSeriesData"}, 
         PodStates -> {"HistoryDaily:Close:FinancialData__All data"}];

And this is basically the same plot as in the documentation:

DateListLogPlot[data, Filling -> 1, Joined -> True]

enter image description here

You also can access these data interactively to get the same programming syntax. This can actually teach how syntax looks in different cases:

enter image description here

To understand better WolframAlpha integration in Mathematica I suggest the following sources:

Improve this answer
$\endgroup$
4
  • 3
    $\begingroup$ This is impressive. I no longer consider the $130 I spend on mathematica student edition a waste of money. $\endgroup$
    – user1602
    Commented Aug 17, 2012 at 5:44
  • 3
    $\begingroup$ Good answer, but it is a workaround.Point is that FinancialData is not always trustworthy and some of its data may at unpredictable times be unavailable. Do you suggest to always skip this function and use WolframAlpha instead? $\endgroup$
    – Sjoerd C. de Vries
    Commented Aug 17, 2012 at 6:52
  • 1
    $\begingroup$ Just for the record (not anything against Sjoerd's comment) -- even if I would never use this, I'm really grateful for this answer, because I stupidly never realized I had WolframAlpha at my fingertips with Mathematica. (Silly isn't it?) $\endgroup$
    – user1602
    Commented Aug 17, 2012 at 9:39
  • 1
    $\begingroup$ @term-rewritica Just be aware that you're limited to 100 W|A API calls/day (I think) with a student license. I've never hit the limit, or even 10 calls for that matter, but looks like you might with your excitement ;) $\endgroup$
    – rm -rf ♦
    Commented Aug 17, 2012 at 15:34
4
$\begingroup$

The problem here is with the data provider Yahoo!. There has been intermittent problems with Yahoo! over the past few weeks with the DJI. The workaround is WolframAlpha[] as described in one of the answers above.

(from Searke's comment)

Yahoo! is no longer licensed to provide data downloads for the Dow Jones Index. Since Yahoo! is (one of) the data providers used by FinancialData[], FinancialData[] is also affected by this restriction.

Improve this answer
$\endgroup$
3
  • $\begingroup$ Is there an official statement on their dev website? This answer would be more useful if you could link to that statement... $\endgroup$
    – J. M.'s missing motivation ♦
    Commented Aug 17, 2012 at 15:52
  • $\begingroup$ AFAIK XIgnite is the data provider ...or used to be. $\endgroup$
    – Mike Honeychurch
    Commented Aug 17, 2012 at 22:36
  • 1
    $\begingroup$ FinancialData uses both sources for information. See this article from Yahoo about why ^DJI is no longer available. help.yahoo.com/kb/… $\endgroup$
    – Searke
    Commented Aug 21, 2012 at 19:25
1
$\begingroup$

We have another option now: QuandlLink package. Using this package you can compute this as:

Needs["QuandlLink`"]

dowJonesOHLCV = 
QuandlFinancialData[ 
   "YAHOO/INDEX_DJI", 
   startDate -> "2015-01-01", 
   column -> 1 ;; 6];

TradingChart[Rest@dowJonesOHLCV, PlotLabel -> "OHLCV"]

trading chart

Improve this answer
$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.