If you are a Pakistan Stock Exchange investor, chances are you have a spreadsheet somewhere - a Google Sheet, an Excel file on your desktop, or maybe even a notebook with handwritten entries. It works fine at first. You record your buys, jot down the prices, and feel organized.
Then real life happens.
Where Excel Falls Apart
1. Right Shares and Bonus Shares
When a company announces a right share offering or a bonus issue, your cost basis changes. Your average price per share needs to be recalculated across your entire holding. In Excel, you have to manually figure out the new weighted average, adjust the number of shares, and hope you did not break a formula somewhere.
Miss this adjustment once and your profit/loss numbers are wrong for the life of that holding.
2. Dividends Are More Than Just Cash
A Rs. 5 per share dividend sounds simple. But did you account for:
- Withholding tax deducted at source (15% for filers, 30% for non-filers)
- The ex-dividend date vs the payment date
- Reinvested dividends that create new cost lots
Most Excel trackers just add the gross dividend amount and move on. The result? Your return calculations are inflated because you are counting money you never actually received.
3. Multiple Brokers, Multiple Headaches
Many PSX investors use more than one brokerage account. Maybe you have your long-term holdings with one broker and actively trade through another. In Excel, you now need:
- Separate tabs or sections per broker
- Manual consolidation for a total portfolio view
- Different fee structures tracked per broker
One wrong cell reference across tabs and your entire consolidated view is off.
4. You Cannot See Real-Time Performance
Excel does not know today's stock prices. You either:
- Manually type in closing prices every day (nobody actually does this)
- Use a Google Finance formula that breaks periodically
- Just never look at real-time PnL
Without live prices, you are always looking at yesterday's (or last week's) picture.
5. XIRR Is Nearly Impossible by Hand
The most important metric for any investor - your true annualized return - requires calculating XIRR across every transaction you have ever made. Excel has an XIRR function, but you need to maintain a perfect chronological list of every cash flow: buys (negative), sells (positive), dividends (positive), and your current portfolio value.
Add one transaction out of order or forget a dividend and the result is garbage.
What Should You Use Instead?
A dedicated portfolio tracker built specifically for PSX handles all of these problems automatically:
- Import your broker statements - No manual entry. Upload a PDF or CSV and your transactions appear instantly with correct cost basis calculations
- Automatic corporate action adjustments - Right shares, bonus issues, and stock splits are handled without you lifting a finger
- Live prices during market hours - See your actual PnL updating in real time, not a stale snapshot from last week
- XIRR calculated automatically - Every buy, sell, and dividend is factored in. You just read the number
- Multi-portfolio support - Track separate strategies or broker accounts, with a consolidated view across all of them
- Dividend tracking with tax - Gross amount, WHT deduction, and net received - all tracked per transaction
"But I Like the Control of Excel"
Fair point. Spreadsheets give you full control over your data. But here is the thing - you can have both. Export your data anytime. Use a tracker for accuracy and automation, and keep your spreadsheet for custom analysis if you want.
The real question is: how many hours have you spent maintaining formulas versus actually analyzing your investments?
The Bottom Line
Excel is a general-purpose tool. It was not built for tracking stock portfolios with corporate actions, dividends, multiple cost lots, and real-time prices. For that, you need something purpose-built.
Your time is better spent researching your next investment than debugging a VLOOKUP.
Zarify handles all of this automatically - import your broker statements, track live prices, and see your true XIRR returns. Free for all PSX investors.