Data Connection Error Message

[kumara_faith]

Hi,

I have a list of stocks in a table which In have used the Data and then Stocks function so that I can refresh the current prices. It was working for a year but today when I tried, it returned the following message. How do I know which data is refreshed and which data Microsoft has removed from their side ?

Lifetime Planner_2022 v1.0.xlsx
	F	G
5	AMAZON.COM, INC. (XNAS:AMZN)	113.00
6	APPLE INC. (XNAS:AAPL)	138.20
7	ALPHABET INC. (XNAS:GOOGL)	95.65
8	MICROSOFT CORPORATION (XNAS:MSFT)	232.90
9	Direxion:Hlthcre Bull 3X (ARCX:CURE)	84.44
10	MICROSOFT CORPORATION (XNAS:MSFT)	232.90
11	ALPHABET INC. (XNAS:GOOGL)	95.65
12	MICROSOFT CORPORATION (XNAS:MSFT)	232.90
13	ALPHABET INC. (XNAS:GOOGL)	95.65
14	ALPHABET INC. (XNAS:GOOGL)	95.65
15	AMAZON.COM, INC. (XNAS:AMZN)	113.00
16	AMAZON.COM, INC. (XNAS:AMZN)	113.00
17	MICROSOFT CORPORATION (XNAS:MSFT)	232.90
18	AMAZON.COM, INC. (XNAS:AMZN)	113.00
19	STORE CAPITAL CORPORATION (XNYS:STOR)	31.33
20	MICROSOFT CORPORATION (XNAS:MSFT)	232.90
21	DIGITAL REALTY TRUST, INC. (XNYS:DLR)	99.18
22	MICROSOFT CORPORATION (XNAS:MSFT)	232.90
23	MICROSOFT CORPORATION (XNAS:MSFT)	232.90
24	MICROSOFT CORPORATION (XNAS:MSFT)	232.90
25	ALPHABET INC. (XNAS:GOOGL)	95.65
26	MICROSOFT CORPORATION (XNAS:MSFT)	232.90
27	MICROSOFT CORPORATION (XNAS:MSFT)	232.90
28	BLACKROCK, INC. (XNYS:BLK)	550.28
29	ALPHABET INC. (XNAS:GOOGL)	95.65
30	DIGITAL REALTY TRUST, INC. (XNYS:DLR)	99.18
31	MICROSOFT CORPORATION (XNAS:MSFT)	232.90
32	ProShares:UltP Dow30 (ARCX:UDOW)	38.61
33	ALPHABET INC. (XNAS:GOOGL)	95.65
34	ProShares:UltP Dow30 (ARCX:UDOW)	38.61
35	AMAZON.COM, INC. (XNAS:AMZN)	113.00
36	AIRBNB, INC. (XNAS:ABNB)	105.04
37	ALPHABET INC. (XNAS:GOOGL)	95.65
38	AIRBNB, INC. (XNAS:ABNB)	105.04
39	ProShares:UltP Dow30 (ARCX:UDOW)	38.61
40	BANK OF AMERICA CORPORATION (XNYS:BAC)	30.20
41	BANK OF AMERICA CORPORATION (XNYS:BAC)	30.20
42	NVIDIA CORPORATION (XNAS:NVDA)	121.39
43	Direxion:Finl Bull 3X (ARCX:FAS)	54.21
44	Alibaba Group Holding Limited (XNYS:BABA)	79.99
45	Alibaba Group Holding Limited (XNYS:BABA)	79.99
46	Alibaba Group Holding Limited (XNYS:BABA)	79.99
47	SNOWFLAKE INC. (XNYS:SNOW)	169.96
48	Meta Platforms, Inc. (XNAS:META)	135.68
49	Meta Platforms, Inc. (XNAS:META)	135.68
50	Meta Platforms, Inc. (XNAS:META)	135.68
51	Meta Platforms, Inc. (XNAS:META)	135.68
52	Meta Platforms, Inc. (XNAS:META)	135.68
53	Meta Platforms, Inc. (XNAS:META)	135.68
54	Meta Platforms, Inc. (XNAS:META)	135.68
55	Meta Platforms, Inc. (XNAS:META)	135.68
56	Direxion:Cons Dis BL 3X (ARCX:WANT)	23.46
57	Direxion:Semicnd Bull 3X (ARCX:SOXL)	8.84
58	ProShares:UltPro S&P500 (ARCX:UPRO)	28.41
59	ProShares:Bitcoin Strat (ARCX:BITO)	11.99
60	ZOOM VIDEO COMMUNICATIONS, INC. (XNAS:ZM)	73.59
61	ZOOM VIDEO COMMUNICATIONS, INC. (XNAS:ZM)	73.59
62	ProShares:UltP QQQ (XNAS:TQQQ)	19.32
63	ProShares:UltP QQQ (XNAS:TQQQ)	19.32
Stock Trading Journal

Cell Formulas
Range	Formula
G5:G63	G5	=F5.Price

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G58:G63	Cell Value	<H58	text	NO
G58:G63	Cell Value	>H58	text	NO
G5:G57	Cell Value	<H5	text	NO
G5:G57	Cell Value	>H5	text	NO