Calculate Monthly Stock Returns and Identify Trends in Google Sheets

[@idontlikeyouyo]

Thank you very much. This is great information to learn.

[@RobertCarlson-fs4gg]

In the IFstatement for the date are you using an asterisk? I could not get that to work. I got an error message, so I deleted the if statement.

[@RobertCarlson-fs4gg]

Please post the formula for the if statement for the date and the formula that calculates the monthly returns. I spent hours replaying the video, and I could not get it to work. I am hoping to copy and paste the formulas. Thank you!

[@h2e]

Here is a file that does this for the S&P 500 returns. If you're getting an error it may be how you are formatting your months/dates. docs.google.com/spreadsheets/d/1qv02ERBefJg0Ik_KxSUobQsEi8YBxudSX1MeU1_6tgg/edit?usp=sharing

[@RobertCarlson-fs4gg]

Thank you so much. This is great!!

[@Raju-dd5bi]

Great Video,. Thanks man.

[@idontlikeyouyo]

Hey, would it be possible to calculate the daily % returns for the years changes instead of monthly? How would we change the formula on that?

[@h2e]

I assume you mean returns as of a certain date? Really all you would need to do is change the dates; the process would be the same.

[@idontlikeyouyo]

@@h2e What if it's for day-to-day % changes for the entire year and then I want to compare it to all the other past years? Would that be similar?

[@swapniladhe3058]

Can you please share the template

[@khempalmishra2]

Hey how can we find previous month closing price in google sheet

[@rebeccaconde7270]

what do you mean by percentage returns? what does that mean?

[@rajeshshivramshetty]

Hello sir Is there any function to call the previous months open high low close of any stock in Google sheet

[@h2e]

You can modify the date argument. For example, this formula would get AAPL's high, low, close, open and volume for Sept 30: =GOOGLEFINANCE("AAPL","all","9/30/2022") If you wanted to go back 30 days, you could use something like today()-30 instead of the date: =GOOGLEFINANCE("AAPL","all",today()-30)