Forum Discussion
Excel Formulas and Functions
To start I am on a Dell desktop using Microsoft 365 Excel MSO (Version 2112 Build 16.0.14729.20254) 64-bit16.0.14729.20254) 64-bit, WIN 10. In the attached spreadsheet I input a date and get back th...
1. The companies and symbols In the sheet you attached do NOT correspond to your descriptions. First issue.
2. A second point, though, may be more relevant. I use the STOCKHISTORY function as well, and have discovered that it's not always reliable. In my case, the history for BRKB was off by significant factors. There's a reason for the "Disclaimer" that appears at the top of the sheet whenever you first load it.
3. It wouldn't surprise me to hear that data concerning SPACs is not altogether reliable. The fact that most of your 40 companies DO work is evidence that you're doing this as you should.
You might want to check out data on Yahoo Finance for the ones that don't work via STOCKHISTORY; that's what I had to do for BRKB