PDF import for Banque Pictet & Cie SA

English Import/export
#1

Another for you for reference - Pictet, a Swiss bank:

Buy:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
Client: MR XXXX XXXX
Account no.: O-XXXXXX.001
Transaction no.: 781327840 | Publication date: 24.05.2022
STOCK EXCHANGE
SUBSCRIPTION
Purchase 24'728.000 PIMCO GIS-GL.LO.DUR.R/R INS.USD-ACC at USD 11.97
IN portfolio O-XXXXXX.001 ADDITIONAL INFORMATION
PIMCO GIS-GL.LO.DUR.R/R INS.USD-ACC 24'728.000 GeneralTrade date 23.05.2022
ISIN: IE00BHZKQ946    Telekurs ID: 23335253          Value date 25.05.2022Booking date 24.05.2022
Instruction
Order date 20.05.2022 at 05:06:32 pm
CASH EFFECT Order type At Marketin portfolio O-XXXXXX.001 Execution
Gross amount USD -295'994.16 Operation type PurchaseMarket place Over the counter
Swiss stamp duty USD -443.99 Execution date 24.05.2022 at 09:51:27 amExecuted quantity 24'728.000
Brokerage USD -160.03 Execution price USD 11.97Gross amount USD -295'994.16
Net amount USD -296'598.18 OtherCustodian STATE STREET FUND SERVICES
Current account O-XXXXXX.001.00.USD/Ordinary IBAN CH0000000000000000000 PIMCO GIS LTD
Yours faithfully
Banque Pictet & Cie SA
E. & O. E. Advice without signature
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 1/1  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet

Sell:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
Client: MR XXXX XXXX
Account no.: O-XXXXXX.001
Transaction no.: 794448726 | Publication date: 14.07.2022
STOCK EXCHANGE
Redemption
Sale -74.620 AGIF-CHINA A-SHARES PT GBP-ACC. at GBP 1'565.99
OUT of portfolio O-XXXXXX.001 ADDITIONAL INFORMATION
AGIF-CHINA A-SHARES PT GBP-ACC. 74.620 GeneralTrade date 14.07.2022
ISIN: LU2093580772    Telekurs ID: 51654410          Value date 20.07.2022Booking date 14.07.2022
Instruction
Order date 14.07.2022 at 10:31:43 am
CASH EFFECT in portfolio O-XXXXXX.001 Order type At MarketExecution
Gross amount GBP 116'854.17 Operation type SaleMarket place Over the counter
Brokerage GBP -127.25 Execution date 14.07.2022 at 07:37:30 pmExecuted quantity -74.620
Net amount GBP 116'726.92 Execution price GBP 1'565.99Gross amount GBP 116'854.17
Current account O-XXXXXX.001.00.GBP/Ordinary          IBAN CH0000000000000000000 OtherCustodian CLEARSTREAM VESTIMA
Yours faithfully
Banque Pictet & Cie SA
E. & O. E. Advice without signature
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 1/1  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet

Buy: (but labelled rather than subscription - maybe because it’s gold?)

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
Client: MR XXXX XXXX
Account no.: O-XXXXXX.001
Transaction no.: 761800293 | Publication date: 02.03.2022
STOCK EXCHANGE
PURCHASE
Purchase 4'834 GOLD(ISHARES PH.MET.)-ETC-11/PERP S at GBP 28.2679
IN portfolio O-XXXXXX.001 ADDITIONAL INFORMATION
GOLD(ISHARES PH.MET.)-ETC-11/PERP S 4'834 GeneralTrade date 02.03.2022
ISIN: IE00B4ND3602    Telekurs ID: 12881542          Value date 04.03.2022Booking date 02.03.2022
Instruction
Order date 02.03.2022 at 02:40:10 pm
CASH EFFECT Order type At Marketin portfolio O-XXXXXX.001 Execution
Gross amount GBP -136'647.03 Operation type PurchaseMarket place London Stock Exchange (LSE)
Swiss stamp duty GBP -204.97 (XLON)Execution date 02.03.2022 at 02:41:02 pm
Brokerage GBP -136.65 Executed quantity 4'834Execution price GBP 28.2679
Execution fees GBP -95.65 Gross amount GBP -136'647.03
Third party settlement fees GBP -3.20 OtherCustodian EUROCLEAR BANK S.A / N.V.
Transaction taxes GBP -1.04
Net amount GBP -137'088.54
Current account O-XXXXXX.001.00.GBP/Ordinary IBAN CH0000000000000000000
Yours faithfully
Banque Pictet & Cie SA
E. & O. E. Advice without signature
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 1/1  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet

