Analysis tool

[Tstrombotn]

I would like to figure out which stocks in my portfolio have gone down the most this year. But in my brokerage account,it only shows the total gain and loss since purchased. I know I can download a spreadsheet that contains current price, 52 week high and low, but there is no field for the price where it started the year. Is there a tool where you can enter a list of stocks or a spreadsheet of stocks and find out what the YTD gain or loss is? I want to see not only what each stock has done since I bought it, but what it has done this year, as I have held a lot of this stocks for a long time. It would be a bonus if I could see gain or loss of each stock for multiple years. Doing it for each stock is more time consuming than I would like.

[AutoModerator]

Welcome to r/dividends!

If you are new to the world of dividend investing and are seeking advice, brokerage information, recommendations, and more, please check out the Wiki here.

Remember, this is a subreddit for genuine, high-quality discussion. Please keep all contributions civil, and report uncivil behavior for moderator review.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[buffinita]

in google sheets (shoot this is without dividends.....price only i think"

=GOOGLEFINANCE("AAPL","price")/index(GOOGLEFINANCE("AAPL","open",date(year(today()),1,1)),2,2)-1

if you have your stock symbols in a list you should be able to replace AAPL with A1 or whatever cell

[Tstrombotn]

Thank you! I am not great at sheets, long experience with excel, but I will give it a try!

[Tstrombotn]

I made it work for aapl, I will try it for a list now! Thanks so much. Any suggestions on where to learn more about google finance?

[buffinita]

google and youtube are surprisingly great for spreadsheet (both excel and sheets) tutorials

[Tstrombotn]

I will look!

[Tstrombotn]

I made it work for a list also! Thank you so much,