💸 Your GOOGLEFINANCE Function Google Sheets Tutorial 💰 

Awesome to hear that!

Thank you!

the pleasure is ours!

Hi! Neither is available for stocks unfortunately. However, if you're interested in mutual funds, GOOGLEFINANCE supports an attribute 'incomedividend' which will give you the latest dividend amount for a fund. Check out all available attributes at support.google.com/docs/answer/3093281?hl=en

Hi! You'll want to use the following syntax: =GOOGLEFINANCE("ticker", "close", DATE(year, month, day)). For example: =GOOGLEFINANCE("AAPL", "close", DATE(2023, 3, 15)) If the stock market was closed on the chosen day, the function will return the close price for the next working day. If you have any other questions, feel free to ask :)

Unfortunately not. You can see all available attributes at support.google.com/docs/answer/3093281?hl=en

@@coupleracademy Thanks for the response. Google should really update these features. There is a lot that is missing!

Lovely to hear that, thanks! :)

Hi, can you elaborate? Which sheet do you want to load faster? When do you get N/As?

@@coupleracademy google finance sheet, I have added 500 stocks with different formula , it's take time to load and many shows N/A , if I referesh then sometime load all the data

could you elaborate please on which function you want to change? Maybe a reference to a specific timestamp in the video?

@@coupleracademy none of the functions used in 5.38-6.23 work for me

I think I fixed it by putting the funtion language to english

It doesn't seem to work for example eurusd

@@_matias_s7017 Gotcha, glad you resolved the issue. Enjoy the rest of the video!