Position ISIN changed

[lukatavcer]

Pozicija PRSO, zgodil se je SPLIT 1 FOR 40 in hkrati so se zamenjali securityID oz. ISIN in conId.
Ste hendlali v preteklosti že kaj podobnega? @ddbk omenjal si podoben primer

Izgleda isti problem kot pri: #106

2023

<FlexStatement accountId="U76XXXXX" fromDate="20230102" toDate="20231229" period="" whenGenerated="20250228;152429">
<AccountInformation accountId="U76XXXXX" ibEntity="IB-CE" />
<Trades>
    <Trade accountId="U76XXXXX" acctAlias="" model="" currency="USD" fxRateToBase="0.92911" assetCategory="STK" subCategory="COMMON" symbol="PRSO" description="PERASO INC" conid="533782050" securityID="US71360T1016" securityIDType="ISIN" cusip="71360T101" isin="US71360T1016" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" tradeID="157634156" expiry="" relatedTradeID="" putCall="" reportDate="20231208" principalAdjustFactor="" dateTime="20231208;113130" tradeDate="20231208" settleDateTarget="20231212" transactionType="ExchTrade" exchange="ISLAND" quantity="27" tradePrice="0.2044" tradeMoney="5.5188" proceeds="-5.5188" taxes="0" ibCommission="-0.055188" ibCommissionCurrency="USD" netCash="-5.573988" closePrice="0.2026" openCloseIndicator="O" notes="P" cost="5.573988" fifoPnlRealized="0" mtmPnl="-0.0486" origTradePrice="0" origTradeDate="" origTradeID="" origOrderID="0" origTransactionID="0" buySell="BUY" clearingFirmID="" ibOrderID="128980834" transactionID="631773003" ibExecID="0001390d.6573170d.01.01" relatedTransactionID="" brokerageOrderID="0055b2d7.00023fcc.6572aa5f.0001" orderReference="" volatilityOrderLink="" exchOrderId="N/A" extExecID="0337408521" orderTime="20231208;111917" openDateTime="" holdingPeriodDateTime="" whenRealized="" whenReopened="" levelOfDetail="EXECUTION" changeInPrice="0" changeInQuantity="0" orderType="MIDPX" traderID="" isAPIOrder="N" accruedInt="0" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="BBG000BC8VG6" issuerCountryCode="US" rtn="" initialInvestment="" />
    <Trade accountId="U76XXXXX" acctAlias="" model="" currency="USD" fxRateToBase="0.92911" assetCategory="STK" subCategory="COMMON" symbol="PRSO" description="PERASO INC" conid="533782050" securityID="US71360T1016" securityIDType="ISIN" cusip="71360T101" isin="US71360T1016" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" tradeID="157636313" expiry="" relatedTradeID="" putCall="" reportDate="20231208" principalAdjustFactor="" dateTime="20231208;114047" tradeDate="20231208" settleDateTarget="20231212" transactionType="ExchTrade" exchange="ISLAND" quantity="100" tradePrice="0.2017" tradeMoney="20.17" proceeds="-20.17" taxes="0" ibCommission="-0.2017" ibCommissionCurrency="USD" netCash="-20.3717" closePrice="0.2026" openCloseIndicator="O" notes="P" cost="20.3717" fifoPnlRealized="0" mtmPnl="0.09" origTradePrice="0" origTradeDate="" origTradeID="" origOrderID="0" origTransactionID="0" buySell="BUY" clearingFirmID="" ibOrderID="128980834" transactionID="631777458" ibExecID="0001390d.657318d2.01.01" relatedTransactionID="" brokerageOrderID="0055b2d7.00023fcc.6572aa5f.0001" orderReference="" volatilityOrderLink="" exchOrderId="N/A" extExecID="0339425441" orderTime="20231208;111917" openDateTime="" holdingPeriodDateTime="" whenRealized="" whenReopened="" levelOfDetail="EXECUTION" changeInPrice="0" changeInQuantity="0" orderType="MIDPX" traderID="" isAPIOrder="N" accruedInt="0" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="BBG000BC8VG6" issuerCountryCode="US" rtn="" initialInvestment="" />
    <Trade accountId="U76XXXXX" acctAlias="" model="" currency="USD" fxRateToBase="0.92911" assetCategory="STK" subCategory="COMMON" symbol="PRSO" description="PERASO INC" conid="533782050" securityID="US71360T1016" securityIDType="ISIN" cusip="71360T101" isin="US71360T1016" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" tradeID="157636475" expiry="" relatedTradeID="" putCall="" reportDate="20231208" principalAdjustFactor="" dateTime="20231208;114134" tradeDate="20231208" settleDateTarget="20231212" transactionType="ExchTrade" exchange="ISLAND" quantity="223" tradePrice="0.2017" tradeMoney="44.9791" proceeds="-44.9791" taxes="0" ibCommission="-0.449791" ibCommissionCurrency="USD" netCash="-45.428891" closePrice="0.2026" openCloseIndicator="O" notes="P" cost="45.428891" fifoPnlRealized="0" mtmPnl="0.2007" origTradePrice="0" origTradeDate="" origTradeID="" origOrderID="0" origTransactionID="0" buySell="BUY" clearingFirmID="" ibOrderID="128980834" transactionID="631777784" ibExecID="0001390d.657318ed.01.01" relatedTransactionID="" brokerageOrderID="0055b2d7.00023fcc.6572aa5f.0001" orderReference="" volatilityOrderLink="" exchOrderId="N/A" extExecID="0339564171" orderTime="20231208;111917" openDateTime="" holdingPeriodDateTime="" whenRealized="" whenReopened="" levelOfDetail="EXECUTION" changeInPrice="0" changeInQuantity="0" orderType="MIDPX" traderID="" isAPIOrder="N" accruedInt="0" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="BBG000BC8VG6" issuerCountryCode="US" rtn="" initialInvestment="" />
