Morgan Stanley: Non-zero Net Cash Proceeds

[0xDCA]

Thank you for writing this calculator.

I'm trying to use it with my Morgan Stanley report (from Alphabet), but I'm getting the exception thrown here. I'm trying to understand why the code needs to make this assumption, as some of the entries in my file contain non-zero values.

Thanks

[0xDCA]

@goofy57 Hi Sergey, I saw you added this parser, so wondering if you could take a look at my question above. Thank you in advance!

[goofy57]

TBH this was very custom and I had to update the code a bit every year that I completed a self assessment - so please double-check at least orders of magnitude when you use it :)

I don't recall seeing non-zero net cash proceeds in my data, therefore wasn't sure how to deal with them in the code - feel free to patch this and happy to take a look at the pull request.

Is there any chance this is caused by the new G dividend program?
If so, one quick workaround would be to just request data in Morgan Stanley up till e.g. May 2024 - that should still contain all data for 2023-2024 financial year but no rows with dividends.

[0xDCA]

Thanks for the quick reply. Actually, it seems these come from Autosale, which are shown in a weird way in these reports.

From what I have figured out so far, auto-sold stocks are reported in the "Releases Report" with a non-zero Net Cash Proceeds and in that file the event date corresponds with the date of vesting (not the sale, which may happen the next business day). The sale itself is not reported in the "Withdrawals Report" file, but rather in the "Autosale_Trading Plan - Releases" file. So I think we'll need to:

• Take into account entries in the "Releases report" file as vesting events even if they have non-zero Net Cash Proceeds.
• Parse the Autosale file and add those as sales events.

However, there's a complication, since the Releases report does not show the net shares received (it shows the quantity before taxes), so this may need to be sourced from somewhere else.

I can try to put together a PR later.

[goofy57]

SG, thanks!

I'd also suggest to add some validation in case those non-zero Net Cash Proceeds are not found in the autosale report, otherwise it's easy to lose them in the final accounting.