I manage using two Excel Files.
File1. Shareholdings tabulated in HYPTUSS.
File 2. Shareholdings tabulated in a MAIN ACCOUNT directory. (Shares listed in the same order as in HYPTUSS.)
The 2 files are held in separate directories with copies held on a separate device.
The HYPTUSS file is used only to scrape prices and to feed into the MAIN ACCOUNT file.
I do a cross check between the two files ( Value of File 1 - Value of File 2 = zero ....if not, error!).
In the Main Account file I have several ( ahem!) worksheets.
1. Dealing records
2. Dividend schedule ( company, account name , qty, dividend per share, total dividend, xd date, pay date xirr check, received check). This, I update manually...a mix of angst and joy ( who doesn't like recording a divi...even if it means tracking them?)
3. A sheet tabulating XIRR values (individual tables for each held share)
4. A sheet generated by pivot table summarising dividends in taxed and untaxed accounts.
5. A sheet summarising XIRR on shares held
6. A sheet containing cashflow in/out of the accounts.
7. A ' weighting ' sheet. Portfolio arranged in descending value ( value and percentage of total) and what type of investment (HYP, Income IT, Growth IT, Pref, Bond, Gilt)
The pivot table is used to track the extent of taxable dividends in my and my wife's accounts in ii and iWeb. It is also used to estimate tax payable and, in the New tax year, the best shares to ISA to reduce tax. Thus 'account name' can be one of eight names!
A man's gotta have a hobby... occasionally I get out! :
(Way off base now but very important! ) - There is one calculation that I do on the main sheet...I compare number of days I've lived versus number of days my father lived. I'm in credit by 2 years. I want to be in a lot more credit.... it's a reminder ...Carpe Diem!