</Trades>
<CorporateActions></CorporateActions>
<CashTransactions></CashTransactions>
<SecuritiesInfo>
    <SecurityInfo currency="USD" assetCategory="STK" subCategory="COMMON" symbol="PRSO" description="PERASO INC" conid="533782050" securityID="US71360T1016" securityIDType="ISIN" cusip="71360T101" isin="US71360T1016" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" expiry="" putCall="" principalAdjustFactor="" maturity="" issueDate="" underlyingCategory="" settlementPolicyMethod="" code="" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="BBG000BC8VG6" issuerCountryCode="US" />
</SecuritiesInfo>
</FlexStatement>

2024

<FlexStatement accountId="U76XXXXX" fromDate="20240101" toDate="20241231" period="" whenGenerated="20250228;152314">
<AccountInformation accountId="U76XXXXX" ibEntity="IB-CE" />
<Trades>
    <Trade accountId="U76XXXXX" acctAlias="" model="" currency="USD" fxRateToBase="0.91556" assetCategory="STK" subCategory="COMMON" symbol="PRSO" description="PERASO INC" conid="675381376" securityID="US71360T2006" securityIDType="ISIN" cusip="71360T200" isin="US71360T2006" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" tradeID="" expiry="" relatedTradeID="" putCall="" reportDate="20240103" principalAdjustFactor="" dateTime="20240102;202500" tradeDate="20240102" settleDateTarget="20240103" transactionType="FracShare" exchange="--" quantity="-0.75" tradePrice="9.6" tradeMoney="-7.2" proceeds="7.2" taxes="0" ibCommission="0" ibCommissionCurrency="USD" netCash="7.2" closePrice="8.03" openCloseIndicator="C" notes="" cost="-6.185139" fifoPnlRealized="1.014861" mtmPnl="1.1775" origTradePrice="0" origTradeDate="" origTradeID="" origOrderID="0" origTransactionID="0" buySell="SELL" clearingFirmID="" ibOrderID="646863322" transactionID="646863322" ibExecID="" relatedTransactionID="" brokerageOrderID="" orderReference="" volatilityOrderLink="" exchOrderId="N/A" extExecID="N/A" orderTime="" openDateTime="" holdingPeriodDateTime="" whenRealized="" whenReopened="" levelOfDetail="EXECUTION" changeInPrice="0" changeInQuantity="0" orderType="" traderID="" isAPIOrder="N" accruedInt="0" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="" issuerCountryCode="US" rtn="" initialInvestment="" />
    <Lot accountId="U76XXXXX" acctAlias="" model="" currency="USD" fxRateToBase="0.91556" assetCategory="STK" subCategory="COMMON" symbol="PRSO" description="PERASO INC" conid="675381376" securityID="US71360T2006" securityIDType="ISIN" cusip="71360T200" isin="US71360T2006" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" tradeID="" expiry="" relatedTradeID="" putCall="" reportDate="20240103" principalAdjustFactor="" dateTime="20240102;202500" tradeDate="20240102" settleDateTarget="" transactionType="" exchange="ISLAND" quantity="0.675" tradePrice="8.25776" tradeMoney="" proceeds="" taxes="" ibCommission="" ibCommissionCurrency="" netCash="" closePrice="" openCloseIndicator="C" notes="ST" cost="5.573988" fifoPnlRealized="0.906012" mtmPnl="" origTradePrice="" origTradeDate="" origTradeID="" origOrderID="" origTransactionID="" buySell="SELL" clearingFirmID="" ibOrderID="" transactionID="631773003" ibExecID="" relatedTransactionID="" brokerageOrderID="" orderReference="" volatilityOrderLink="" exchOrderId="" extExecID="" orderTime="" openDateTime="20231208;113130" holdingPeriodDateTime="20231208;113130" whenRealized="" whenReopened="" levelOfDetail="CLOSED_LOT" changeInPrice="" changeInQuantity="" orderType="" traderID="" isAPIOrder="" accruedInt="" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="" issuerCountryCode="US" rtn="" initialInvestment="" />
    <Lot accountId="U76XXXXX" acctAlias="" model="" currency="USD" fxRateToBase="0.91556" assetCategory="STK" subCategory="COMMON" symbol="PRSO" description="PERASO INC" conid="675381376" securityID="US71360T2006" securityIDType="ISIN" cusip="71360T200" isin="US71360T2006" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" tradeID="" expiry="" relatedTradeID="" putCall="" reportDate="20240103" principalAdjustFactor="" dateTime="20240102;202500" tradeDate="20240102" settleDateTarget="" transactionType="" exchange="ISLAND" quantity="0.075" tradePrice="8.14868" tradeMoney="" proceeds="" taxes="" ibCommission="" ibCommissionCurrency="" netCash="" closePrice="" openCloseIndicator="C" notes="ST" cost="0.611151" fifoPnlRealized="0.108849" mtmPnl="" origTradePrice="" origTradeDate="" origTradeID="" origOrderID="" origTransactionID="" buySell="SELL" clearingFirmID="" ibOrderID="" transactionID="631777458" ibExecID="" relatedTransactionID="" brokerageOrderID="" orderReference="" volatilityOrderLink="" exchOrderId="" extExecID="" orderTime="" openDateTime="20231208;114047" holdingPeriodDateTime="20231208;114047" whenRealized="" whenReopened="" levelOfDetail="CLOSED_LOT" changeInPrice="" changeInQuantity="" orderType="" traderID="" isAPIOrder="" accruedInt="" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="" issuerCountryCode="US" rtn="" initialInvestment="" />
    <Trade accountId="U76XXXXX" acctAlias="" model="" currency="USD" fxRateToBase="0.93443" assetCategory="STK" subCategory="COMMON" symbol="PRSO" description="PERASO INC" conid="675381376" securityID="US71360T2006" securityIDType="ISIN" cusip="71360T200" isin="US71360T2006" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" tradeID="173460867" expiry="" relatedTradeID="" putCall="" reportDate="20240423" principalAdjustFactor="" dateTime="20240423;145504" tradeDate="20240423" settleDateTarget="20240425" transactionType="ExchTrade" exchange="ISLAND" quantity="40" tradePrice="1.32" tradeMoney="52.8" proceeds="-52.8" taxes="0" ibCommission="-0.528" ibCommissionCurrency="USD" netCash="-53.328" closePrice="1.31" openCloseIndicator="O" notes="" cost="53.328" fifoPnlRealized="0" mtmPnl="-0.4" origTradePrice="0" origTradeDate="" origTradeID="" origOrderID="0" origTransactionID="0" buySell="BUY" clearingFirmID="" ibOrderID="141023290" transactionID="722175381" ibExecID="0001390d.66281dff.01.01" relatedTransactionID="" brokerageOrderID="0055b2d7.00031d6e.66273a70.0003" orderReference="" volatilityOrderLink="" exchOrderId="N/A" extExecID="0383920531" orderTime="20240423;145504" openDateTime="" holdingPeriodDateTime="" whenRealized="" whenReopened="" levelOfDetail="EXECUTION" changeInPrice="0" changeInQuantity="0" orderType="LMT" traderID="" isAPIOrder="N" accruedInt="0" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="BBG000BC8VG6" issuerCountryCode="US" rtn="" initialInvestment="" />
