Importing stock prices to excel data errors
Beginning 1 week ago stock price data downloaded to an excel spreadsheet started resulting in errors. Mainly double counting certain stock tickers which completely messed upset excel spreadsheets. PLEASE FIX ASAP
As another user already pointed out: Crypto prices when **downloaded** is not correct. Always the day before last is missing and all dates are shifted backwards.
The product support dismissed this user's feedback without understanding the feedback... :/
How to recreate:
1) Go to https://finance.yahoo.com/quote/BTC-USD/history?p=BTC-USD&guccounter=1
2) IMPORTANT: DOWNLOAD the data.
3) See how the day before last is apparently missing + all those dates before the last one are shifted by 1 day... (just download and see that CSV for yourself...)