Forum Discussion
Using StockHistory feature in Excel
Using the StockHistory feature in Excel, is there a way to get data that has been adjusted for stock splits, dividends, and distributions? Thank you in advance!
3 Replies
I just remembered that SCHD "Schwab U.S. Dividend Equity ETF" did a stock split on Oct 11, 2024 (3 for 1). When I look at the price history, it seems to handle this properly. I've got several iShares ETF's that split last Friday and the splits are not being reflected properly in the price history. I'm hoping this is just a matter of time for things to update.
Nope, it gives what it gives, no other options.
Is this forever? I've been tracking some ETF's e.g. XLU ishares Sector Utilities ETF just split. The history just shows the closing price unadjusted for the split. Is it going to stay that way or will they eventually get around to fixing it?
