Home → Extension Development →

Lot matching

• Edit

Mike Bray (Quote Loader Author)

14 Jan, 2021 10:37 AM

What is the best way to retrieve the lot matching information from an investment transaction?

1. Support Staff 1 Posted by Sean Reilly on 14 Jan, 2021 10:49 AM

   

   In the security SplitTxn for each sell there is a parameter "cost_basis" which contains a SyncRecord that maps transaction IDs of buy transactions to the number of shares allocated from that buy.

   I would strongly request that you don't change that value as a lot of work has gone into ensuring that the allocations are calculated properly, especially since it has to deal with stock splits.

   Thanks!
   Sean

   --
   Sean Reilly
   Developer, The Infinite Kind
   https://infinitekind.com

   • Edit

2. 2 Posted by Mike Bray (Quot... on 14 Jan, 2021 10:57 AM

   

   Thanks Sean, I am not interested in changing the values, just extracting the information for reporting purposes. I understand that the info is in the parameters, all I was interested in was whether or not here was an API call to retrieve the information or do I need to go to the parameters directly?

   • Edit

3. Support Staff 3 Posted by Sean Reilly on 14 Jan, 2021 10:58 AM

   

   That's great to hear Mike. Unfortunately there isn't any API for it yet.

   Thanks,
   Sean

   • Edit

4. 4 Posted by Mike Bray (Quot... on 14 Jan, 2021 11:11 AM

   

   OK, Interesting I have tried it out and found the tag on the Parent txn, rather than the security split. Is this correct? See enclosed dump of transaction.

   • cost_basis.png 19.2 KB
   • Edit

5. Support Staff 5 Posted by Sean Reilly on 14 Jan, 2021 12:27 PM

   

   I think that actually is on the security split. The screenshot is showing the combined parameters for the parent and any splits, so the "0.cost_basis" means it is getting the "cost_basis" parameters from the 0th split.

   Because transactions are atomic units the split information is always combined as part of the main transaction. In other words, whenever any part (split) of a transaction is changed, that updates the state of the entire transaction.

   Thanks,
   Sean

   • Edit

6. 6 Posted by Mike Bray (Quot... on 14 Jan, 2021 01:46 PM

   

   OK

   • Edit

7. Mike Bray (Quote Loader Author) closed this discussion on 01 Feb, 2021 08:10 AM.