Exchange:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
Client: MR XXXX XXXX
Account no.: O-XXXXXX.001
Transaction no.: 775163424 | Publication date: 26.04.2022
SECURITY EVENT
SECURITIES EXCHANGE
Exchange of securities
NOMINAL HOLDINGS in portfolio O-XXXXXX.001 ADDITIONAL INFORMATION
NINETEEN77 GBL MG.ARB.A GBP H T.REC GBP 180'000.350 GeneralTrade date 01.04.2022
ISIN: ZZ00AAE0UD 0    Telekurs ID: ZZZAAE0UD          Value date 25.03.2022Booking date 26.04.2022
Security event
OUT of portfolio O-XXXXXX.001 Ex date 01.04.2022
Taxation - NINETEEN77 GBL MG.ARB.A GBP H T.REC
NINETEEN77 GBL MG.ARB.A GBP H T.REC 180'000.350 Tax Price 100.00%GBP Taxation - NINETEEN77 GBL MER.AR.A GBP H NI S1
ISIN: ZZ00AAE0UD 0    Telekurs ID: ZZZAAE0UD          Price GBP 1'393.00
Other
IN Deposit MITSUBISHI UFJ FUND SERVICESportfolio O-XXXXXX.001 (CAYMAN) LTD
NINETEEN77 GBL MER.AR.A GBP H NI S1
Exchange ratio : 129.22 new securities for 180'000.35
old ones 129.220
ISIN: XD0414370185    Telekurs ID: 41437018          
CASH EFFECT in portfolio O-XXXXXX.001
Gross amount GBP 0.00
Net amount GBP 0.00
Current account O-XXXXXX.001.00.GBP/Ordinary IBAN CH0000000000000000000
Yours faithfully
Banque Pictet & Cie SA
E. & O. E. Advice without signature
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 1/1  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet

Distribution

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
Client: MR XXXX XXXX
Account no.: O-XXXXXX.001
Transaction no.: 797075451 | Publication date: 04.08.2022
SECURITY EVENT
Distribution
Ordinary dividend
QUANTITY HELD in portfolio O-XXXXXX.001 ADDITIONAL INFORMATION
UBS(LUX)-MSCI WOR.SOC.RES.A USD-INC 2'420 GeneralTrade date 01.08.2022
ISIN: LU0629459743    Telekurs ID: 13042150          Value date 04.08.2022Booking date 04.08.2022
Security event
Frequency Half-yearly
CASH EFFECT in portfolio O-XXXXXX.001 Ex date 01.08.2022Payment date 04.08.2022
Gross amount USD 2'304.81 Dividend - UBS(LUX)-MSCI WOR.SOC.RES.A USD-INCType Ordinary dividend
2'304.81 Quantity held 2'420Net amount USD Income per unit USD 0.9524Gross amount USD 2'304.81
Current account O-XXXXXX.001.00.USD/Ordinary          IBAN CH0000000000000000000 Other
Last distribution date 01.02.2022
Deposit SIX SIS AG
Yours faithfully
Banque Pictet & Cie SA
E. & O. E. Advice without signature
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 1/1  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet

