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.

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,

Did anyone manage to access S&P500?

FinancialData["SP500“] is used in Tutorial Videos on wolfram.com but returns Missing[NotAvailable]!

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

I hope this gets fixed soon.

Yes NYSE:MBT does work, this is another gripe, the listing stock exchange is required for some stocks, but not for others, and this changes over time, MBT used to be fine without NYSE. Now it is not. This means I have to redefine my portfolio.

But since NYSE:MBT is not listed in FinancialData[], then debugging what is wrong with my definitions is exceedingly hard. I assumed it just disappeared. Turns out no. But I only arrived at this when I manually used FInancialData with random dates on all my stocks with the listing exchange defined. When you have a lot of portfolios defined - that is a lot of wasted time. Whereas this tool was supposed to save me time.

My point holds, please fix FInancialData. Mathematica was one of few programs that claimed it has a built in functionality to retrieve historical stock price data. The way things are now, it is easier to get data via excel manually from Yahoo, or some other API/Provider and then import it. But If I am to generate my own historical data and import via Excel, then I could have used other software packages, including ones which are better designed for a MAC and office integration, and ones which are also for free!

Basic financial data from NYSE listed stock is missing again - For example, MBT on NYSE (Mobile TeleSystems Public Joint Stock Company (MBT) NYSE ) was there a few months ago, now it is gone. All my calculations useless. Stuff that worked, now does not. Not only are the gaps in data, they seem to pop up on a random basis. The Financial data functionality in Mathematica is essentially useless, and it has been useless for months. Please, fix it, give us a timeline, or a refund.

I am sorry, but you cannot advertise a functionality, charge for it and then claim it is hard to provide it, that it is expensive, etc. Mathematica is expensive!! Either provide advertised functionality, or remove it and refund those who purchased it under false pretense that the manual for 12.0 describes actual abilities and not imaginary ones. I mean 12.1 is out, I checked the features, no mention of fixing FianancialData, the problem is not acknowledged, the manual still misleads. I think Wolfram should realize that there is competition out there. Customers hate being misled.

This is list of NYSE stocks from FInanciaData [] starting with M. NO MBT.

"NYSE:M", "NYSE:MA", "NYSE:MAA", "NYSE:MAC", "NYSE:MAIN", "NYSE:MAN", \ "NYSE:MANU", "NYSE:MAS", "NYSE:MATX", "NYSE:MAXR", "NYSE:MBI", \ "NYSE:MC", "NYSE:MCB", "NYSE:MCC", "NYSE:MCD", "NYSE:MCK", \ "NYSE:MCO", "NYSE:MCRO", ...

No MBT anywhere in the output of FinancialData []. This a regular stock listed on NYSE, not some ETF or index fund, the data was available, now it is gone. Providing historical stock quotes is not that expensive or that hard. This is a cost cutting exercise at the expense of customers. Makes you wonder what functionality will be covertly cut next.

Fix this!

Great paid options for data that are reasonably priced: https://eodhistoricaldata.com and https://intrinio.com/

I had to move away from FinancialData years ago. Reliability and quality of the data for serious use was very poor. I've used both of the data providers above and both are excellent for the price.

Best

Do I have the NASDAQ index incorrect here?:

FinancialData["NASDAQ"]
Missing["NotAvailable"]

Also how is S&P 500 accessed?

I guess DJI is still unavailable.

Thanks, David

Hi Alan,

Many thanks for the update. Much appreciated.

As you may see below, the picture now looks much more promising. Haven't checked historical values yet, but current values for tickers from the exchanges for which access is already granted work 100% fine:

{1, "PA:EGOV", 55.69},
{2, "PA:CBBB", 16.2359},
{3, "PA:C40 ", 89.99},
{4, "PA:C50 ", 85.97},
{5, "PA:CD8 ", 128.58},
{6, "PA:CEU ", 254.38},
{7, "PA:AHYE", 237.372},
{8, "PA:AFLE", 50.3074},
{9, "PA:AFRN", 101.029},
{10, "PA:X1G ", 255.949},
{11, "PA:CV9 ", 236.778},
{12, "PA:ANX ", 97.65},
{13, "XMCE:BBVAE", Missing["NotAvailable"]},
{14, "XMCE:BBVAI", Missing["NotAvailable"]},
{15, "DE:DXSP", 11.172},
{16, "MI:XDAX", Missing["NotAvailable"]},
{17, "DE:DBPD", 2.6875},
{18, "MI:OILB", Missing["NotAvailable"]},
{19, "MI:CORN", Missing["NotAvailable"]},
{20, "MI:BULL", Missing["NotAvailable"]},
{21, "MI:NGAS", Missing["NotAvailable"]},
{22, "MI:PHAU", Missing["NotAvailable"]},
{23, "MI:PHPT", Missing["NotAvailable"]},
{24, "MI:PHAG", Missing["NotAvailable"]},
{25, "MI:AIGP", Missing["NotAvailable"]},
{26, "MI:SBUL", Missing["NotAvailable"]},
{27, "MI:SOIL", Missing["NotAvailable"]},
{28, "MI:WEAT", Missing["NotAvailable"]},
{29, "MI:CRUD", Missing["NotAvailable"]},
{30, "MI:IFFF", Missing["NotAvailable"]},
{31, "MI:AGED", Missing["NotAvailable"]},
{32, "BE:IS0C", Missing["NotAvailable"]},
{33, "DE:2B76", 8.029},
{34, "MI:FXC", Missing["NotAvailable"]},
{35, "DE:EXS1", 117.68},
{36, "AS:CSX5", Missing["NotAvailable"]},
{37, "L:ISF", 7.431},
{38, "MI:SJPA", Missing["NotAvailable"]},
{39, "MI:DGTL", Missing["NotAvailable"]},
{40, "DE:EXI2", 46.79},
{41, "DE:EXI3", 269.3},
{42, "DE:EUNW", 106.15},
{43, "DE:IQQH", 7.076},
{44, "DE:IS0E", 11.398},
{45, "MI:HEAL", Missing["NotAvailable"]},
{46, "DE:IS0R", 95.818},
{47, "DE:IUS7", 106.07},
{48, "DE:IS0Q", 96.16},
{49, "DE:IUSQ", 52.},
{50, "AS:IEER", Missing["NotAvailable"]},
{51, "AS:IEMA", Missing["NotAvailable"]},
{52, "AS:IMEU", Missing["NotAvailable"]},
{53, "MI:IJPE", Missing["NotAvailable"]},
{54, "DE:IBCH", 59.258},
{55, "DE:EXXT", 85.86},
{56, "DE:IS0D", 13.016},
{57, "MI:CINA ", Missing["NotAvailable"]},
{58, "MI:CRB ", Missing["NotAvailable"]},
{59, "MI:AUST", Missing["NotAvailable"]},
{60, "PA:CAC ", 59.84},
{61, "PA:DAX ", 129.68},
{62, "PA:DJE ", 270.6},
{63, "MI:EST ", Missing["NotAvailable"]},
{64, "PA:CRP ", 155.399},
{65, "PA:CSH", 104.632},
{66, "PA:MSED", 186.52},
{67, "PA:MSE ", 37.405},
{68, "PA:BXX ", 2.742},
{69, "PA:LVE ", 33.71},
{70, "PA:BSX ", 14.466},
{71, "MI:LEVMIB", Missing["NotAvailable"]},
{72, "MI:BERMIB", Missing["NotAvailable"]},
{73, "XMCE:LYXIB", Missing["NotAvailable"]},
{74, "XMCE:IBEXA", Missing["NotAvailable"]},
{75, "XMCE:2INVE", Missing["NotAvailable"]},
{76, "XMCE:INVEX", Missing["NotAvailable"]},
{77, "MI:BRA ", Missing["NotAvailable"]},
{78, "PA:JPN ", 137.69},
{79, "MI:LATAM ", Missing["NotAvailable"]},
{80, "PA:LVD ", 121.98},
{81, "PA:LVC ", 25.57},
{82, "PA:ES10", 177.93},
{83, "PA:LEM ", 11.492},
{84, "PA:MEU ", 141.51},
{85, "PA:INR ", 18.006},
{86, "PA:WLD ", 221.19},
{87, "PA:LQQ ", 399.},
{88, "MI:UST ", Missing["NotAvailable"]},
{89, "PA:PAF ", 9.285},
{90, "PA:RUS ", 49.045},
{91, "PA:SP5 ", 31.655},
{92, "PA:SHC ", 16.986},
{93, "PA:SEL ", 18.195},
{94, "MI:BNK ", Missing["NotAvailable"]},
{95, "MI:OIL ", Missing["NotAvailable"]},
{96, "MI:TNO ", Missing["NotAvailable"]},
{97, "MI:TELE ", Missing["NotAvailable"]},
{98, "MI:UTI ", Missing["NotAvailable"]},
{99, "PA:BX4 ", 2.76},
{100, "MI:HK", Missing["NotAvailable"]},
{101, "DE:SYBM", 66.076},
{102, "DE:SPYJ", 36.995},
{103, "DE:SPYF", 64.95},
{104, "DE:SPYA", 63.94},
{105, "DE:SPYM", 53.69},
{106, "PA:ERO", 230.22},
{107, "DE:ZPRS", 72.99},
{108, "DE:SPY4", 56.01},
{109, "DE:SPY5", 310.47},
{110, "DE:ZPDD", 33.19},
{111, "DE:ZPDS", 27.225},
{112, "DE:ZPDF", 30.805},
{113, "DE:ZPDH", 27.365},
{114, "DE:ZPDI", 31.2},
{115, "DE:ZPDM", 25.04},
{116, "DE:ZPDT", 47.51},
{117, "AS:VEUR", Missing["NotAvailable"]},
{118, "AS:VFEM", Missing["NotAvailable"]},
{119, "AS:VUSA", Missing["NotAvailable"]},
{120, "L:VWRD", 0.95935},
{121, "L:VDPX", 0.262087},
{122, "L:VDJP", 0.314737},
{123, "L:VDVA", 0.339}

Would then be possible to know when is it expected to get availability to the remaining exchanges in the 123 sample: Basically Milan, Amsterdam and Madrid.

This would be much appreciated to better plan a way forward.

Thanks again for your support.

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

Yet, a seemingly simple dataset as Dow Jones International (DJI), which was useful for "years", is still not available.

Hi again, Alan.

Thanks for the update. I am looking forward to receiving the new data.

The ETF group I used to work with is quoted across the following exchanges: Paris, Xetra, London, Amsterdam, Berlin, Milan and Madrid. However I am encountering problems still when trying to get ETF quotes from Paris, Xetra and London exchanges.

Kindly see below:

As you can see, I only able to get 2 ETF quotes from Paris whilst all the rest are still missing. The same goes for Xetra and London.

Any reason? Could you please help me on this? Any expected date to be able to get the rest?

Many thanks for your support.

Hello Allan

If this is a problem that will indeed be solved, the least Wolfram can do is to officially announce when can its customers expect the fix.

I find the "we are trying to secure additional agreements" explanation difficult to swallow. It feels halfhearted, especially when given in a digital forum thread that began 5 months ago.

I've reported this issue to Tech Support on multiple occasions, the first one on July 2018 [CASE:4090958] ...18 months ago. Based on the fact that the problem remains, my gut tells me it won't be fixed. This is not a temporary glitch.

This is particularly infuriating because it goes against Mathematica's advertised capabilities and the ease of use on real world data it's predicated upon. I guess the only way we can vent our frustrations is in forums like these.

I'm hope I'm wrong. Thanks in advance for any help raising this issue inside the company.

It is interesting that we can download ^GSPC from Yahoo, but can't access it using FinancialData. I really hope these issues can be resolved on a permanent basis.

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

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.

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.

Currently available only as properties of a small set of entities, not as listings on a futures exchange:

DateListPlot[
 EntityValue[{Entity["Element", "Gold"], Entity["Element", "Silver"], 
   Entity["Element", "Platinum"], Entity["Element", "Palladium"]}, 
  Dated["Price", 
   Interval[{DateObject[{2019, 9, 1}], DateObject[{2019, 9, 30}]}]]]]

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.

Hi Enrique, I found a site that has the ambition to replace the service Yahoo always had. I always used Yahoo but then they cancelled their access through their API. Quandl has not all stuff I need. Did you try working with https://www.worldtradingdata.com/faq I haven't but when I have time I'll give it a try. Seems like a very easy API approach.

Hi Arnoud, Are you also considering of offering this as a paid solution? If the price is good I would not mind.

Yes it seems indeed that stuff is missing. Very annoying. This service is just very unreliable is my experience over the last 4 years.

FinancialData, FinancialIndicator, TradingChart and associated WolframAlpha Entity["Financial",..] functionality that access market data for free have been affected by the reconfiguration of our financial data providers.

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 will bring this functionality back online if and when it becomes viable to do so.

Yes, that has been happening to me too.