Forum Discussion
Stockhistory
Stockhistory repeats dates in stock data as file shows
The formula should typically include correct intervals.
=STOCKHISTORY(E5, E3, E4, 0, 1, 0, 2, 1)
Sometimes, Excel may have cached or incorrect formatting applied to cells.
Clearing formatting (Home > Clear > Clear Formats)
and then reapplying the STOCKHISTORY function might help.
Sometimes, stock exchanges don't have trading data for certain dates (e.g., holidays, weekends), which can cause gaps or repetitions in the data.
If the issue persists, you might consider pulling the data for smaller date ranges to see if the problem is consistent across all dates.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
