Google Finance - Stocks & Currency Exchange Data to a Spreadsheet - Google Sheets

Learn how to get Google Finance stock market & currency exchange data to a Google Sheets spreadsheet using GOOGLEFINANCE function.

#stock #market #spreadsheet #google #finance

[KiRita]

Finally, this channel is getting the acknowledgement it deserves.

[garychadwick]

Oh what I would have given for this help 3 months ago. Thanks as always for another excellent video. 👌🏻

[davidfernandezbajo]

Thank you a lot for sharing your knowledge!

[SnowHunter]

I was hoping there was a way to compare fresh data with the previous period - ie current minus "datadelay" to track a trailing stop, any thoughts?...Great series of videos, saves me a ton of time "experimenting". Thanks for a job well done.

[CaribouDataScience]

How can I pull download the daily number for the Dow Jones?

[JBblondin]

And it works for crypto currencies, like BTCUSD, that is what I was looking for.
Thank you, what a gain of time it will be!

[vishey]

Any video your are gonna make about APPSHEET...

[noahcyr]

Is it possible to pull Live US Treasury yields into google sheets? for 1month-10 year?

[s_kids_lifestyle]

How to get currency open, High, low in Google sheets?

[samsunpen]

Hey how do you do TSXV in google sheets?

[papijelly]

Thanks for the info. I am looking to plot/scrape(html) a chart in years the shares outstanding and total liabilities of as company for the lasts five years if that makes sense. Does anyone know the formula to use

[anthonychung]

GoogleFInacne, do not have stock open price ?

[alisaimdegerli]

Thanks for the super info. I can get Price/Earning ratio as =googlefinance(A2"pe").
How can I get Market Value/Book Value ratio?

[al.istitsmaar]

This function is no longer available since July 1, 2022 in Indonesia. Please help, is there something wrong with the formula used?

[kellypurdue]

Having trouble with specifying the exchange. Checked with Google support and looked at the exchanges supported but get an error message, either the ticket or the reference cell where the ticket resides comes back unrecognized.

[jituteron]

Are there any scripts that will let me import price data by minutes instead of days. Please help

[kellypurdue]

Actually the only exchange that works for me is Nasdaq and I have to hard code the ticker

[KalinkaBg]

Hello, nice video. It did help me somewhat. I am facing an issue with the google finance function to grab the exchange and the ticker. For example my spreadsheet is very dynamic. So I have . Which works great if the ticker is in CVE. However, the moment I insert a new line somewhere in my spreadsheet, the next ticker to be in A12 no longer comes from CVE. Now it comes from TSE. So of course I get an error. I hope I am making myself clear. Can you help me please. How can I automate and make dynamic the part in the quotes that specifies CVE or TSE or NASDAQ. Any suggestion will be appreciated. Thank you.