I just do my own spreadsheet as a rough guide.
I have a few tabs, such as (Previous trades, Prices and levels, Pending orders, Fund info).
Prices and levels looks like:
| Date | Name | Stock | Price | Prev High | % from High | Good Price Level | % from Price Level | % Change From Last Month |
|---|---|---|---|---|---|---|---|---|
Fund info:
| Ticker | Fund Name | Fund CCY | Fund Size | TER | 1Y | 3Y | 5Y | YTD | Return | Return | Return | Inception date | Distribution policy | Fund domicile | stocks | dividend yield % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| (in m £) | in % p.a. | in % | in % | in % | in % | /Risk | /Risk | /Risk | ||||||||
| 1Y | 3Y | 5Y | ||||||||||||||
| VHYL | Vanguard FTSE All-World High Dividend Yield UCITS ETF Distributing | USD | 1,534 | 0.29% | -16.98% | -11.64% | 13.67% | -23.01% | -0.79 | -0.27 | 0.18 | 21.05.13 | Distributing | Ireland | 1638 | 4.09% |
I just scrape them from websites and pop them in for my own use.
It just gives me a general sense of what it is etc.
Previous trades
Copied directly from the daily/monthly statements then I apply a filter so I can sort them all on the fly.
| № | Order ID | Instrument/ISIN | Direction | Quantity | Price | Total amount | Trading day | Trading time | Commission | Charges and fees | Order Type | Execution venue | Exchange rate | Total cost |
|---|