</Trades>
<CorporateActions>
    <CorporateAction accountId="U76XXXXX" acctAlias="" model="" currency="USD" fxRateToBase="0.91556" assetCategory="STK" subCategory="COMMON" symbol="PRSO" description="PRSO(US71360T1016) SPLIT 1 FOR 40 (PRSO, PERASO INC, US71360T2006)" conid="675381376" securityID="US71360T2006" securityIDType="ISIN" cusip="71360T200" isin="US71360T2006" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" expiry="" putCall="" principalAdjustFactor="" reportDate="20240103" dateTime="20240102;202500" actionDescription="PRSO(US71360T1016) SPLIT 1 FOR 40 (PRSO, PERASO INC, US71360T2006)" amount="0" proceeds="0" value="0" quantity="8.75" fifoPnlRealized="0" mtmPnl="0" code="" type="RS" transactionID="646862846" actionID="131953201" levelOfDetail="DETAIL" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="" issuerCountryCode="US" />
    <CorporateAction accountId="U76XXXXX" acctAlias="" model="" currency="USD" fxRateToBase="0.91556" assetCategory="STK" subCategory="COMMON" symbol="PRSO.OLD" description="PRSO(US71360T1016) SPLIT 1 FOR 40 (PRSO.OLD, PERASO INC, US71360T1016)" conid="533782050" securityID="US71360T1016" securityIDType="ISIN" cusip="71360T101" isin="US71360T1016" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" expiry="" putCall="" principalAdjustFactor="" reportDate="20240103" dateTime="20240102;202500" actionDescription="PRSO(US71360T1016) SPLIT 1 FOR 40 (PRSO.OLD, PERASO INC, US71360T1016)" amount="0" proceeds="0" value="0" quantity="-350" fifoPnlRealized="0" mtmPnl="0" code="" type="RS" transactionID="646862844" actionID="131953201" levelOfDetail="DETAIL" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="" issuerCountryCode="US" />
