Group Abstract Group Abstract

Message Boards Message Boards

0
|
24.3K Views
|
9 Replies
|
0 Total Likes
View groups...
Share
Share this post:

S&P 500 Index Historical Data "NotAvailable"

How can one get historical financial data of S&P 500 Index? Is this data available in Mathematica? This command results in missing data:

In[1]:= data = FinancialData["^SPX", {"1/1/2012", "12/31/2012"}]

Out[1]]= Missing["NotAvailable"]
POSTED BY: Tarkeshwar Singh
9 Replies
Sort By:

This post solutions are relevant: How to get FinancialData[] Exchange Rates ?
POSTED BY: EDITORIAL BOARD
Chip Chapin
Chip Chapin
Posted 12 years ago

Thank you Sean, Quandl looks very promising for lots of things. Appreciate the info and the link. Also the nice bit of code.
POSTED BY: Chip Chapin

This code below manually pulls out the DJI members and gets their prices. This might be useful instead. 

djiaMembers=WolframAlpha["Dow Jones members",{{"Result",1},"ComputableData"},PodStates->{"Result__More"}];
members=WolframAlpha["company "<>#,"WolframResult", TimeConstraint->60]& /@ djiaMembers;
mem=EntityValue[#,"Symbol"]& /@ Cases[members,Except[_Missing]];
findata=FinancialData[#,"Price",{{2000},{2010},"Month"}][[All,2]]&/@mem[[-12;;-3]];
POSTED BY: Sean Clarke
POSTED BY: Sean Clarke
Chip Chapin
Chip Chapin
Posted 12 years ago

Anybody have news on how long it's going to take them to fix the missing financial data?
POSTED BY: Chip Chapin

WRI in-house cognoscenti, any background on this behavior?

--Curious in Boston
POSTED BY: David Reiss
POSTED BY: David Reiss

FinancialData appears to have some problems at the moment (and in recent days). So, for example your problem returns no data. And also the following from the documentation

DateListLogPlot[FinancialData["^DJI", All]]

returns

DateListLogPlot[Missing["NotAvailable"]]

Perhaps someone from WRI can comment on these issues and any related ones?
POSTED BY: David Reiss

I am not really sure about the current problems with FinancialData, but some time ago in this community someone did discuss the command:

DateListLogPlot[FinancialData["^DJI", All]]

Someone from Wolfram said that that would not work anymore because the data was provided by Yahoo, and they do not provide ^DJI anymore. So no matter what the current problems are, that particular function will not work anymore. Oh, one second, ... here's the post by Sean Clarke:

http://community.wolfram.com/groups/-/m/t/224831?_19

I am not sure whether this is related/helps.

Cheers, Marco
POSTED BY: Marco Thiel
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