My setup

[adam_john (Adam)]

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

[Phil]

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

I like using the SPARKLINE function to show the trend.

[adavid (Aris David)]

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
https://docs.google.com/spreadsheets/d/1fogZHIyY-nj4frUsITQC9_hWcCRBxfvGIEGV21LFy2o/edit?usp=sharing

[simonpoole]

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

[Phil]

Sure, here’s a template: Watchlist template - Google Sheets

[mrpbennett]

Very Bloomberg

[adam_john (Adam)]

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

[shane-aurora (Shane Ireland)]

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)

[mrpbennett]

This is my sheet

https://docs.google.com/spreadsheets/d/1IcG4nXM-07oXnaoSPEoPPhFEc-D3s92l7vwFHfR1iMA/edit?usp=sharing

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

[Phil]

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

[sudoh (Solomon)]

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

[mrpbennett]

Anytime. Glad you really like it.

[GDawg]

Ok so I must admit that I am new to all this but have been reading a lot over the last year or so in readiness to move over from roboinvestor to a more autonomous platform like Freetrade.

I am looking for an easy way to keep track of my portfolio allocation by geography and class if possible. I have tried using the link above and still cannot get to grips with it

[in7inaxe7en (Mike)]

I’ve looked through quite a few tracking sheets and this one is by far the best I found.

Investment Portfolio Tracker -- a Spreadsheet for DIY Investors | The Measure...

So much so that I paid a donation to the creator for his or her work.

Although I’m not sure itll cater both geography and class it let’s you set your own categories in a single taxonomy so you can choose one or the other.

[GDawg]

Thanks for this I’m just taking a look at it now, so thanks for heads-up.

My portfolio will mainly be ETFs so I have also been eyeing up justetf.com but I don’t know if that will integrate any stocks…

Thanks a lot.