</CorporateActions>
<CashTransactions>
</CashTransactions>
<SecuritiesInfo>
    <SecurityInfo currency="USD" assetCategory="STK" subCategory="COMMON" symbol="PRSO" description="PERASO INC" conid="675381376" securityID="US71360T2006" securityIDType="ISIN" cusip="71360T200" isin="US71360T2006" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="PRSO" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" expiry="" putCall="" principalAdjustFactor="" maturity="" issueDate="" underlyingCategory="" settlementPolicyMethod="" code="" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="BBG000BC8VG6" issuerCountryCode="US" />
    <SecurityInfo currency="USD" assetCategory="STK" subCategory="COMMON" symbol="PRSO.OLD" description="PERASO INC" conid="533782050" securityID="US71360T1016" securityIDType="ISIN" cusip="71360T101" isin="US71360T1016" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" expiry="" putCall="" principalAdjustFactor="" maturity="" issueDate="" underlyingCategory="" settlementPolicyMethod="" code="" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="" issuerCountryCode="US" />
</SecuritiesInfo>
</FlexStatement>

Generira napačen Doh-KDVP, manjka vrstica za nakup in pa popravljene scene glede na split:

<KDVPItem>
  <InventoryListType>PLVP</InventoryListType>
  <Name>PERASO INC</Name>
  <HasForeignTax>false</HasForeignTax>
  <HasLossTransfer>false</HasLossTransfer>
  <ForeignTransfer>false</ForeignTransfer>
  <TaxDecreaseConformance>false</TaxDecreaseConformance>
  <Securities>
    <ISIN>US71360T2006</ISIN>
    <Code>PRSO</Code>
    <Name>PERASO INC</Name>
    <IsFond>false</IsFond>
    <Row>
      <ID>0</ID>
      <Sale>
        <F6>2024-01-02</F6>
        <F7>0.0188</F7>
        <F9>350.4929</F9>
      </Sale>
      <F8>-0.0188</F8>
    </Row>
  </Securities>
</KDVPItem>

[ddbk]

Ste hendlali v preteklosti že kaj podobnega? @ddbk omenjal si podoben primer

Yes: #182

[lukatavcer]

Ste hendlali v preteklosti že kaj podobnega? @ddbk omenjal si podoben primer

Yes: #182

Ampak v mojem primeru sploh ni bilo reportanega CUSIP/ISIN CHANGE TO dogodka.. se ti svita kaj mi manjka, da ga ni med exportanimi podatki?

