No. of Recommendations: 4
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.
No. of Recommendations: 5
I have used the STOCKHISTORY function in Excel 365. It is perfectly straight-forward, and anyone capable of what you just described will find it trivially easy to use. I learned about it from this site:
https://www.thespreadsheetguru.com/blog/excel-stoc...STOCKHISTORY can download open, high, low, close, and volume, but not Yahoo's "adjusted close," which comes closest to the "g-price" used in GTR1. Why the Excel people would skip over this readily available and obviously valuable data is a mystery to me.
Baltassar
No. of Recommendations: 1
Yes, Strimpel's tool is excellent, and it does include the "adjusted close," which is what I use for calculating RRS.
Baltassar
No. of Recommendations: 2
Thank you for the suggestions!
I have something that kind of resembles Y! portfolio tracker, so this actually ended up working for me:
https://support.microsoft.com/en-us/office/get-a-s...Last I checked, my macro was working again. Don't know how long that will hold up.
Thanks,
John
No. of Recommendations: 0
Robbie's spreadsheet.
Elan,
can you point me to the source for Robbie's spreadsheet?
Thanks.
