Formula to get price from Yahoo finance into Google Sheets:
=IMPORTXML(“https://finance.yahoo.com/quote/”&B2,”/html/body/div[1]/div/div/div[1]/div/div[2]/div/div/div[5]/div/div/div/div[3]/div[1]/div[1]/fin-streamer[1]”)
In this video, I take you step by step on how to pull yahoo finance data into google sheets. This is an extremely useful method, and can be used to be to create phenomenal spreadsheets.
Let me know if you have any questions!
Link to download my portfolio tracking spreadsheets:
https://www.patreon.com/dividendology
Get 50% off of Seeking Alpha Premium!
https://www.sahg6dtr.com/9D5QH2/R74QP/
Follow me on Twitter: https://twitter.com/dividendology
Join my Discord! https://www.patreon.com/dividendology
I am not a Financial advisor or licensed professional. Nothing I say or produce on YouTube, or anywhere else, should be considered as advice. All content is for educational purposes only. I am not responsible for any financial losses or gains. Invest and trade at your own risk.
Source