Ostale corporate evente imam, npr SPLIT 1 FOR 40
Lahko bi matchal po tem splitu, da se je spremenil ISIN

<CorporateAction accountId="U76XXXXX" acctAlias="" model="" currency="USD" fxRateToBase="0.91556" assetCategory="STK" subCategory="COMMON" symbol="PRSO" description="PRSO(US71360T1016) SPLIT 1 FOR 40 (PRSO, PERASO INC, US71360T2006)" conid="675381376" securityID="US71360T2006" securityIDType="ISIN" cusip="71360T200" isin="US71360T2006" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" expiry="" putCall="" principalAdjustFactor="" reportDate="20240103" dateTime="20240102;202500" actionDescription="PRSO(US71360T1016) SPLIT 1 FOR 40 (PRSO, PERASO INC, US71360T2006)" amount="0" proceeds="0" value="0" quantity="8.75" fifoPnlRealized="0" mtmPnl="0" code="" type="RS" transactionID="646862846" actionID="131953201" levelOfDetail="DETAIL" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="" issuerCountryCode="US" />
<CorporateAction accountId="U76XXXXX" acctAlias="" model="" currency="USD" fxRateToBase="0.91556" assetCategory="STK" subCategory="COMMON" symbol="PRSO.OLD" description="PRSO(US71360T1016) SPLIT 1 FOR 40 (PRSO.OLD, PERASO INC, US71360T1016)" conid="533782050" securityID="US71360T1016" securityIDType="ISIN" cusip="71360T101" isin="US71360T1016" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" multiplier="1" strike="" expiry="" putCall="" principalAdjustFactor="" reportDate="20240103" dateTime="20240102;202500" actionDescription="PRSO(US71360T1016) SPLIT 1 FOR 40 (PRSO.OLD, PERASO INC, US71360T1016)" amount="0" proceeds="0" value="0" quantity="-350" fifoPnlRealized="0" mtmPnl="0" code="" type="RS" transactionID="646862844" actionID="131953201" levelOfDetail="DETAIL" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" figi="" issuerCountryCode="US" />

In sicer po polju:

actionDescription="PRSO(US71360T1016) SPLIT 1 FOR 40 (PRSO, PERASO INC, US71360T2006)"
actionDescription="PRSO(US71360T1016) SPLIT 1 FOR 40 (PRSO.OLD, PERASO INC, US71360T1016)"

[ddbk]

Aha, zgleda IBKR tega dogodka v reportu ne zabeleži posebej, tako da bi morali dodati še en regex v moj zgornji PR (del, ki si ga predlagal).

[RokLenarcic]

Napacno se tega lotevate. Kot prvo se ne bere descriptionov z regexi, to je preprosto slaba praksa, saj so vsi podatki v drugih atributih. V type atributu pise "RS" kar ti pove da je reverse split. V atributih isin in cusip lahko zaznas ce je prislo do spremembe. V atributih quantity imas dejansko spremembo stevila delnic (uporabljat kar izracunan ratio je napacno).

#182 recimo bo tudi zaznalo samo en rename, lahko jih je vec.

[ddbk]

Govorimo o spremembi ISIN-a, za kar ne vidim, iz katerih atributov bi lahko dobili podatek o tem, kateri ISIN je nadomestil katerega. Lahko daš kakšen primer iz flex reporta? Delno se sicer strinjam za stock split, čeprav je že implementiran in ni stvar tega ticketa. Delno zato, ker imaš v osnovi prav, vendar je glede na zgornji primer očitno možno, da stock split corporate event hkrati zajema tudi isin change, kar pomeni, da smo pri isti težavi.

O kakšnem "rename"-u iz #182 je govora?

[lukatavcer]

V tem primeru je v vsakem primeru treba nekak matchat po descriptionu, ker gre za isto pozicijo, ampak sta se hkrati ob splitu spremenita ISIN in cusip in ne gre matchat na lep način, ker ni nekega drugega unikatnega IDja.

Edit: izgleda, da bi lahko matchal po actionID: actionID="131953201", da se dobi mapping stari ISIN v novi ISIN oziroma stari cusip v novi cusip

[jamsix]

Good catch, @RokLenarcic

@ddbk @lukatavcer

Za type IC (ISIN change), FS (split) in RS (reverse split) bi tale alogoritem moral delovati:

