I made a Python code to get yahoo finance yields to excel file. I use this to manually update my Google sheets that I use to track my portfolio.
The code is in zip package with instructions included.
Folder is also editable so you can leave your modifications there.
I need yields to estimate average monthly dividends.
Edit: due to popular demand, the code is now available at git hub. Please put your contributions there if you like to improve this:
Keep on investing!