Fx spot:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
Client: MR XXXX XXXX
Account no.: O-XXXXXX.001
Transaction no.: 762561210 | Publication date: 04.03.2022
FOREIGN EXCHANGE
SPOT
Purchase USD 490'789.99 against GBP at 1.321059
CASH EFFECT in portfolio O-XXXXXX.001 ADDITIONAL INFORMATION
Gross amount USD 490'789.99 General
490'789.99 Trade date 04.03.2022Net amount USD Value date 08.03.2022Booking date 04.03.2022
Current account O-XXXXXX.001.00.USD/Ordinary IBAN CH0000000000000000000 Instruction
Order date 04.03.2022 at 04:09:15 pm
CASH EFFECT Order type At bestin portfolio O-XXXXXX.001 Execution
Operation type Purchase
Gross amount GBP -371'512.54 Market place Over the counter
-371'512.54 Execution date 04.03.2022 at 04:09:16 pmNet amount GBP Executed amount USD 490'789.99Execution rate (GBP/USD) 1.321059
Current account O-XXXXXX.001.00.GBP/Ordinary IBAN CH0000000000000000000 Gross amount GBP -371'512.54
Other
Counterparty Banque Pictet & Cie SA
Unique trade ID 4LCYDN74UCFU5VPM4774SPOTPC
Please note: O762561210
This document constitutes and/or supplements the Confirmation or (as applicable) the transaction
advice, as referred to in the documentation pertaining to the above-mentioned transaction. Please refer
to the documentation applying to the transaction such as, but not limited to, the TOFF, the Master
Agreement (for over-the-counter derivatives transactions), the Long Form Confirmation and the Bank's
General Business Conditions (each, if applicable).
Banque Pictet & Cie SA acts for this transaction as Principal.
Yours faithfully
Banque Pictet & Cie SA
E. & O. E. Advice without signature
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 1/1  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet

Fx forward open:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
Client: MR XXXX XXXX
Account no.: O-XXXXXX.001
Transaction no.: 765087527 | Publication date: 15.03.2022
FOREIGN EXCHANGE
FORWARD (OPENING)
Purchase USD 241'514.79 against GBP at 1.3052353
IN portfolio O-XXXXXX.001 ADDITIONAL INFORMATION
Forex Forward USD/GBP, 16.03.22
(29368409) USD 241'514.79 GeneralTrade date 15.03.2022Value date 16.03.2022
ISIN: ZZ00WRSBNG 0    Telekurs ID: ZZZWRSBNG          Booking date 15.03.2022
Contract
OUT Contract no. 29368409 EMJSof portfolio O-XXXXXX.001 Opening date 15.03.2022Maturity date 16.03.2022
Forex Forward USD/GBP, 16.03.22
(29368409) GBP 185'035.44 InstructionOrder date 15.03.2022 at 03:20:53 pmOrder type At best
ISIN: ZZ00WRSBNG 0    Telekurs ID: ZZZWRSBNG          Execution
Operation type Purchase
Market place Over the counter
Execution date 15.03.2022 at 03:20:55 pm
CASH EFFECT in portfolio O-XXXXXX.001 Exchange rateSpot rate (GBP/USD) 1.3052248
Gross amount USD 0.00 Adjustment (forward rate) 0.0000105Forward rate (GBP/USD) 1.3052353
Net amount USD 0.00 OtherCounterparty Banque Pictet & Cie SA
Current account O-XXXXXX.001.00.USD/Ordinary IBAN CH0000000000000000000 Unique trade ID 4LCYDN74UCFU5VPM4774FXFWPCO765087527
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 1/2  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet
Client: MR XXXX XXXX
Account no.: O-XXXXXX.001
Transaction no.: 765087527 | Publication date: 15.03.2022
FOREIGN EXCHANGE
FORWARD (OPENING)
Purchase USD 241'514.79 against GBP at 1.3052353
CASH EFFECT in portfolio O-XXXXXX.001
Gross amount GBP 0.00
Net amount GBP 0.00
Current account O-XXXXXX.001.00.GBP/Ordinary IBAN CH0000000000000000000
Please note:
This document constitutes and/or supplements the Confirmation or (as applicable) the transaction
advice, as referred to in the documentation pertaining to the above-mentioned transaction. Please refer
to the documentation applying to the transaction such as, but not limited to, the TOFF, the Master
Agreement (for over-the-counter derivatives transactions), the Long Form Confirmation and the Bank's
General Business Conditions (each, if applicable).
Banque Pictet & Cie SA acts for this transaction as Principal.
Yours faithfully
Banque Pictet & Cie SA
E. & O. E. Advice without signature
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 2/2  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet

