Member: Almac42 | Microsoft Community Hub

Recent Discussions

Re: Excel's stock data type can't find several stock exchange indexes (i.e: FTSE, CAC 40, Hang Seng...)
leolapa Interesting. XAMS does not work for me.
Aug 09, 2023 Place Excel
15KViews
1like
0Comments
Re: Excel 365 Stock Data not updating all stocks
On the other discussion board I referenced someone had the same experience you just had. I don’t understand it but it seems to fix the problem.
Jul 11, 2023 Place Excel
1.9KViews
0likes
3Comments
Re: Excel 365 Stock Data not updating all stocks
Check out this other discussion “Stockhistory function is suddenly blocked”. There is mention of OneDrive as a work around. My Excel file is on OneDrive — this may be why I am not having issues.
Jul 11, 2023 Place Excel
2KViews
0likes
5Comments
Re: Excel 365 Stock Data not updating all stocks
The great white north (recently more “the great smoky north”) — Toronto
Jul 11, 2023 Place Excel
2KViews
0likes
7Comments
Re: Excel 365 Stock Data not updating all stocks
D0001 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.
Jul 11, 2023 Place Excel
2.1KViews
0likes
9Comments
Re: Excel 365 Stock Data not updating all stocks
Unfortunately the functionality is an after thought for MS. I have had the issue in the past.
Jul 11, 2023 Place Excel
1.3KViews
0likes
1Comment
Re: Excel 365 Stock Data not updating all stocks
16.74
Jul 11, 2023 Place Excel
1.4KViews
0likes
3Comments
Re: Excel 365 Stock Data not updating all stocks
I am running Ventura 13.4.1 and I am having no issues
Jul 11, 2023 Place Excel
1.4KViews
0likes
5Comments
Re: Excel's stock data type can't find several stock exchange indexes (i.e: FTSE, CAC 40, Hang Seng...)
it is quite frankly astounding the lack of proper usable documentation on the available securities/ furtures/ etc. Very frustrating needless to say.
Mar 30, 2023 Place Excel
17KViews
0likes
0Comments
Re: Excel Data - Stock - searching database / cannot find FTSE100 Index
I don't believe the FTSE100 is available -- very frustrating
Mar 30, 2023 Place Excel
499Views
0likes
0Comments
Re: Excel Stock Data not Loading
Yup -- the last 3 business days they have had issues -- before that it was great -- hopefully they resolve the issue soon
Mar 20, 2023 Place Excel
1.5KViews
0likes
0Comments
Re: Excel Stock Data not Loading
ARKF is last Friday's close
Mar 20, 2023 Place Excel
1.5KViews
0likes
2Comments
Re: Excel Stock Data not Loading
Interesting -- with my adjustment of 4/24 -- I get the correct EDT for AMD (on Nasdaq)
Mar 20, 2023 Place Excel
1.5KViews
0likes
4Comments
Re: Excel Stock Data not Loading
No, I adjust the cell by 4/24- so the formula is "[last trade time]-4/24"
Mar 20, 2023 Place Excel
1.6KViews
0likes
0Comments
Re: Excel Stock Data not Loading
Im in the eastern time zone -- I adjust all the times by 4 hours as they are GMT -- before the time change a week ago I adjusted all times by 5 hours
Mar 20, 2023 Place Excel
2KViews
0likes
10Comments
Re: Excel Stock Data not Loading
I don't believe dividends is one of the options available -- you can see all the options when you use the dropdown menu when clicking on the security
Mar 20, 2023 Place Excel
1.9KViews
0likes
0Comments
Re: Excel Stock Data not Loading
all but one of of my 50 plus securities is updating -- not sure why the one is not updating -- of course its my biggest holding
Mar 20, 2023 Place Excel
2KViews
0likes
2Comments
Re: Excel 365 Stock Data not updating all stocks
I deleted 16.71 and installed 16.69 on the advise of the MS Tech. It did not help.
Mar 17, 2023 Place Excel
2.8KViews
0likes
0Comments
Re: Excel 365 Stock Data not updating all stocks
had been on 16.71
Mar 17, 2023 Place Excel
9.5KViews
0likes
0Comments
Re: Excel 365 Stock Data not updating all stocks
downloaded Version 16.69 and still not working
Mar 17, 2023 Place Excel
9.4KViews
0likes
1Comment

User Profile

Almac42

User Widgets

Recent Discussions

Re: Excel's stock data type can't find several stock exchange indexes (i.e: FTSE, CAC 40, Hang Seng...)

Re: Excel 365 Stock Data not updating all stocks

Re: Excel 365 Stock Data not updating all stocks

Re: Excel 365 Stock Data not updating all stocks

Re: Excel 365 Stock Data not updating all stocks

Re: Excel 365 Stock Data not updating all stocks

Re: Excel 365 Stock Data not updating all stocks

Re: Excel 365 Stock Data not updating all stocks

Re: Excel's stock data type can't find several stock exchange indexes (i.e: FTSE, CAC 40, Hang Seng...)

Re: Excel Data - Stock - searching database / cannot find FTSE100 Index

Re: Excel Stock Data not Loading

Re: Excel Stock Data not Loading

Re: Excel Stock Data not Loading

Re: Excel Stock Data not Loading

Re: Excel Stock Data not Loading

Re: Excel Stock Data not Loading

Re: Excel Stock Data not Loading

Re: Excel 365 Stock Data not updating all stocks

Re: Excel 365 Stock Data not updating all stocks

Re: Excel 365 Stock Data not updating all stocks

Recent Blog Articles