Data Connection Error Message

kumara_faith

Well-known Member
Joined
Aug 19, 2006
Messages
951
Office Version
  1. 365
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
FG
5AMAZON.COM, INC. (XNAS:AMZN)113.00
6APPLE INC. (XNAS:AAPL)138.20
7ALPHABET INC. (XNAS:GOOGL)95.65
8MICROSOFT CORPORATION (XNAS:MSFT)232.90
9Direxion:Hlthcre Bull 3X (ARCX:CURE)84.44
10MICROSOFT CORPORATION (XNAS:MSFT)232.90
11ALPHABET INC. (XNAS:GOOGL)95.65
12MICROSOFT CORPORATION (XNAS:MSFT)232.90
13ALPHABET INC. (XNAS:GOOGL)95.65
14ALPHABET INC. (XNAS:GOOGL)95.65
15AMAZON.COM, INC. (XNAS:AMZN)113.00
16AMAZON.COM, INC. (XNAS:AMZN)113.00
17MICROSOFT CORPORATION (XNAS:MSFT)232.90
18AMAZON.COM, INC. (XNAS:AMZN)113.00
19STORE CAPITAL CORPORATION (XNYS:STOR)31.33
20MICROSOFT CORPORATION (XNAS:MSFT)232.90
21DIGITAL REALTY TRUST, INC. (XNYS:DLR)99.18
22MICROSOFT CORPORATION (XNAS:MSFT)232.90
23MICROSOFT CORPORATION (XNAS:MSFT)232.90
24MICROSOFT CORPORATION (XNAS:MSFT)232.90
25ALPHABET INC. (XNAS:GOOGL)95.65
26MICROSOFT CORPORATION (XNAS:MSFT)232.90
27MICROSOFT CORPORATION (XNAS:MSFT)232.90
28BLACKROCK, INC. (XNYS:BLK)550.28
29ALPHABET INC. (XNAS:GOOGL)95.65
30DIGITAL REALTY TRUST, INC. (XNYS:DLR)99.18
31MICROSOFT CORPORATION (XNAS:MSFT)232.90
32ProShares:UltP Dow30 (ARCX:UDOW)38.61
33ALPHABET INC. (XNAS:GOOGL)95.65
34ProShares:UltP Dow30 (ARCX:UDOW)38.61
35AMAZON.COM, INC. (XNAS:AMZN)113.00
36AIRBNB, INC. (XNAS:ABNB)105.04
37ALPHABET INC. (XNAS:GOOGL)95.65
38AIRBNB, INC. (XNAS:ABNB)105.04
39ProShares:UltP Dow30 (ARCX:UDOW)38.61
40BANK OF AMERICA CORPORATION (XNYS:BAC)30.20
41BANK OF AMERICA CORPORATION (XNYS:BAC)30.20
42NVIDIA CORPORATION (XNAS:NVDA)121.39
43Direxion:Finl Bull 3X (ARCX:FAS)54.21
44Alibaba Group Holding Limited (XNYS:BABA)79.99
45Alibaba Group Holding Limited (XNYS:BABA)79.99
46Alibaba Group Holding Limited (XNYS:BABA)79.99
47SNOWFLAKE INC. (XNYS:SNOW)169.96
48Meta Platforms, Inc. (XNAS:META)135.68
49Meta Platforms, Inc. (XNAS:META)135.68
50Meta Platforms, Inc. (XNAS:META)135.68
51Meta Platforms, Inc. (XNAS:META)135.68
52Meta Platforms, Inc. (XNAS:META)135.68
53Meta Platforms, Inc. (XNAS:META)135.68
54Meta Platforms, Inc. (XNAS:META)135.68
55Meta Platforms, Inc. (XNAS:META)135.68
56Direxion:Cons Dis BL 3X (ARCX:WANT)23.46
57Direxion:Semicnd Bull 3X (ARCX:SOXL)8.84
58ProShares:UltPro S&P500 (ARCX:UPRO)28.41
59ProShares:Bitcoin Strat (ARCX:BITO)11.99
60ZOOM VIDEO COMMUNICATIONS, INC. (XNAS:ZM)73.59
61ZOOM VIDEO COMMUNICATIONS, INC. (XNAS:ZM)73.59
62ProShares:UltP QQQ (XNAS:TQQQ)19.32
63ProShares:UltP QQQ (XNAS:TQQQ)19.32
Stock Trading Journal
Cell Formulas
RangeFormula
G5:G63G5=F5.Price
Cells with Conditional Formatting
CellConditionCell FormatStop If True
G58:G63Cell Value<H58textNO
G58:G63Cell Value>H58textNO
G5:G57Cell Value<H5textNO
G5:G57Cell Value>H5textNO



1664803021592.png
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top