Great video. Do you know how to pull a stocks total debt from either google finance or yahoo? I'm looking to create a calculation for total debt divided by market cap.
Do you know if there is any automatism, which makes it possible to download the ticker symbol from ones country's stock market by default? So far I have handled the conversion with a USD/EUR Formula. For instance I live in Germany and trade with US stocks, bought at XETRA, SWB, FRA, ... If I bought US stocks directly at US stock exchanges, it would have cost me way more transactions fees.
I have been looking at google sheets youtubes where they pull in data or pull in information using the googlefinance function and would like to find a way to pull in the 52 week high and low for every day in the last year but haven't found anyone that can tell me how to do it. I have an idea and need that information. I am sure that is out there but all I have found is a way to pull in the high low and close for a day not the 52 week high and low for that day. I was looking at your video and thought it might have a way to do it but haven't figured out how to do it. Have you any suggestions on how to do so?
I am attempting to use your Master Portfolio tracker but with both stocks in CAD and USD. The issue is, in the history tab there is nothing that distinguishes buying/selling a stock for USD or CAD when you put the price in. Even if you convert manually to one or the other (CAD or USD), the many other fields in the sheet that use these inputted prices may be off and give incorrect portfolio quantities due to the currency conversion. Can you make a quick vid or perhaps help the many others like myself who want to use you Master tracker but work with stocks in various currencies? I cannot seem to figure out how to fix it.
Im currently in the middle of making a major update for the master portfolio tracker to account for currency conversion, splits, and and cryptos! So you will have that soonish!
@@ThinkStocks Excuse-me, last question, how do we put the dividends in the section " History " ? Me, it's lowering my average cost for the stock, is it normal ?
I managed to get sector/industry/country data from finviz, but only all three together and made them automatically separated into 3 columns. Posted the code in the comment above, if needed. The author also showed in one of the videos how to pull the industry from some other site (don't remember which one though, watched a bunch of them in a row and they all mixed up in my head)
It seems … in LON the stock price is in PENNY(GBX), not POUND(GBP) In foreign exchange, there is only USDGBP, but no USDGBX So, googlefinance(currency, usdgbp) works, but googlefinance(currency, usdGBX) doesn’t.
Thanks for that information! Still learning about all the international exchanges, and the proper politics of the world when it comes to the global market!
Thank you. Fantastic video.
Are there any updates this year on how to obtain live Dividend and Dividend Yield using Google Finance into Google Sheets?
Good stuff! Thanks for all your hard work on this informative tutorial, you are a Gentleman and a scholar....
I appreciate that!
Great video. Do you know how to pull a stocks total debt from either google finance or yahoo? I'm looking to create a calculation for total debt divided by market cap.
Thanks bro for spending time to do all this ❤️
Do you know if there is any automatism, which makes it possible to download the ticker symbol from ones country's stock market by default?
So far I have handled the conversion with a USD/EUR Formula.
For instance I live in Germany and trade with US stocks, bought at XETRA, SWB, FRA, ... If I bought US stocks directly at US stock exchanges, it would have cost me way more transactions fees.
Wonderful presentation
Thanks for the tips
I have been looking at google sheets youtubes where they pull in data or pull in information using the googlefinance function and would like to find a way to pull in the 52 week high and low for every day in the last year but haven't found anyone that can tell me how to do it. I have an idea and need that information. I am sure that is out there but all I have found is a way to pull in the high low and close for a day not the 52 week high and low for that day. I was looking at your video and thought it might have a way to do it but haven't figured out how to do it. Have you any suggestions on how to do so?
Hey bro. Thank you for very useful video. How about Vietnam market?
Is there any way to get data on stocks on the Singapore Exchange?
How about Singapore reits (stocks)? it did not work for SGX
Cool! but it still can't pull Singapore stocks in, I don't know why.
I am attempting to use your Master Portfolio tracker but with both stocks in CAD and USD. The issue is, in the history tab there is nothing that distinguishes buying/selling a stock for USD or CAD when you put the price in. Even if you convert manually to one or the other (CAD or USD), the many other fields in the sheet that use these inputted prices may be off and give incorrect portfolio quantities due to the currency conversion. Can you make a quick vid or perhaps help the many others like myself who want to use you Master tracker but work with stocks in various currencies? I cannot seem to figure out how to fix it.
Im currently in the middle of making a major update for the master portfolio tracker to account for currency conversion, splits, and and cryptos! So you will have that soonish!
Good video ! I have a problem, my price and everything link to that is disappearing with an error text : Loading Data
What can I do ? Thank you
Did you try refreshing the page? Sometimes Google finance is a little laggy
@@ThinkStocks Yes thank you, it's disappearing and appearing without stopping .-. Hope it will stop ;)
@@ThinkStocks Excuse-me, last question, how do we put the dividends in the section " History " ? Me, it's lowering my average cost for the stock, is it normal ?
Yeah, the dividend part stops me from using google sheets to build tracking. I need that .
How do you pull exchange information?
We need float information as well
Yes, why dont they have dividend data!!
Many Thanks.............
what about AMEX?
Great stuff! They still don't pull in industry either.
I managed to get sector/industry/country data from finviz, but only all three together and made them automatically separated into 3 columns. Posted the code in the comment above, if needed.
The author also showed in one of the videos how to pull the industry from some other site (don't remember which one though, watched a bunch of them in a row and they all mixed up in my head)
It seems … in LON the stock price is in PENNY(GBX), not POUND(GBP)
In foreign exchange, there is only USDGBP, but no USDGBX
So, googlefinance(currency, usdgbp) works, but googlefinance(currency, usdGBX) doesn’t.
I know, makes no sense either. Luckily I made a work around formula to convert the LON stocks into GBP. That video will drop tomorrow at 9am EST!
👍🏻
Cannot get the funds from google finance as well.
Which funds are you trying to get?
Great tutorial, but google finance appears to be the least friendly way to find a stock.
Nice vid. Just something political. Hong Kong is not China.
Thanks for that information! Still learning about all the international exchanges, and the proper politics of the world when it comes to the global market!
Hong Kong is not China....but politically it's getting closer.
Currently, not even the currency of a share can be requested in London:
=GOOGLEFINANCE("LON:BATS";"currency")