1. Par CorporateAction poiščeš po skupnem actionID.
2. Sortiraš po transactionID v pravo zaporedje.
3. Prvi vnos pomeni stari ISIN, drugi vnos novi ISIN.
4. quantity prvega / quantity drugega je faktor (reverse) splita.

Potem pa greš v obratni smeri časovno od prodaje nazaj, množiš faktorje splita in spreminjaš ISIN za matchanje nakupov. Je pa potrebno vzeti v zakup, da pred 2020 v IB izpiskih ni isin, niti cusip, ampak samo conid.

[RokLenarcic]

Tako je, grupira se po actionID.

Problem teh transactionID je imas vsakih 100 vnosov napacno zaporedje (vsaj jaz sem imel nekaj problemov s tem pri dividendah in davkih ko je bil nek reversal vmes). Veliko bolj zanesljivo je, da ima CorporateAction s podatki za stanje prej negativen quantity, pozitivnega pa corporate action za novo stanje.

Pare CorporateAction imajo tipi IC, FS, RS, TC, SR (kar sem jaz naletel).

[jamsix]

Veliko bolj zanesljivo je, da ima CorporateAction s podatki za stanje prej negativen quantity, pozitivnega pa corporate action za novo stanje.

Razen če je bil vlagatelj v tistem trenutku v short poziciji 😅

[jamsix]

@RokLenarcic težava nastane pri forward splitu, ki ima samo 1 CorporateAction vnos:

<CorporateAction accountId="U7XXXXXX" acctAlias="" model="" currency="USD" fxRateToBase="0.97902" assetCategory="STK" symbol="GME" description="GME(US36467W1099) SPLIT 4 FOR 1 (GME, GAMESTOP CORP-CLASS A, US36467W1099)" conid="36285627" securityID="US36467W1099" securityIDType="ISIN" cusip="36467W109" isin="US36467W1099" listingExchange="NYSE" reportDate="20220722" dateTime="20220721;202500" actionDescription="GME(US36467W1099) SPLIT 4 FOR 1 (GME, GAMESTOP CORP-CLASS A, US36467W1099)" amount="0" proceeds="0" value="0" quantity="3" fifoPnlRealized="0" mtmPnl="0" code="" type="FS" transactionID="333XXXXXX" actionID="109634822" levelOfDetail="DETAIL" fineness="0.0" weight="0.0 ()" />

Tule pa je vendarle edini način, da se dobi faktor splita regex na description?

[RokLenarcic]

I guess, ampak ce isto delas pri reverse imas pa problem, da lahko imas ostanek pri deljenju, in ce delnica ne podpira fractional shares se ti en del proda. Torej ce se po 3 delnice zdruzujejo v 1 in imas 5, dobis eno novo delnico, dve se pa prodata, in quantity podatek na corporate actionu ti to pokaze, ker je -3 in 1.

[jamsix]

@RokLenarcic imamo v primeru reverse splita, kjer se del delnic proda za prodajo kak vnos? Se v primeru "ostanka" pri reverse splitu ostanek proda ali gre v frakcije? Je možno oboje?

[ddbk]

Split in ISIN change nimata nič skupnega, razen to, da se (glede na ugotovitev @lukatavcer) v primeru hkratne spremembe ISIN-a ob splitu, ta ne zabeleži z ločenim CorporateAction zapisom. Izgleda, da se tu zdaj večinoma ukvarjamo s spremembo (že izvedene) implementacije stock splitov, čeprav je bil ta issue odprt zaradi nezaznanih ISIN sprememb.

Glede drugačne implementacije ISIN sprememb (#182), dozdajšnji predlogi niso ok, ker obstajajo edge case-i, ki jih ne pokrijejo (transactionId ni vedno zaporeden, nimamo podatka ali gre za long ali short pozicije, itd.).

BTW, če stock split conversion ratio računamo sami ali ga dobimo iz regexa, ni razlike, številka bo enaka. Prodaje pa je tako ali tako treba prebirati iz Trade zapisov, ker ne moremo kar predpostavljati določenih podatkov (short/long, datum zaprtja pozicije, cena prodaje...).

[lukatavcer]

@RokLenarcic imamo v primeru reverse splita, kjer se del delnic proda za prodajo kak vnos? Se v primeru "ostanka" pri reverse splitu ostanek proda ali gre v frakcije? Je možno oboje?

ja, za prodajo je potem prisoten tudi sell vnos.

[jamsix]

@lukatavcer hvala! Imaš mogoče kak konkreten izpis CorporateAction in Trade za ta primer?