I have been trying to retrieve pricing of ETFs and always the output is Missing[“NotAvailable”] which is information that FinancialData used to have.
Yes, that has been happening to me too.
Thank you for the answer!!
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.
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.
Yes it seems indeed that stuff is missing. Very annoying.
This service is just very unreliable is my experience over the last 4 years.
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
Hi Arnoud,
Are you also considering of offering this as a paid solution? If the price is good I would not mind.
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…
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 Marketstack API FAQ | Real-Time, Intraday & Historical Data
I haven’t but when I have time I’ll give it a try.
Seems like a very easy API approach.
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?
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.
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
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}]}]]]]
Hi,
Do you know if this issue will be solved?
When, how and is it going to be reliable?
Thank you,
Eduardo
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.
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.
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.
FinancialData[“DJI”]
Missing[NotAvailable]
Does this make sense to you?
Yes (speaking to self!). Same problem mentioned above.