Forum Discussion
D0001
Nov 02, 2021Brass Contributor
Excel 365 Stock Data not updating all stocks
Does anyone know how to determine which stocks are now updating and which are not (without doing a laborious manual compare to another source)...is there a list by Refinitiv perhaps? Alternatively, ...
Wayne_Marcus
Jul 11, 2023Copper Contributor
Whats it take to get at least a simple response from MSFT itself? Maybe an ETA.
- D0001Jul 11, 2023Brass ContributorWayne: Re: Response from MSFT
If you contact them, go through support on the phone, they will try to be helpful, and in some of the past cases, they have showed us how to roll back to a prior version of Excel 365 which has the integration working. The current version of 365 works with the past version of Mac OS, so if you can find a way to roll back to Ventura 13.4 (from Ventura 13.4.1), then you'll be back in business until MSFT updates Excel 365--last time they had given a time frame of one to three months, which was why I rolled back my Excel and it worked. I've had zero luck in getting Apple to help with this issue (or even help with a roll back), as they don't feel it is their issue.
Phester: Re: Data Providers
There's another 3rd party integration within Excel 365 (Stock Connector)...go to Insert, Ad-ins, Get Ad-ins, and it will probably come up as the seventh one on the list, or do a search for Stock Connector. I used this for several years; problem was ease-of-use...you have to write simple formulas to get the data from its display into your spreadsheet, some coverage issues, and it was a bit clunky. You can try Google Sheets...most of the authors on Seeking Alpha use the sheets, but it also has integration issues from time to time. For me, it wasn't desirable as I have many comprehensive workbooks in Excel, and the idea of trying to port them over won't work for me. If you have simple sheets, then using Google is probably a good option. Yahoo used to have an integration as well, and I used that for a year as it was integrated with Excel; however, if I recall correctly, they killed either the integration or the service which forced me to switch (don't quote me on this last part)! I've looked at other integrations, but for ease-of-use, the built in Excel Stocks was by far the best and easiest. I'd happily pay several hundred dollars a year for the service if it could be more reliable.
Acaruso: Regarding Logging in and Out: I've found I had to log out, close the app, reboot the computer, then log in. Sometimes after a rollback for example, it didn't work until I did it a couple times; yes, that makes no sense, but I kept trying as I'd exhausted everything else. If after a couple times you have no luck, then I'd suggest calling MSFT and asking for help, then asking them if this issue has been reported. If it has been reported, then they will probably tell you that the engineering team is working on it, in which case, the next question is when is, is there a workaround, and when is an expected fix. I was able to get them to open a case number for me in the past. They also communicated via email to me when they had a work-around, then eventually when they had a fix. Going directly to them or reading this thread where others had tried various things was the only help I found. Please post if you do contact MSFT and find out anything as I'm sure there are a lot of people who don't have the integration working.- Almac42Jul 11, 2023Brass Contributor
Strange -- I am using Ventura 13.4.1 & Excel 16.74 -- and having no problems. This may suggest that multiple reboots is the route to go.
- D0001Jul 11, 2023Brass ContributorThat’s great news. Are you in the US, and are you east, west coast, central, or mountain? Occasionally location can matter.