How to Get STOCK PRICE DATA, FOR FREE, Using Google Finance (Google Sheets)

[@patrickmccarten2144]

This was very helpful, I am leaving Excel 360 and I miss the automatic stock data lookup in Excel. Sheets does not return as many parameters as Excel e,g, for mutual funds like "Net Assets", "Expense Ratio". It will return some figures when you swap "price" for "netassets" in your formula but the result is not correct. Any ideas?

[@MoneywithPennies]

Hi Patrick, I have not used it for mutual funds so I don't think I can provide you with any explanation for why it does not show the correct numbers. Sometimes there are delays for when numbers are updated. I don't know what you are comparing with but maybe one source updates the numbers more or less regularly than google. (For example google has a 15 min delay on stock price data I believe.) In this case it would be only a small difference in most cases. Sorry I could not provide a better solution.

[@nichodemus3697]

hello, i have a concern is it possible to get each weekly high and low price with google sheet?

[@MoneywithPennies]

Yes

[@nichodemusngao2237]

@@MoneywithPennies how. Can i go about it, or would you mind creating educational video on the same?

[@R.and.R.]

This is awesome! Thanks!

[@MoneywithPennies]

I'm so glad you liked it. =) Did you grab the free copy?

[@R.and.R.]

@@MoneywithPennies I added it to my current Google sheets!

[@DafyddMorse]

This is pretty cool! 😎

[@MoneywithPennies]

Hi, good to see you again. =) Of course, this is just the tip of the iceberg on what you can really do.

[@nichodemus3697]

"Is it possible to retrieve the weekly high and low prices for a stock or cryptocurrency using Google Sheets?"

[@MoneywithPennies]

Yes, if you specify a time interval adn write "Weekly" you should be able to get the weekly prices. Instead of price you write "high" or "low".