Mutiple Transaction Importing now available for ports/books

Dear All,

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.


Very nice! Thank you!

Walter

What a time saver. Thanks!

Jim

Thank you very much for the call this morning Marco!

Will commissions be automatically added to transactions as per the account configuration or should we include them in the upload?

You need to specify the commission currently.

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


Great addition, Marco and team! P123 is becoming a one-stop shop for research and portfolio management.

OP, at first glance you seem to have too many ‘tabs’ between ticker & commission. However the error message would have been something to that effect.

Please try it with one tab. If the problem persists please let us know whihc port and email us the exact list of transactions you are importing.

Thanks

Excellent! That will save a lot of time. Thank you Marco & team! Will test next Week-end…

This is not working for me, yet.

This is the second day that I got the same error for the second transaction. I did check update existing transactions both times See attachment.

Thank you!


Jrinne, which port? Can you email us the list of transactions so we can try it? thanks

Thanks Marco!

Also note that I had to truncate the price for many of the transaction for it to be formatted properly.

Email sent. Let me know if you need anything else.

ERRORS:
Ticker IEF is of type ETF; Stock required

So stocks only?

We’re still working out the kinks. ETF import will be supported by this tool.
Also: The reconcile feature will be disabled until the next release.

P123,

It seems like there is a new release–at least new import options.

But it is still not usable for me. Same error message as above.

Sorry, if this is still a know issue that you are working on.

Thanks!

Jim

Any update regarding the inability of the trade input to handle multiple transactions for the same stock?

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.

Bump

You should now be able to add multiple transactions for one stock in the same import.

Also, the import should now work for buy/sell/short/cover as well as split, dividend, and cash transactions.

ted