I have two problems with tracking the AMD stock using Excel STOCKHISTORY using this formula:
=STOCKHISTORY("AMD","10/14/2024","10/23/2024")
I get the same erroneous results if I use Excel Online.
The equivalent Google Sheets function:
=GOOGLEFINANCE("AMD","close","10/14/2024","10/24/2024")
works fine
Any ideas why it is wrong?
I am using Excel 365, Version 2409, Built 18025.20160
You need to specify the exchange for this instrument:
=STOCKHISTORY("XNAS:AMD","10/14/2024","10/23/2024")
The documentation now indicates that the data will be pulled from "from the default exchange for the instrument", but it does not indicate how that default exchange is determined.