My setup

Just wondering what people think of my setup for looking up stocks, any suggestions on other things to add to make picking options easier?

3 Likes

I have something similar. This is my watchlist in Google Sheets:

I like using the SPARKLINE function to show the trend.

4 Likes

Looks great.

I have a similar watchlist for UK companies. I added a field called RVOL alert to monitor unusual volume activity that is current volume over average volume.

Googlesheet

5 Likes

Would you be willing to share the template? I’d love something similar.

3 Likes

Sure, here’s a template: https://docs.google.com/spreadsheets/d/1wt7CkNBNnA3pJmHQKhRmcCHby7F7mi6Lwiv7cutf8PM/edit?usp=sharing

7 Likes

Very Bloomberg :sunglasses:

1 Like

Cheers for the sparklines idea, no idea that it could be that easy to create a graph haha, added that instantly.

1 Like

Thanks gonna try implement this version and add dividends to it. I’m such a novice at these stock spread sheets and how to pull the data. I literally just write in dollars how much I got (85% of div which is minus the 15% tax)

This is my sheet

Let me know what you guys think, and if I can improve it in anyway.

2 Likes

You have your positions shown in a bar chart, but also have a look at a pie chart or similar. Works well for me:

3 Likes

As a passive investor who focus more on ETFs, this looks ridiculously good. Thanks for sharing

1 Like

Anytime. Glad you really like it.