kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 951
- Office Version
- 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 ?
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 |