Would it perhaps be possible for me to trouble you to tell me how 
? I would be extremely grateful for the help, as I’m starting to feel some stress about whether I’ll finish in time, given that I still have the NN Swedish account to figure out, which looks like it’ll involve calculating from a 111-page Swedish K4 report 
3 Likes
Here is one way. There are others:
- Import the trade report in CSV format into a spreadsheet and clean out all the unnecessary data.
- In the report, separate all trades into their own (new) columns for profitable selling prices, loss-making selling prices, and the purchase prices (basis) for both. A total of four columns of data.
- Calculate the column sums for the profitable selling prices and their purchase prices.
- Do the same for the loss-making ones.
- The year’s profits and losses can be easily obtained from the sums calculated above.
- You will have to do some manual row deletions if the report contains pre-calculated subtotals. I don’t remember if it does.
- I also don’t remember if trading fees are included in the purchase or sale prices in the report. Check this. If not, add/subtract them before summing everything up.
edit: basis price (purchase) includes purchase costs. Proceeds price (sale) does not include sales costs. - If currency matters need to be added, include them in an appropriate way (e.g., calculate conversions for those transactions using the daily closing rate or the annual average rate suggested by the tax authority).
With this method, it shouldn’t really matter whether there are dozens or thousands of transactions. The 20 minutes mentioned by @T3r00 is a fairly optimistic time estimate, but not impossible for a skilled user.
8 Likes
I did it as a lump sum.
I have a custom report with everything that happened during the year.
I took the purchases, sales, expenses, and profit from the bottom line and converted them into euros. I attached that thousand-page report as an enclosure.
It was accepted last year, too. It went through a manual review, and I think the tax assessment was finalized in October.
6 Likes
So from that total asset you get those acquisitions.
Edit: I left out that currency conversion because it’s computational. No money changed hands and that currency conversion is stated at the year’s average exchange rate.
In this report they are clearer.
2 Likes
It’s getting challenging, but I have to try making a custom report. There are many choices, but I’ve only done stock trades on the US exchange—luckily no call and put options or anything else complicated for a beginner yet.
Take the figures from the cash report - everything you need is there + the exchange rate from the tax office
and check that the figures are the same as in the realized report. They should be, if you didn’t own anything over the turn of the year.
Attach both as an appendix, or just run one report.
1 Like
Now I’m getting close; I found the cash report section and the exact figures I need are right there. It’s not in a printable format, but in the worst-case scenario, a screenshot and the realized report you mentioned will work. It was just a holding of a few dozen over the turn of the year, some leftovers from a split, so maybe this will suffice. Thanks a lot for your effort and advice.
1 Like
You can get everything out of there as a PDF, which can be attached to your tax return as is. Or if you are indeed filing a paper return, it will print out on paper.
3 Likes
Doesn’t TW update anything more frequently than every minute unless you pay extra? But yeah, TradingView doesn’t seem to be fully synchronized at least with IBKR, especially regarding penny stocks, and as a trading platform IBKR usually shows the price at which the asset is actually moving at any given time.
1 Like
In this case, I have real-time enabled and yet there is a delay for a few stocks.
Typo, I meant TV aka Tradingview
1 Like
By TW, do you mean TWS, i.e., Trader Workstation? Or something else?
3 Likes
Didn’t they plan something like that earlier this year—that Shareville would become part of the Nordnet UI? I don’t think quite everything is there yet (e.g., portfolio rating, tracking, and groups), but at least the main features have been visible for a while now. For example, ticker comments:
1 Like
Yeah, everything is being integrated into one platform. SV features will be added gradually (e.g., the Feed should arrive in the summer) and the separate Share will be closed during 2024.
Hmm, a Shareville profile has now appeared for me on the Nordnet homepage as well, and it also includes a link to groups. The groups even open within Nordnet, rather than just being a link to Shareville.
2 Likes
I wonder if the price history has been removed from Nordnet?
At least I can’t find it anymore. It used to appear in place of the charts. If I recall correctly, it used to be behind the settings.
If it can still be found somewhere, advice would be gratefully received.
You can see the status for the holdings in your own portfolio there. A similar view is available for all of them by selecting Markets, Stock Prices, Performance.
This is in the browser version.
Not that, but this.
The problem is apparently only on my other computer. For some reason, I can’t get that price history row on it at all.
Thanks for the reminder; I’ll use the other computer then.
Thank you as well. I hadn’t even noticed that you can display a price history table like that from the Settings section.
1 Like
Has anyone used IBKR’s (Interactive Brokers) recurring investment feature? I think it was added as a new feature just a few months ago. It operates with standard trading commissions, but are there any pitfalls?
https://ibkr.info/article/4470
It is likely possible to set up a recurring transfer to IBKR. They mention on that page that they should be notified of every transfer, but I forgot to do it once and the money still arrived. Apparently, that is just a backup measure in case the bank doesn’t provide the depositor’s information.
Now that Degiro has raised prices and actually implemented fees for investing in ETFs (for me, many of them went through without fees before, even though they probably shouldn’t have… they have now fixed that bug), I was thinking of automating the whole thing through IBKR.