How to get Yahoo Finance Data in Google Sheets!
視聴回数 80,271 回
0
0
Get Stock Data directly in your sheets: https://tickerdata.com/
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!
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.
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!
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.
