Does anyone else track their stock portfolio via excel? While my brokerage (e*trade) can give me a ton of data, I like to track all my information manually via excel. Currently I track all transactions, dividend income growth (QoQ/YoY), portfolio closing balances, my portfolio summary at a glance, some nifty charts, etc. Wondering if anyone else tracks their portfolio via excel and if they’d be interested in sharing their file as well as all the metrics and what not you track. Additionally, for my returns I have my portfolio set to a 100 NAV, what sort of formula would I build so that when I deposit cash in my account it does not count as an additional return. Modified Dietz formula? Thanks!
Trending Content - Off Topic Forum
| +50 | Uchicago is paradise | 8 | 9h |
| +27 | Without a tribe | 8 | 4d |
| +26 | How the Hell Do People Actually Get Into Private Golf Clubs? | 26 | 4h |
| +22 | Why is AI wrong? | 7 | 1d |
| +13 | Definitive Updated Wharton Club Rank 2026 | 4 | 4d |
| +13 | POLL: Optimistic or Pessimistic? | 9 | 1h |
| +13 | Pigeonholed in Big 4 Technical Accounting, Exhausted Every Path Into Banking/Credit - Need Real Guidance | 2 | 3h |
| +11 | Why do Asians fake their names? | 34 | 1h |
| +6 | Giving AI Impossible Tasks | 8 | 1d |
| +3 | Unhinged euphemisms | 3 | 3d |
Career Resources
Et qui sequi sed necessitatibus enim. Voluptas ut vero necessitatibus quis. Dicta voluptas autem enim necessitatibus distinctio ea. Eos praesentium officia cumque placeat tenetur.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...