Google Finance - Stocks & Currency Exchange Data to a Spreadsheet - Google Sheets
HTML-код
- Опубликовано: 9 ноя 2020
- Learn how to get Google Finance stock market & currency exchange data to a Google Sheets spreadsheet using GOOGLEFINANCE function.
#stock #market #spreadsheet #google #finance
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 !!!
great vid mate
Excelent Thankssssssssssssssss
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.
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!
Do you know how do get data for "%change" 1hr & 24h by any chance ?
@@govind2783 That should help: support.google.com/docs/answer/3093281?hl=en
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 ?
Thanks for the super info. I can get Price/Earning ratio as =googlefinance(A2"pe").
How can I get Market Value/Book Value ratio?
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")
Any video your are gonna make about APPSHEET...
How to get currency open, High,low in Google sheets?
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.
sometimes if my syntax is not correct I get the same thing, it is possible that it is giving the wrong error message!
@@SnowHunter44 yeah.Agree. Suspect it is syntax. Will go try it again tho for my purposes the way I have it set up works fine
Are there any scripts that will let me import price data by minutes instead of days. Please help
Not from this function.
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.
Actually the only exchange that works for me is Nasdaq and I have to hard code the ticker
I have not had that problem - I always allow Google default and get "almost" any ticker.
@@SnowHunter44 gotta love computery stuff. It's always fun to see what happens
How to track DXY on google finance?
Try .DXY