# Get FinancialData price history?

GROUPS:
 sridev ramaswamy 1 Vote Since 16 may 2017, why am I not able to get the price history of US stock market tickers? Please see output below! Has anything changed? In[9]:= FinancialData["GE", {{2017, 1, 3}, {2017, 5, 15}}] Out[9]= Missing["NotAvailable"] In[10]:= FinancialData["IBM", {{2017, 1, 3}, {2017, 5, 15}}] Out[10]= Missing["NotAvailable"] 
4 days ago
20 Replies
 Hi Sridev,can you try this? Entity["Financial", "NYSE:IBM"][EntityProperty["Financial", "Last", List[Rule["Date", Interval[List[DateObject[List[2005]], Today]]]]]] Cheers,Marco
4 days ago
 Thank you Marco. This did give the price data. but I am not sure about other properties. I shall experiment.one shortcoming is that the last data is as of 16may2017 whereas if FinancialData were working my last data point would have been 17may2017 when you run it on 18may2017.I could see that the data using your syntax is coming from wolfram knowledgebase, whereas the FinancialData function perhaps downloads the data from a different source (perhaps a more Live source). maybe that source is broken? does anyone face similar problem or can anyone working in wolfram in the community comment?Its like a key finance inbuilt function is not working. which is the best place to report this. sorry I have not done that before. Hence the question.
4 days ago
 Hi,it used to use Yahoo.It is true that many of the examples in the documentation of FinancialData do currently not appear to work properly on my machine. (MMA 11.1.1, OSX 10.12.4)Best wishes,Marco
4 days ago
 Marco, Do you know how to obtain from Mathematica a list of entities on in the S&P 500? I have a list in ticker format, e.g. "CAT", but not in the "NYSE:CAT" format.
4 days ago
 Dear David,are you looking for this? EntityClass["Financial", "SP500"] It gives you an entity list. EntityList[EntityClass["Financial", "SP500"]] appears to give all members.Cheers,Marco
4 days ago
 Yes. Thank you!
4 days ago
 This is true for me as well. FinancialData will return a current price if no date is specified. If a date or date range is specified it returns Missing. The missing issue started in the last day or two - it was working up to a few days ago. This has happened before.
4 days ago
 I also have this problem. I assume there must be a problem on the Wolfram side of things???I wonder if there is a way to report such issues to appropriate Wolfram staff?Wolfram Alpha is working for me ... but ... it does not seem to provide Open, High, Low or Volume data.
4 days ago
 I've reported this to tech support. However, the problem might be at the source rather than with Mathematica.
4 days ago
 This is an issue with Yahoo as a data source. Wolfram|Alpha doesn't use Yahoo, so it's not affected. You should try using Entities like the examples in the comments instead of using FinancialData.
3 days ago
 Hi, I have two observations: A couple of days ago there was a Paclet update, I think (http://community.wolfram.com/groups/-/m/t/1093145) I just used the Yahoo historical data api directly as described here. So basically I just execute: URLExecute["http://ichart.finance.yahoo.com/table.csv?s=IBM&a=11&b=15&c=2016&d=11&e=19&f=2016&g=11&ignore=.csv"]  This is the reply I get:If that means what I think it means, it could be a temporary Yahoo glitch which might make this a temporary issue.Cheers,MarcoUpdate: having said that, on the website mentioned above there is a reply from 7 hours ago that says: Hey everyone! Just to update this post a little bit: Historical API has been shut down by Yahoo Finance. Here is a link. If that's true, it might be a longer term problem....
4 days ago
 Thanks Marco. His latest post shows what we feared that the api link with the live source(yahoo finance) is broken. Thanks David for reporting it to wolfram tech support. Pls let us know what you hear from them. I hope they hook the link to google finance or finviz or direct exchange delayed feed service or something like that. I think the alternative Marco's expression worked because it sources info from knowledgebase which gets data stored at a day's delay or something. And the original source for that could be several. so that's still getting data updated. Unless wolfram links up FinanacialData to a new feed, for the moment this function remains broken. even if it returns I am sure it will be a while perhaps till this finance function works in its full old vigour (with several ticker properties not just price that yahoo finance was providing). Lets see. Lets keep each other updated if we find alternative solutions or hear back from wolfram mathematica support.
3 days ago
 Reply just received from tech support:"Thank you for contacting Wolfram Technical Support. It does appear as though our FinancialData functionality is not behaving as one would expect. Upon investigation, it seems as though Yahoo Finance (where we get the data) is down at the moment (https://ichart.finance.yahoo.com/). We are working with them to resolve the issue as soon as possible."They go on to suggest the same workaround used above by Marco.
3 days ago
 Hey. I am new at this and not all that confident about suggesting anything but ...I was poking around and came across https://blog.quandl.comThey provide free data. Here are instructions on the APIhttps://blog.quandl.com/api-for-stock-dataI got joined and got an API key and this workedhttps://www.quandl.com/api/v3/datasets/WIKI/FB/data.csv?api_key=MYAPIKEYI know nothing of the data quality. I wonder, does this seem like a reasonable alternative?
3 days ago
 Have you guys seen this post? Financial data from Quandl in Wolfram Language using QuandlLink
3 days ago
 In regards to Have you guys seen this post? Financial data from Quandl in Wolfram Language using QuandlLink I do not yet have any experience with packages. Does this work better than using variants of the URL for Quandl data? https://www.quandl.com/api/v3/datasets/WIKI/FB/data.csv?api_key=MYAPIKEY Is using that package worth the effort it might take (for me, at least) to make it work? Variants of https://www.quandl.com/api/v3/datasets/WIKI/FB/data.csv?api_key=MYAPIKEY seem fairly simple.
3 days ago
 Edited for clarity and code:Suitable quick solution. There is also a way to fully limit calls to Quandl data fields, ie, retrieve just date and adjusted close or whatever required. Anmol Bajracharya (QuandlLink author) posted a method using Dataset for filtering in the package documentation.QuandlLink can be downloaded from https://github.com/bajracha71/Quandl-Mathematica-QuandlLink. Note FinancialData was never robust (vendor dependencies). It's certainly not the reason to use Mathematica in finance. The following fragment retrieves the 1-year adjusted closing price for AAPL as example : Needs["QuandlLink"] myquandlkey = "myquandlkey"; dataset = "datasets/WIKI/"; sym = "AAPL"; tstart = startDate -> DateString[DatePlus[Yesterday, {-1, "Year"}], "ISODate"]; tend = endDate -> DateString[Yesterday, "ISODate"]; s = Reverse[Rest[QuandlFinancialData[StringJoin[dataset, sym], apiKey -> myquandlkey, tstart, tend]]][[All, 12]]; s0 = Last[s] 
 This doesn't work for you? DateListPlot[ Entity["Financial", "NASDAQ:FB"]["Close", "Date" -> Interval[{DateObject[{2005}], Today}]]] 
 I'm running 11.0.1 under Linux. Here's what I get: DateListPlot[ Entity["Financial", "NASDAQ:FB"]["Close", "Date" -> Interval[{DateObject[{2005}], Today}]]]; DateListPlot::ldata: Missing[RetrievalFailure] is not a valid dataset or list of datasets. FinancialData["NASDAQ:FB", "Lookup"] `{}Many stocks work, but some do not (FB, SNAP, KHC for example)Thanks, Joe