Numbers Fails To Fetch Market Data

[Geepaw]

I have a various spreadsheets set up to track investment performance. I use a default date, which I can plug in any date the market was open, and it will fetch stock prices for that day. However, when I plug in yesterday's date, which is supposed to fetch closing prices, it fails to populate the data. I think the data comes through from Yahoo Finance (maybe it has been changed), but Yahoo Finance is updated correctly. I also had an issue yesterday where it would not fetch company names during market hours. This is pretty a pretty big fail in my opinion and I never experienced it before using Numbers. What is going on with Numbers? Any ideas?

 

[Geepaw]

Both STOCKH and STOCK in Numbers function are still totally busted for me. Neither will populate data a day and half after the close. Specifically, it will not fetch data from Friday's market close. It is Sunday today. This is very disappointing. I never had this problem with Excel. In fact, I never had it with Numbers before. If I cannot look at the closing prices over the weekend I guess it's time to start looking for alternative software. Any suggestions other than Excel? I need it to be able to fetch stock market data.