Forum Discussion
#CONNECT! Error - Stockhistory down?
J_Woolley still having issues with the correct data coming in, it just repeats itself before it completes the data. For example, MSFT will give me the proper OHLC data starting at 3/13/1986 to 7/22/2010 then it goes back to 3/13/1986. Then the second time around it makes it to 4/15/1994 before resetting to 3/13/1986 again. This keeps repeating over and over again until it can get a full set of data from 3/13/1986 to today. Without these repeating sets, the data should only be around 9,700 rows, but the way it repeating incomplete sets of data, it now has 50,650 rows before it finally reaches the correct end date.
I’ve tried checking for updates, logging out, restarting, logging in a bunch of times. Even tried upgrading and downgrading from Preview, to Beta, to nothing and the results remain the same. Don’t think it’s anything on our end. Has to be a problem from Microsoft itself. Hopefully this resolved by Monday before markets open.
- Are you using Excel version 2408?
- I’m using version 2409. Should I go back to 2408?
- i'm using 2408 ok,
- Suspect you are in uncharted waters compared to most on this thread. I’m pulling the last 70 days of data - so I’m in no way stressing the system back to the 80s. You’ll likely need to create a ticket with Microsoft to ensure that they are aware. They may have a false belief that the issue is solved since it’s working for near-term dates. Good luck!
- I'm pulling data back to 2004 so about 20 years, and having issues, but it's also about 200 different stocks....
