Mutiple Transaction Importing now available for ports/books

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

P123,

Works. Thank you!!! Very nice.

Regards,

Jim

I found a bug when copying from Excel to the trade input. You can’t paste partial trades into P123. The whole trade must be input at once.


Bump

The behavior for updating transactions has been revised to properly handle matching multiple transactions already existing in the portfolio with multiple imported transactions for the same date, ticker, and transaction type. The new code will be live later today.