I have always struggled to use the FinancialData interface and encountered many self caused problems. I have been using sample data to compare against but I can never seem to get them to match.

The ETFs that I'm interested in have been restored - thank you.

Let me now ask about Mutual Funds. I'm getting nothing back from FinancialData on any of the ones on my list of interest.

Have mutual funds been restored?

If so, is there something tricky in how the call is made in FinanicalData that is tripping me up? An example that works would be helpful.

If not, what's the planned timetable?

Let me just add that I appreciate that Wolfram keeps working on improving this data feed. The support team is getting the brunt of our frustrations for a situation not of your making. Thank you for your continuing support.

I had a lot of issues using FinancialData and I can't find good docs on the full tickers to use (whether to prepend the exchange or not, it seems rather random). Is there an updated docs on how to query FinancialData? To date, I have only been working off some external sample data.

I forgot, thank you for the help and quick reply!

I hope this gets fixed soon.

Dear Wolfram colleagues,

Would be nice to get an answer to my question on the expected time for data availability from Milan, Amsterdam, Madrid stock exchanges and the historical series range posted almost one month ago.

Thanks.

Just to complement my previous message:

Checked some of the historical values. Unless a programming mistake, this really looks less enthusiastic. As you can see for the first 12 ETF in the list for which data are available:

Initial historical values before data discontinued in August 2019: {{1, {2017, 1, 24}}, {2, {2015, 11, 10}}, {3, {2005, 3, 2}}, {4, {2008, 10, 13}}, {5, {2009, 3, 4}}, {6, {2008, 10, 6}}, {7, {2013, 9, 10}}, {8, {2016, 5, 10}}, {9, {2014, 9, 16}}, {10, {2010, 6, 23}}, {11, {2009, 3, 4}}, {12, {2010, 6, 16}}

First historical data available now: {{1, {2017, 2, 8}}, {2, {2018, 3, 1}}, {3, {2018, 2, 14}}, {4, {2018, 2, 14}}, {5, {2009, 3, 4}}, {6, {2018, 3, 23}}, {7, {2018, 4, 5}}, {8, {2018, 4, 5}}, {9, {2018, 4, 5}}, {10, {2018, 4, 5}}, {11, {2018, 4, 18}}, {12, {2018, 4, 18}},

In this small example, we're talking of having lost in some cases daily data (i.e. number 3) for over 14 years (!) with all the implied statistical lost. I understand I could nevertheless join the two series from my files...however...

Thanks.

Cary,

I wonder then what has changed regarding DJI, which is nothing like "real time". I have used the dataset from 2018.

Of course Mathematica programs have skyrocketed, becoming obsolete as operating systems are updated.

David

This was very helpful — there was a provisioning problem with some of these ETFs, which should now be solved for the exchanges we have access to (and if not, please report any further problems):

In[58]:= FinancialData[{"PA:EGOV", "PA:CBBB", "PA:C40", "DE:DXSP", 
  "DE:DBPD", "DE:IS0Q", "L:VWRD", "L:VDPX", "L:VDJP"}, {"Symbol", 
  "Close"}]

Out[58]= {{"PA:EGOV", 
  Quantity[55.63600158691406, "Euros"]}, {"PA:CBBB", 
  Quantity[16.23539924621582, "Euros"]}, {"PA:C40", 
  Quantity[89.29000091552734, "Euros"]}, {"DE:DXSP", 
  Quantity[11.251999855041504`, "Euros"]}, {"DE:DBPD", 
  Quantity[2.7335000038146973`, "Euros"]}, {"DE:IS0Q", 
  Quantity[96.00199890136719, "Euros"]}, {"L:VWRD", 
  Quantity[0.9556000232696533, "BritishPounds"]}, {"L:VDPX", 
  Quantity[0.25882500410079956`, "BritishPounds"]}, {"L:VDJP", 
  Quantity[0.31636300683021545`, "BritishPounds"]}}

The discrepancy between "theoretically" available quotes and what is actually accessible through FinancialData should be significantly reduced with the next update of that paclet; a version is currently in testing which will update the list of valid ticker symbols and fix various other bugs.

With the exception of some selected indexes for which we are still working to secure redistribution rights, tickers on the exchanges noted above in this thread are what FinancialData is now limited to:

• Bombay
• Frankfurt
• Hong Kong
• London
• NASDAQ
• NYSE
• Paris
• Shanghai
• Shenzhen
• Tokyo
• Toronto
• Xetra

As some people have noted, it's true that an individual may be able to scrape more extensive market data from various websites, but exposure in the Wolfram Language through FinancialData[] is in a different category from simple web display — in the current landscape, bulk redistribution of financial data requires, in most cases, not only licensing from aggregators of financial data, but also direct agreements with individual exchanges. We've had to limit our coverage to the financial instruments that have historically seen the most usage through the Wolfram Language, and for which we are able to satisfy applicable distribution and reporting requirements for each exchange or other provider.

Hi Alan,

It’s good to see that things are moving ahead and service is progressively returning after got discontinued in August 2019.

I am one of those heavily affected users for which a lot of work has turned completely useless.

I still can see that even if some services are restored, big discrepancies remain between Mathematica catalogue of theoretically available quotes and those effectively available. In my case, I was working with a group of around 125 European ETFs and they’re still not available and this happens since August 2019.

I understand that sometimes commercial issues with providers might come up, but it is less understandable to not receive a precise timeline for which the different pieces of info will be restored. This does not show very open and transparent, in particular as it has not been the case even when reached the company customer service.

Hope we get better news soon.

Thanks for your help.

Extensive historical price data for companies listed on NYSE and NASDAQ remains available. Regarding one specific complaint above, note that L3 Technologies (now "L3Harris Technologies" after a merger earlier this year) is actually LHX, not LXH:

In[81]:= FinancialData["NYSE:LHX"]
Out[81]= Quantity[197.41000366210938`, "USDollars"]

Historical data (at least 10+ years in most cases) for stocks on ten major global exchanges has been restored:

In[103]:= FinancialData[{"DE:BMW", "PA:UBI", "L:LLOY", "HK:03690", 
  "MB:500096", "SS:601857", "SZ:000002", "F:SIE", "TSE:7203", "TO:RY"}]

Out[103]= {Quantity[74.0999984741211, "Euros"], 
 Quantity[60.439998626708984`, "Euros"], 
 Quantity[0.63919997215271, "BritishPounds"], 
 Quantity[102., "HongKongDollars"], 
 Quantity[459.6000061035156, "IndianRupees"], 
 Quantity[5.800000190734863, "ChineseYuan"], 
 Quantity[31.68000030517578, "ChineseYuan"], 
 Quantity[117.05999755859375`, "Euros"], Quantity[7744., "Yen"], 
 Quantity[103.83000183105469`, "CanadianDollars"]}

And as of last Friday, we've restored data for ~2300 ETFs. There were some gaps in historical data that should now be filled in:

In[102]:= FinancialData /@ {"NYSE:SPY", "NYSE:BSV", "NYSE:XLK", 
  "NYSE:SCHB", "NASDAQ:QQQ"}

Out[102]= {Quantity[320.8999938964844, "USDollars"], 
 Quantity[80.62999725341797, "USDollars"], 
 Quantity[90.72000122070312, "USDollars"], 
 Quantity[76.3499984741211, "USDollars"], 
 Quantity[210.86000061035156`, "USDollars"]}

A few remaining pieces noted above in this thread (including access to things like DJIA and IXIC) should be restored within the next week or so, along with historical dividend data.

Yes (speaking to self!). Same problem mentioned above.

When in college and grad school I used it for stats calculations, etc. Liked it. So I recently purchased the software for myself, and I must say that I am disappointed with the misleading advertising of its capabilities as far as FInancialData. You cannot access historical data of major indexes such as NASDAQ:QQQ, but you can access S&P500. Companies listed in the S&P 500 are missing. For example, LX3 Technologies "LXH" is La Juanita Airport... Not possible to access its historical data, or anything. It is just infuriating.

When I was about to buy Mathematica I asked whether historical stock prices are available, I was assured via email that yes.

So much for that. Also, by looking at the help section you get the impression that FinancialData can access basic financial data. After reading this discussion, it turns out it cannot and most likely will not.

I find the reply by Arnoud that Mathematica "will bring this functionality back online if and when it becomes viable to do so." as really off putting. Dear Arnoud: - Is it viable to have a help section that misleads people?
- Is it viable to not inform people about the limitations of FinancialData as far as basic market data?

Why is it not viable to update the help section and indicate the limitations of FIanancialData? After all this problem no longer a temporary glitch.

You get 15 day to try before you buy - admittedly I could have spend day and night testing all the possible capabilities and not trust Wolfram that their help section and email support is there to help and inform.

My suggestion - bring the functionality back on line, or change the way you describe FiancialData so that people are not misled. Otherwise, users will just give up on you. There is nothing worse than not trusting that the described functionality is actually there, or that it can just disappear on a whim.

It's a shame but it's true. It's time to look for some other source for Data. I've been reluctant to try Qandl's APIs, but this might be it...

How about stock market indices? DJIA and ^IXIC, for example, used to work and now don't. I just rewrote a bunch of R code in Mathematica and now it's all broken.

Arnoud, Thank you for explaining the situation.

I realize a lot of this is outside Wolfram's control, but I would still like to strongly encourage you to bring back full functionality as soon as practical. (For me, FinancialData[] was the primary benefit of moving to version 12. Most of my development work during the last 6 months is now inoperable.)

Can you suggest any alternatives/work arounds? I have a lot of Mathematica code that relies upon FinancialData[] to access ETF, mutual fund, international stocks, and indexes for historical price history.

Regards, Steve

Hello Arnoud

I came across your reply to the original post as I've been having problems with FinancialData[] myself.

It has been a month since your reply, does the problem persist?

Is it so?

Metal prices are missing...

TimeSeries[FinancialData["COMEX:HG", {{2019, 9, 1}, Today}]]

Returns

TimeSeries::emptpth: Path is expected to be non-empty.

Note that this line is querying for data only for the last month

Hello Arnoud

Some ten months ago you mentioned that

We've added metal prices and rates for many currency pairs, but stocks are still limited to historical prices for NASDAQ, NYSE, London, Toronto exchanges. Indices, mutual funds, ETFs have not been restored yet.

Would you happen to have any info on when futures will be restored?

So far they're completely missing

FinancialData["Groups"]
{"Currencies", "Exchanges", "ExchangeTradedFunds", "IndexComponents", 
"Indices", "MutualFunds", "Sectors", "Stocks"}

Rgrds,

Wouldn't count on that... I contacted Wolfram support a few weeks ago. This is the reply I got:

Hello Fede, Thank you for contacting Wolfram Technical Support and taking the time to send us your report.

FinancialData, FinancialIndicator, TradingChart and associated WolframAlpha Entity["Financial",..] functionality that access market data for free have been affected by the decision of one of our long-time service providers to stop delivering data. While historical prices/volume for stocks on North American exchanges will still be available, delayed quotes and data about mutual funds, indices, etc. are currently not available.

We are working to bring this functionality back online as soon as possible.

Sincerely, Wolfram Technology Group, Wolfram Research Inc.

Yes, that has been happening to me too.