Corporate action pickup

[PLACEBO92]

Corporate actions are not picked up correctly. Be aware that if you had any M&A-driven exits they may not have been picked up. You will have to add them manually in the end. All the correct fields are selected in the flex query.

PS: thanks A LOT guys, you saved me a min of 24 full hrs of mind-numbing smashing of my head against the keyboard.

[ddbk]

Yes, I think only stock splits are currently supported as I noticed spin-offs need to be edited manually too. I guess we could add that to readme. :)

[pronebird]

Change of tickers when XXX changes to YYY is not handled either, what I believe is a part of corporate actions too. Would be great to fix that until the next tax year. The good thing is that the trades for XXX were lost which caused E-davki to warn that YYY doesn't have the matching buy orders.

[jamsix]

If you can send me some anonymised parts of IB XMLs that cover this, I can take a look on how to properly handle it.

[pronebird]

@jamsix that's how the corporate actions look like for when AXGT changed their ticker to SIOX:

<CorporateAction accountId="UXXXXXXX" acctAlias="" model="" currency="USD" fxRateToBase="1" assetCategory="STK" symbol="AXGT.OLD" description="AXGT(BMG0750W2037) CUSIP/ISIN CHANGE TO (US8293991043) (AXGT.OLD, AXOVANT GENE THERAPIES LTD, BMG0750W2037)" conid="365196285" securityID="BMG0750W2037" securityIDType="ISIN" cusip="" isin="BMG0750W2037" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" expiry="" putCall="" principalAdjustFactor="" reportDate="20201113" dateTime="20201112;202500" actionDescription="AXGT(BMG0750W2037) CUSIP/ISIN CHANGE TO (US8293991043) (AXGT.OLD, AXOVANT GENE THERAPIES LTD, BMG0750W2037)" amount="0" proceeds="0" value="0" quantity="-900" fifoPnlRealized="0" mtmPnl="0" code="" type="IC" transactionID="14273003705" levelOfDetail="DETAIL" />

<CorporateAction accountId="UXXXXXXX" acctAlias="" model="" currency="USD" fxRateToBase="1" assetCategory="STK" symbol="SIOX" description="AXGT(BMG0750W2037) CUSIP/ISIN CHANGE TO (US8293991043) (SIOX, SIO GENE THERAPIES INC, US8293991043)" conid="455196639" securityID="US8293991043" securityIDType="ISIN" cusip="829399104" isin="US8293991043" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" expiry="" putCall="" principalAdjustFactor="" reportDate="20201113" dateTime="20201112;202500" actionDescription="AXGT(BMG0750W2037) CUSIP/ISIN CHANGE TO (US8293991043) (SIOX, SIO GENE THERAPIES INC, US8293991043)" amount="0" proceeds="0" value="0" quantity="900" fifoPnlRealized="0" mtmPnl="0" code="" type="IC" transactionID="14273003706" levelOfDetail="DETAIL" />

Speaking of SecurityInfo, there is no record for AXGT however there is a record for AXGT.OLD:

<SecurityInfo currency="USD" assetCategory="STK" symbol="AXGT.OLD" description="AXOVANT GENE THERAPIES LTD" conid="365196285" securityID="BMG0750W2037" securityIDType="ISIN" cusip="" isin="BMG0750W2037" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" expiry="" putCall="" principalAdjustFactor="" maturity="" issueDate="" underlyingCategory="" subCategory="COMMON" settlementPolicyMethod="" code="" />

<SecurityInfo currency="USD" assetCategory="STK" symbol="SIOX" description="SIO GENE THERAPIES INC" conid="455196639" securityID="US8293991043" securityIDType="ISIN" cusip="829399104" isin="US8293991043" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" expiry="" putCall="" principalAdjustFactor="" maturity="" issueDate="" underlyingCategory="" subCategory="COMMON" settlementPolicyMethod="" code="" />

Worth to note that there are no Lots for AXGT, but there are Trades with the correct securityID that points to AXGT.OLD, which I believe caused AXGT to entirely disappear from the generated reports.