Importing Awarded Shares from IBKR

[Agustin_Nunez]

I hope you’re all doing well. I’ve been using Portfolio Performance to track my investment portfolio, and it has been very helpful so far. However, I’ve encountered an issue and need your assistance to resolve it.

I use Interactive Brokers (IBKR) as my broker, and each time I make a deposit, IBKR grants me additional shares as a sort of bonus. For example, for every $1000 deposited, they award me $10 in IBKR shares. While I have successfully imported all my deposits, purchases, sales, and dividends, I cannot reconcile my account due to these additional shares granted by IBKR.

I’ve attached a screenshot of the grant activity so you can see the specific details:

My issue is that I don’t know how to enter these awarded share transactions into Portfolio Performance. I’ve tried manually adding them as new transactions, but I’m not sure if I’m following the correct procedure or if there’s a more efficient way to do it.

Has anyone faced a similar issue or knows how I can resolve this? I would appreciate any guidance or detailed steps to correctly integrate these awarded shares into my portfolio.

Thanks in advance for your help!

[Nirus]

Hello @Agustin_Nunez

Please upload a test file for the import here so that we can reproduce your problem. (*.zip)

• What is the result so far… (calculation example + minimal example + screenshot)
• How is it correct… (if necessary with calculation example on the example file)
• Why is this correct.

So, create a minimal example. Take screenshots
Add a concrete calculation example, justify your statements and then we will work on this.

Regards
Alex

[Agustin_Nunez]

Ok, first tell me if I am missing anything in the IBKR Flex query. I have selected:

Cash report
Cash transaction
Interest accruals
Trades
and I have selected Grant Activity, which is where the stock accruals are.

The whole problem is that the IBKR action only loads 11.2 and it should be 15 (the ones that don’t show up are those granted with the accruals).

[Nirus]

And now? Have you read my points?

Did you answer any of the questions or points we asked you? NO!

@Nirus

• What is the result so far… (calculation example + minimal example + screenshot)
• How is it correct… (if necessary with calculation example on the example file)
• Why is this correct.

We cannot import a screenshot into Portfolio Performance for testing purposes.
What should we do with a screenshot of an Excel spreadsheet?
How should we check it?
Do you think we are going to type out every row to somehow understand or replicate your problem?
Can you import your screenshots into Portfolio Performance?
We can’t!

So how should we check without a test file (this is called a minimal example, see my points above).

We don’t know what you selected during export and it is irrelevant - RTFM.
You have a file, an XML file, and it is imported incorrectly according to your information.

“Ich könnt in die Bulle furzen… man man man…”

[Nirus]

@Agustin_Nunez

Ok, first tell me if I am missing anything in the IBKR Flex query. I have selected:

Go to YOUTUBE - write in the search bar

• interactive brokers portfolio performance

Take a look video’s.

---

Use the search bar in this forum?

[Agustin_Nunez]

Sorry, really, I am using a translator and it is difficult for me to fully understand everything. I appreciate your help.
I am attaching the XML generated by the Flex query following the steps in the video.
PORTAFOLIO.xml (919,5 KB)

[Nirus]

@Agustin_Nunez
No problem… use deepl.com to translate your language in englisch.

[Agustin_Nunez]

Does the XML file I sent you work for you?

Actually, the XML imports correctly. The issue is that I don’t know how to automatically add what the broker gives us in their action.

[Nirus]

@Agustin_Nunez

Does the XML file I sent you work for you?

I can open and read the file.

@Agustin_Nunez

Actually, the XML imports correctly. The issue is that I don’t know how to automatically add what the broker gives us in their action.

Are these transactions included in the file?

[aujvarosy]

Hey,

Sorry about bumping this thread, but is it possible to import StockGrantActivity entries at all?

I have the data from my flex query, but when I try to import it PP just ignores them. Example entry:

<StockGrantActivities>
<StockGrantActivity accountId="U12345678" acctAlias="" model="" currency="USD" fxRateToBase="0.91423" assetCategory="STK" subCategory="COMMON" symbol="IBKR" description="INTERACTIVE BROKERS GRO-CL A" conid="43645865" securityID="US45841N1072" securityIDType="ISIN" cusip="45841N107" isin="US45841N1072" figi="BBG000LV0836" listingExchange="NASDAQ" underlyingConid="" underlyingSymbol="" underlyingSecurityID="" underlyingListingExchange="" issuer="" issuerCountryCode="" multiplier="1" strike="" expiry="" putCall="" principalAdjustFactor="" reportDate="20230802" activityDescription="Stock Award Grant for Cash Deposit" awardDate="20230802" vestingDate="20240801" quantity="0.1274" price="88.79" value="11.31" serialNumber="" deliveryType="" commodityType="" fineness="0.0" weight="0.0" />
</StockGrantActivities>

Edit: previously I’ve added them manually as inbound transfer, but I’m trying to eliminate manual work from the tracking as it’s a bit error prone.