I have a transaction log that only reports Date and Value, not quantity/price. Would it be possible to infer the quantity using the Asset market price at the transaction date?
3 Answers
3Unfortunately it’s not possible, and possibly would lead to big discrepancies, as the most important bit of the transaction is quantity. Inferring quantity from market value would rather not give you the actual number, as market value at the time of transaction is mostly different than at end-of-day. It could be mostly ok if it would be rounded, and the price per share would be high - but that’s a big if.
Hey @Ale , it’s actually now possible! Just add the Fetch Market Price statement and you will have the chosen asset’s price in the Fetched Market Price property.
Amazing, thanks! I’ll give it a go
Thanks for the explanation, Rafal! I'm aware of the discrepancies, but this case is a mutual fund, so I believe the price at the end of the day is still the most accurate (in the absence of more details in the transaction log, of course). Also, this mutual fund allows fractional shares, which means that the error should be minimal and probably compensate over many transactions. Does Capitally support fractional shares? It feels that my case might be a bit borderline. Would it be ok to provide the market price as a function and let users figure out their own math?
– AleYes, fractional shares are definitely supported. The issue is, that right now imports do not have access to pricing data, but theoretically they could. It's not a trivial thing, so feel free to add it to the Roadmap -> Proposals
– rafal