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

Finally, this channel is getting the acknowledgement it deserves.

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

Thank you a lot for sharing your knowledge!

Thank you!

Thanks !!!

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.

great vid mate

Excelent Thankssssssssssssssss

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

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!

Any video your are gonna make about APPSHEET...

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

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

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

Hey how do you do TSXV in google sheets?

GoogleFInacne ,do not have stock open price ?

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

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

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.

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 =GOOGLEFINANCE(CONCATENATE("CVE:"&A12)) . 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.

How to track DXY on google finance?

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

This function is no longer available since July 1, 2022 in Indonesia. Please help, is there something wrong with the formula used? =googlefinance(concatenate("IDX:";"ACES");"price";DATE(2022;1;1);DATE(2022;12;31);"WEEKLY")