Forum Discussion
StockHistory Issue #Connect! Error
djgabel I think they have a lot of problem in terms of data accuracy. I tried to use it to track the historical price of vbal, which is a Canadian stock. But the closing price is wrong from the beginning. it is usually about $.20 above the actual price. They only provide correct price beginning from January 2023.
Upon experimenting with the date field for the STOCKHISTORY function I find that some dates yield good data and others don't (CONNECT Errors). If this data is coming from Refinitiv or some other database it feels like a sparse or incomplete matrix like problem, where some dates are not populated with the stock prices and return an error. That's not acceptable for a general-purpose function like STOCKHISTORY. It seems like the problem is with the database and not the function.
My opinion is that it is a combination of problems. The "connect" issue seems to fix itself while bad data is just that....... bad data. There is no way to change it because Microsoft never answers you when you make suggested changes or point out the bad data. Definitive, who I have emailed also ignores you.
I end up for the dates that are missing data just ending STOCKHISTORY the day before, then used YAHOO data and hand enter it, then the next day after the bad data I enter STOCKHISTORY again.
- Refinitive not Definitive