Fx forward close:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
Client: MR XXXX XXXX
Account no.: O-XXXXXX.001
Transaction no.: 765087587 | Publication date: 15.03.2022
FOREIGN EXCHANGE
FORWARD (CLOSURE)
Purchase USD 241'514.79 against GBP at 1.3052353
OUT of portfolio O-XXXXXX.001 ADDITIONAL INFORMATION
Forex Forward USD/GBP, 16.03.22 241'514.79 General(29368409) USD Trade date 15.03.2022Value date 16.03.2022
ISIN: ZZ00WRSBNG 0    Telekurs ID: ZZZWRSBNG          Booking date 15.03.2022
Contract
IN Contract no. 29368409 EMJSportfolio O-XXXXXX.001 Opening date 15.03.2022Maturity date 16.03.2022
Forex Forward USD/GBP, 16.03.22 185'035.44 Instruction(29368409) GBP Order date 15.03.2022 at 03:21:00 pmOrder type At best
ISIN: ZZ00WRSBNG 0    Telekurs ID: ZZZWRSBNG          Execution
Operation type Purchase
Market place Over the counter
Execution date 15.03.2022 at 03:21:02 pm
CASH EFFECT Executed amount USD 241'514.79in portfolio O-XXXXXX.001 Execution rate (GBP/USD) 1.3052353
Gross amount GBP -185'035.44
Gross amount USD 241'514.79 Exchange rate
Net amount USD 241'514.79 Spot rate (GBP/USD) 1.3052248Adjustment (forward rate) 0.0000105
Forward rate (GBP/USD) 1.3052353
Current account O-XXXXXX.001.00.USD/Ordinary IBAN CH0000000000000000000 Other
Counterparty Banque Pictet & Cie SA
Unique trade ID 4LCYDN74UCFU5VPM4774FXFWPC
O765087527
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 1/2  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet
Client: MR XXXX XXXX
Account no.: O-XXXXXX.001
Transaction no.: 765087587 | Publication date: 15.03.2022
FOREIGN EXCHANGE
FORWARD (CLOSURE)
Purchase USD 241'514.79 against GBP at 1.3052353
CASH EFFECT in portfolio O-XXXXXX.001
Gross amount GBP -185'035.44
Net amount GBP -185'035.44
Current account O-XXXXXX.001.00.GBP/Ordinary IBAN CH0000000000000000000
Please note:
This document constitutes and/or supplements the Confirmation or (as applicable) the transaction
advice, as referred to in the documentation pertaining to the above-mentioned transaction. Please refer
to the documentation applying to the transaction such as, but not limited to, the TOFF, the Master
Agreement (for over-the-counter derivatives transactions), the Long Form Confirmation and the Bank's
General Business Conditions (each, if applicable).
Banque Pictet & Cie SA acts for this transaction as Principal.
Yours faithfully
Banque Pictet & Cie SA
E. & O. E. Advice without signature
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 2/2  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet

Cash withdrawal:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
Client: MR XXX XXXX
Account no.: O-XXXXXX.001
Transaction no.: 777078531 | Publication date: 04.05.2022
PAYMENT TRANSACTIONS
PAYMENT
CASH EFFECT in portfolio O-XXXXXX.001 ADDITIONAL INFORMATION
Gross amount GBP -4'269.38 General
-4'269.38 Trade date 04.05.2022Net amount GBP Value date 04.05.2022Booking date 04.05.2022
Current account O-XXXXXX.001.00.GBP/Ordinary IBAN CH0000000000000000000 Order date 04.05.2022 at 09:21:20 am
Payment
Beneficiary STANHOPE CAPITAL
(SWITZERLAND) SA
IBAN CH00 0000 0000 0000 0000 0
Bank CREDIT SUISSE (SCHWEIZ) AG
Country Switzerland
Communication MANAGEMENT FEES MARCH 2022
INVOICE INV005045
Gross amount GBP 4'269.38
Yours faithfully
Banque Pictet & Cie SA
E. & O. E. Advice without signature
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 1/1  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet
Buchungen aus PDF-Dateien importieren
#2

Hello @Abacus6923
i looked at the PDF debug of you and unfortunately i don’t understand some of them.

I need the following information:
Exchange
OUT of portfolio means as much as sale or is this a delivery?
Please explain in detail the transaction!

