ฝัง
- เผยแพร่เมื่อ 31 ม.ค. 2021
- In this tutorial, I am going to cover how we can retrieve live stock data in Google Sheets using the GOOGLEFINANCE function.
Google Sheets has a built-in function called GOOGLEFINANCE which fetches current or historical securities information from Google Finance platform. Instead of paying $15 to $20 for a 3rd party subscription service to access different finance data, Google Sheets's GOOGLEFINANCE function makes the information available for FREE.
📑 GOOGLEFINANCE function doc: support.google.com/docs/answe...
📑 Supported Exchanges: www.google.com/googlefinance/...
Related videos:
----------------------------
How to get Live Stock Price in Google Sheets: • How to get Live Stock ...
How to retrieve Historical Stock Price Information in Google Sheets: • How to retrieve Histor...
How to auto refresh stock price in Google Sheets: • How to auto refresh st...
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: join.robinhood.com/jiej6
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter: / jiejenn
🛒 By shopping on Amazon → amzn.to/2JkGeMD
🗓 Get updated on new Python videos → / madeinpython
📘 More tutorial videos on my website → LearnDataAnalysis.org
📺 Also check out my 2nd channel Excel channel focus on sharing Excel tips: bit.ly/3B1DjSA
✉ Business Inquiring: TH-cam@LearnDataAnalysis.org
#StockData #GoogleFinance #GoogleSheets
Thanks for the excellent explanation and for having a good microphone. You're the best.
Awesome video I was hitting my head to get the exact formula finally got it right. Thanks 🙏🏻
Awesome!! New to all of this my first sheet!
Bro, you are a genious! I loved this tutorial. Straight to the point.
Very helpful. Thank you.
Great video! Thanks!
Thanks for the info! It was really useful.
Glad the video helped.
@@jiejenn gGr8 video. Is there any way we can get weekly OHLC price. Trying to create a system based on weekly price action.
awesome content very easy !
Absolutely loved it, thanks man.
Awesome.
Dear Jie Jenn, nice video👍. Thanks for sharing.
Here, I would like to get set of stocks high and low price for the given date's. For example- FB, Google, apple, Amazon & micro soft. I need to get data from 2nd August 2021 to 15th August 2021. Thanks.
You can reference this video th-cam.com/video/0tquofL8F7w/w-d-xo.html.
Nice video, does this work the same for currency pairs?
I tried but I got an error from "parameter 2" when using a pair and trying to get the "high, low, close" etc
maybe because the markets are closed?
I am not 100% sure if currency pairs are supported by the backend currently. I am hoping Microsoft will add the feature in the future.
I'm having an issue visualising a ticker from the TSX. Is there a way to fix this or I just need to use a different formula? the ticker is CNR. tks JIE JENN
Here you go. =GoogleFinance("TSE:cnr", "price"). I have still yet to figure out how I can copy the ticker from a column into this formula. Frustrating to say the least.
Sir I want today to last 20 days stock price only how type it
Good Day, Sir.
May i ask you a question?
🙏
List of Stock Prices (Monthly/Daily/Weekly Closing Price) on Google Finance Indonesia, the last one is only until July 1, 2022, right?
How come today (September 18, 2022) does not appear?
Thank you
=googlefinance(concatenate("IDX:";"TLKM");"price";DATE(2022;1;1);DATE(2022;12;31);"WEEKLY")
The result is different with this function :
=googlefinance(concatenate("NYSE:";"UNVR");"price";DATE(2022;1;1);DATE(2022;12;31);"WEEKLY")
Nice video. Is there a way to pull data for ES mini Future?
I am not familiar with ES mini feature unfortunately.
Why dosnt it work on norwegian stocks?
Thanks for the good video tutorial!
How can i get the Bitcoin price? I tried BTC, BTC-USD... but i couldn't get the price.
Thank for your answer
To retrieve Bitcoin price, try =GOOGLEFINANCE("BTCUSD")
@@jiejenn Worked for BTC but not for ADA, CAKE and other coins 🤔
You pull option price In here ? By date?
I don't think option price is available.
I just get N/A Error
Function GOOGLEFINANCE parameter 1 value is invalid.. What am I doing wrong?
Wow I had no idea about this function. Thanks! Do you know why crypto tickers like BTC-USD don't return any data? Any way to get crypto info with this function?
You need to remove the dash. The ticker would be "BTCUSD".
@@jiejenn thanks for the reply. That didn't work for me... Still get an error: #N/A
Paste your formula here.
@@jiejenn =GOOGLEFINANCE("BTCUSD","price")
@@siddhartha_1 Ah I see. I think GOOGLEFINANCE function treats cryptocurrencies a bit differently. Remove attribute should work. For example, =GOOGLEFINANCE("BTCUSD")
Is the historical price data accurate? Other than the weekends and holidays, it seems as if some of data is omitted. Why is that so? Thx
Data is directly coming from the exchange. I don't know why some of the data is omitted, maybe contact Google support for your question.
@@jiejenn Thx for responding, my friend.
I was attempting to pull up the entire month of January 2015 of SPX Flow Inc. I saw the opening price which began on the 2nd. What I didn't see was the closing of that month which should have been on the 30th, the last day of that month that the market was opened for that month of January 2015. I assume it is one or the other: I am looking at it wrong or such data is omitted. What I do not know. Totally confused. Please help if u can. Thx
i need google live price in excel not sheet
Anyone knows if this works for TO stocks? (Toronto Canada)
Looks like it is supported www.google.com/googlefinance/disclaimer/
Sir can we get real time data without any delay
Don't think this is something you can control. Perhaps looking into paid services.
Today (12 March 2021) Googlefinance has stopped working. I have tried your work arounds but they don't work. Any suggestions?
Looks like there is something going on with Google Finance API. Give a few hours then try again.
Very very help full, happy new year 20257
Hm. It shows N/A instead of a price even on Google Doc Help page.
It is working for me.
@@jiejenn in non trading hours too?
@@ayzv8301 Google Finance engine is down as of now. Following Twitter #GoogleFinance
Using , didn't work i had to use ;
thank you. didnt work for me either
How can i add shib inu
I will cover that next week.
Hi, do you sell any of your tools that you have created? I would like to be able to extract youtube comments... Plug and play I don't want to learn code just to have this tool. Would be great if you could make this available to buy. Thanks
I built something awhile ago for myself specifically to view all TH-cam video's comments in a single view. Here's the demo th-cam.com/video/sNMXeacrgSw/w-d-xo.html. Is this is something you are looking for?
@@jiejenn hello thanks for your reply Jie. Yes that would be great, if it could output to CSV. How do I go about using this please?
If you want to export comments to a CSV file, basically I just have to modify my script to output the comments to a CSV file. Email me your requirement at TH-cam@LearnDataAnalysis.org so I can get an idea what you are trying to do.
How can I download a copy of this template?
Bro do it youself, it will take you literally 5 min to build
i needed too
@@carlosrizoromero1334 gives me #N/A when following these exact instructions
If the price has a 20 minute delay then how is that a “live price”? I need a real time price updated within minutes.
Please bring up this issue with Google. (I believe it is up to 20 minutes delay occasionally)
do you know how to get data from non-us market for example BBCA.JK
You can check the available exchange at www.google.com/googlefinance/disclaimer/