Anyone else still use excel to download stock data from Y!?

For 20+ years I have been making periodic changes, which I have shared w/ this board (on MF), to a macro originally written by John Meyer in 1999. I think it was 2017 when I did a major rework, switching over to JSON (I learned about JSON just to fix the issue). I seem to have made a small change in 2019, but it's worked since then.

Yesterday it gave me an error message: "Type mismatch".
Closing are reopening the workbook fixed the issue, but it returned today.

Wondering what the path of least resistance is. It appears MS has incorporated the ability to download stock data (I just need price and daily %change) into Excel 365, which I have. Has anyone used this? Or does anyone have a working macro? The only time I do VB programming is these fixes, so it's always a slow process since I need to relearn what I forget.

I like to do some things with portfolio tracking that makes it nice to have it in my own spreadsheet.

Thanks for any input.

Mechanical Investing FAQ

---

Contact Shrewd'm
Contact the developer of these message boards.