Name -> NINETEEN77 GBL MG.ARB.A GBP H T.REC GBP
ISIN -> ZZ00AAE0UD 
Amount -> GBP 180,000.350
Shares -> ?!?!? How many will be sold?

IN Deposit → means as much as purchase or is this a deposit into the depot?

Name -> NINETEEN77 GBL MER.AR.A GBP H NI S1
ISIN -> XD0414370185    
Amount -> GBP 180'000.350
Shares -> 129.22

Fx spot:
Is money posted to a settlement account here?
Please explain in detail the transaction!

Fx forward open:
The same questions as with the Exchange PDF Debug…
Please explain in detail the transaction!

Fx forward close:
The same questions as with the Exchange PDF Debug…
Please explain in detail the transaction!

Cash withdrawal:
The same questions as with the Fx spot…
Please explain in detail the transaction!

The other PDF debugs, that is

  • Buy:
  • Sell:
  • Buy: (but labelled rather than subscription - maybe because it’s gold?)
  • Distribution

I have edited.

Greetings
Alex

#3

Hi Alex,

Exchange: I am not actually sure, I will see if I can find out.
FX spot:

there’s a deposit account that holds USD/EUR/GBP/etc - you can see these referenced as Current account O-XXXXXX.001.00.USD/Ordinary and O-XXXXXX.001.00.GBP/Ordinary in these examples. The spot is shifting between those. Purchases for a security then comes out of the relevant currency balance.

Screenshot 2022-09-04 at 23.02.04

Forward: I think was essentially a spot trade as the forward open/closed within 24 hours, again shifting the cash balances between currencies.

Cash withdrawal: This is withdrawing from the deposit account, in this case the GBP denominated one.

Hope that helps. Definitely not the end of the world if these can’t be supported though!

#4

@Nirus could you please redact the IBAN from the PR and force-push to the branch to remove from the history, before anything gets merged? @Thomas had kindly already amended my examples above. Apologies for the hassle. Many thanks

1 Like
#5

thanks @Nirus - apologies if I’m stating the obvious, but you’ll need to either squash the commits & force-push to your branch, or merge with a squash so that the commit history doesn’t preserve the IBAN.

1 Like
#6

@Nirus, just tested your PR and found some edge cases with some other sample data for buy/sell transactions. Sometimes the purchase line can look like this:

Purchase GBP 179'558.150 NINETEEN77 GBL MG.ARB.A GBP H T.REC at 100.00%

instead of

Purchase 24'728.000 PIMCO GIS-GL.LO.DUR.R/R INS.USD-ACC at USD 11.97

And the net amount sometimes like this:

Net amount OtherGBP -196'855.38 Custodian BNP PARIBAS SECURITIES

instead of

Net amount GBP -196'855.38 Custodian BNP PARIBAS SECURITIES
#7

Hello @Abacus6923
We only create and modify PDF importers with correct and valid PDF debugs. We do not work with partial PDF debugs as this has caused many problems in the past, so we validate PDF debugs before making changes.

Please create a PDF debug and post it here.
The best way to see how this works is to watch the video tutorial.

Video Tutorial:
Extract PDF documents for debugging

Greetings
Alex

#8

Sure, here you go :slight_smile:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.2.qualifier
-----------------------------------------
Client: MR X Y
Account no.: O-000000.001
Transaction no.: 763915602 | Publication date: 24.03.2022
STOCK EXCHANGE
SUBSCRIPTION
Purchase GBP 179'558.150 NINETEEN77 GBL MG.ARB.A GBP H T.REC at 100.00%
IN portfolio O-000000.001 ADDITIONAL INFORMATION
NINETEEN77 GBL MG.ARB.A GBP H T.REC GBP 179'558.150 GeneralTrade date 31.03.2022
ISIN: ZZ00AAE0UD 0    Telekurs ID: ZZZAAE0UD          Value date 25.03.2022Booking date 24.03.2022
Instruction
Order date 10.03.2022 at 08:00:55 am
CASH EFFECT Order type Good till cancelin portfolio O-000000.001 Order validity 29.12.2023 at 11:59:59 pm
Gross amount GBP -179'558.15 ExecutionOperation type Purchase
Swiss stamp duty GBP -269.34 Market place Over the counterExecution date 22.03.2022 at 04:22:37 pm
Brokerage GBP -249.81 Executed nominal GBP 179'558.150Execution price 100.00%
Net amount GBP -180'077.30 Gross amount GBP -179'558.15Other
Current account O-000000.001.00.GBP/Ordinary IBAN AA0000000000000000000 Custodian MITSUBISHI UFJ FUND SERVICES
(CAYMAN) LTD
Yours faithfully
Banque Pictet & Cie SA
E. & O. E. Advice without signature
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 1/1  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet


PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.2.qualifier
-----------------------------------------
Client: MR X Y
Account no.: O-000000.001
Transaction no.: 761800107 | Publication date: 02.03.2022
STOCK EXCHANGE
PURCHASE
Purchase 1'497 LYXOR-BL.EQ.WEI.COM EX-AG I ETF at GBP 131.1975
IN portfolio O-000000.001 ADDITIONAL INFORMATION
LYXOR-BL.EQ.WEI.COM EX-AG I ETF 1'497 GeneralTrade date 02.03.2022
ISIN: LU0419741177    Telekurs ID: 10239604          Value date 04.03.2022Booking date 02.03.2022
Instruction
Order date 02.03.2022 at 02:39:22 pm
CASH EFFECT Order type At Marketin portfolio O-000000.001 Execution
Gross amount GBP -196'402.66 Operation type PurchaseMarket place London Stock Exchange (LSE)
Swiss stamp duty GBP -294.60 (XLON)Execution date 02.03.2022 at 02:40:24 pm
Brokerage GBP -157.12 Executed quantity 1'497Execution price GBP 131.1975
Transaction taxes GBP -1.00 Gross amount GBP -196'402.66
Net amount OtherGBP -196'855.38 Custodian BNP PARIBAS SECURITIES
SERVICES
Current account O-000000.001.00.GBP/Ordinary IBAN AA0000000000000000000
Yours faithfully
Banque Pictet & Cie SA
E. & O. E. Advice without signature
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 1/1  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet
#9

Hello @Abacus6923
In the first PDF debug (here) the ISIN is not complete.
The ISIN must consist of 12 characters. Is this a bug?
Are this percent notation? (Shares?)
Check this please.

The second one I have already added.

The other transactions e.g. here i will add later. Today I’m just busy.

Alex

#10

It looks like these are all OTC trades.

Screenshot 2022-09-06 at 18.44.54

Here is another

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.2.qualifier
-----------------------------------------
Client: MR X Y
Account no.: O-000000.001
Transaction no.: 766962817 | Publication date: 25.03.2022
STOCK EXCHANGE
SUBSCRIPTION
Purchase GBP 180'000 6.516% MS (SX5E/SPX) 22/23 at 100.00%
IN portfolio O-000000.001 ADDITIONAL INFORMATION
6.516% MS (SX5E/SPX) 22/23 GBP 180'000 GeneralTrade date 23.03.2022
ISIN: XS2425022303    Telekurs ID: 110605684          Value date 28.03.2022Booking date 25.03.2022
Instruction
Order date 22.03.2022 at 05:45:26 pm
CASH EFFECT Order type At Marketin portfolio O-000000.001 Execution
Gross amount GBP -180'000.00 Operation type PurchaseMarket place Over the counter
Interest GBP 0.00 Execution date 23.03.2022 at 08:26:01 amExecuted nominal GBP 180'000
Brokerage GBP -180.00 Execution price 100.00%Gross amount GBP -180'000.00
Net amount GBP -180'180.00 OtherCustodian EUROCLEAR BANK S.A / N.V.
Current account O-000000.001.00.GBP/Ordinary IBAN AA0000000000000000000
Yours faithfully
Banque Pictet & Cie SA
E. & O. E. Advice without signature
0A01 Banque Pictet & Cie SA / Route des Acacias 60 / 1211 Genève 73 / Switzerland 1/1  
Tel. +41 58 323 23 23 / Fax +41 58 323 23 24 / group.pictet
1 Like