MrAnalyst22
New Member
- Joined
- Jun 25, 2022
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Anyone really familiar with =STOCKHISTORY? Trying to pull data for SMB (VanEck Vectors Short Muni ETF) and for some reason I am getting results in euros, prices don't match a separate market tool I'm using to look at historical prices. I'm just trying to pull ~400 days of trading data, and it's been around for quite some time, so I don't believe it's an issue with data availability.
Formula: =STOCKHISTORY("SMB",DATE(2020,11,18),DATE(2022,6,25))
Anyone able to replicate my result and provide some information on what's going on? I can only assume it's pulling a european stock with the symbol SMB, but I'm unsure of how to fix it. Seems to have worked just fine for everything else I've used.
Thanks in advance!!
Formula: =STOCKHISTORY("SMB",DATE(2020,11,18),DATE(2022,6,25))
Anyone able to replicate my result and provide some information on what's going on? I can only assume it's pulling a european stock with the symbol SMB, but I'm unsure of how to fix it. Seems to have worked just fine for everything else I've used.
Thanks in advance!!