I use Interactive Brokers for my main portfolio and a small New Zealand broker called Sharesies for my kids’ portfolios.
When I run an export for importing into Capitally, IBKR outputs trade times in UTC -5 and Sharesies outputs in UTC +13.
This means I could make a trade of the same stock at the same time on each of these platforms and Capitally would show them as being 18 hours apart.
Not sure if it’s related but I also have an issue where showing 1d returns is always 0, I’m guessing because my clock is always 18 hours ahead of the exchange I trade on.
Did you use other apps for tracking your investments in the past? If yes, how they solved it usually? Especially the latter case - with 1d gains.
As Capitally is solely End-Of-Day based, I opted to simplify date calculations and just drop the time - especially as that’s how price data is reported by all providers. To make matters worse, most brokers provide no timezone information in their exports - that’s why I always assume local time for simplicity. As the time component is only used for ordering and deduplicating transactions.
I possibly could add a timezone option (or time offset) in the importer, so at least the transaction times would be properly localized, but that wouldn’t help with the second issue.
ShareSight doesn’t update after hours so the only reason I have a non-zero amount since close is because I have a couple of insignificant positions in the New Zealand market which is currently open.
Oh neat, I’ll check this out when I get home from work tonight.
