We added a new way to import or reconcile transactions in live ports & books. You can now copy+paste from excel a list of transactions and “execute” them on a P123 model. You can also use this new feature to reconcile your real transactions with p123 ones. Here are some use cases:
Export your transactions from your broker into excel and import them into your P123 model. Past transactions are ok. The equity curve of the model is re-calculated.
Rebalance and commit recommendations in your model. Execute them in your broker, then download them into excel. When importing to P123 model select the “Update existing transactions” option. The logic will try to reconcile your real transactions with existing p123 transactions (execution prices, commission and shares).
Please Note the following:
The importer requires a transaction date. You can also add transactions in the past up to two weeks
You do not need to add dividend transactions. If you add a BUY in the past, if will automatically figure out if a dividend was received and its due.
You can also type directly in the text area. The fields must be separated by Tab. Either click Tab or use a space which is converted to Tab as you type.
Please see the accompanying image. Thanks for your feedback.
We are receiving an error and not quite sure of its meaning. We think its related to the multiple sell transactions for a single stock. Does the new import function not tolerate multiple transactions? This is how we receive our transaction data
That particular issue should be resolved. However, there is still a problem with the holdings checks that needs to be dealt with. Hold off on it until then. We hope to have it up and running today or tomorrow.