PDF import from Hargreaves Landsdown

English Import/export
1

Hi, just adding some Hargreaves Landsdown (major platform in the UK) examples here for reference too. Many thanks.

Buy:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
One College Square South, Anchor Road, Bristol, BS1 5HL
Vantage Share Dealing: (0117) 980 9800  Vantage Fund Dealing: (0117) 980 9807  Vantage Helpdesk: (0117) 900 9000   www.h-l.co.uk
Hargreaves Lansdown is a trading name of Hargreaves Lansdown Asset Management Limited.
Authorised & Regulated by the Financial Conduct Authority, No. 115248 Company Registration No. 01896481. 
A member firm of the London Stock Exchange. VAT No. GB 433 8716 440. A Wholly Owned Subsidiary of Hargreaves Lansdown Plc
Contract Note
Mr XXX XXX
Apartment XXX
XXXXX
London
XXXX XXX
A/C Designation : 
Date 15/10/2021 Time 09:47 Contract Note No. B105372223-01000000
(To be quoted in all correspondence)
We have today on your instructions **BOUGHT** the security detailed below.
IMPORTANT Please check all details are correct. You should advise us of any discrepancy immediately
Quantity Security Price Consideration
IE00B4X9L533 STOCK CODE: HMWO
HSBC ETFs Plc
2,539.00 MSCI World ETF GBP 2267.4179 57,569.74
Market Order
Venue of Execution: London Stock Exchange (XLON)
Commission 11.95
These shares / units have been dealt using the following account:
HL SIPP Settlement Date: 19/10/2021 57,581.69
E and OE
Note: Retain this document as a record of your investment. 
Always quote your client number and contract note number in correspondence. 
This contract is subject to our normal terms and conditions of business and may also be subject to the rules of 
the London Stock Exchange. 
Details of any commission shared with third parties is available upon request.
HL ASSCON 03130

Buy:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
One College Square South, Anchor Road, Bristol, BS1 5HL
Vantage Share Dealing: (0117) 980 9800  Vantage Fund Dealing: (0117) 980 9807  Vantage Helpdesk: (0117) 900 9000   www.h-l.co.uk
Hargreaves Lansdown is a trading name of Hargreaves Lansdown Asset Management Limited.
Authorised & Regulated by the Financial Conduct Authority, No. 115248 Company Registration No. 01896481. 
A member firm of the London Stock Exchange. VAT No. GB 433 8716 440. A Wholly Owned Subsidiary of Hargreaves Lansdown Plc
Contract Note
Mr XXX XXX
XXXX
XXXX
XXXX
London
XX XXX
A/C Designation : 
Date 03/04/2017 Time 08:00 Contract Note No. B918390061-01000000
(To be quoted in all correspondence)
We have today on your instructions **BOUGHT** the security detailed below.
IMPORTANT Please check all details are correct. You should advise us of any discrepancy immediately
Quantity Security Price Consideration
GB00BG0QPJ30
Legal & General UK Index
1,043.478 Class C - Accumulation (GBP) 287.500000 3,000.00
Venue of Execution: The manager of the unit trust
These shares / units have been dealt using the following account:
HL Vantage SIPP Settlement Date: 07/04/2017 3,000.00
E and OE
Note: Retain this document as a record of your investment. 
Always quote your client number and contract note number in correspondence. 
This contract is subject to our normal terms and conditions of business and may also be subject to the rules of 
the London Stock Exchange. 
Details of any commission shared with third parties is available upon request.
HL ASSCON 03130

Sell:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
One College Square South, Anchor Road, Bristol, BS1 5HL
Vantage Share Dealing: (0117) 980 9800  Vantage Fund Dealing: (0117) 980 9807  Vantage Helpdesk: (0117) 900 9000   www.h-l.co.uk
Hargreaves Lansdown is a trading name of Hargreaves Lansdown Asset Management Limited.
Authorised & Regulated by the Financial Conduct Authority, No. 115248 Company Registration No. 01896481. 
A member firm of the London Stock Exchange. VAT No. GB 433 8716 440. A Wholly Owned Subsidiary of Hargreaves Lansdown Plc
Contract Note
Mr XXX XXX
XXXX
XXXX
XXXX
XXXX
A/C Designation : 
Date 27/03/2019 Time 11:46 Contract Note No. S362136892-01000000
(To be quoted in all correspondence)
We have today on your instructions **SOLD** the security detailed below.
IMPORTANT Please check all details are correct. You should advise us of any discrepancy immediately
Quantity Security Price Consideration
GB00BKX5CN86 STOCK CODE: JE.
Just Eat plc
132.00 Ordinary Shares 1p 752.896 993.82
Market Order
Venue of Execution: London Stock Exchange (XLON)
Commission 11.95
These shares / units have been dealt using the following account:
HL SIPP Settlement Date: 29/03/2019 981.87
E and OE
Note: Retain this document as a record of your investment. 
Always quote your client number and contract note number in correspondence. 
This contract is subject to our normal terms and conditions of business and may also be subject to the rules of 
the London Stock Exchange. 
Details of any commission shared with third parties is available upon request.
HL ASSCON 03130


PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
Hargreaves Lansdown is a trading name of Hargreaves Lansdown Asset Management Limited. 
Authorised and regulated by the Financial Conduct Authority, No. 115248 Company registered in England 
and Wales No. 1896481. A member firm of the London Stock Exchange. VAT No. GB 433 8716 440. 
A Wholly Owned Subsidiary of Hargreaves Lansdown Plc.
One College Square South
Contract Note Anchor RoadBristol
BS1 5HL
Mr XXXX XXXX Share Dealing: 
XXXX (0117) 980 9800  
XXXX Fund Dealing: 
XXXX
XXXX (0117) 980 9807  
Helpdesk: 
(0117) 900 9000          
www.hl.co.uk
A/C Designation : 
Date 25 /01/202 2                                      Time  09:35                       Contract Note No. S186039383-01000000
                   (To be quoted in all correspondence)
We have today on your instructions    ** SOL D**                 the security detailed below.
IMPORTANT Please check all details are correct. You should advise us of any discrepancy immediately
Quantity Security                                                                                                                                                                                                                                       Price Consideration
IE00BKX55S42 STOCK CODE: VERX
Vanguard Funds plc
5,700.00 FTSE Developed Europe ex-UK UCITS ETF 3022.8001 172,299.61
Market Order
Venue of Execution: London Stock Exchange (XLON)
Commission 11.95
These shares / units have been dealt using the following account:
                                                                                                                                                                          
HL Fund & Shar  e        A       c     c     o      u      n      t                                                                                                      Settlement Date: 27/01/2022 172,287.66
E and OE
Note:  
Retain this document as a record of your investment. 
Always quote your client number and contract note number in correspondence. 
This contract is subject to our normal terms and conditions of business and may also be subject to the rules of the London Stock Exchange. 
Details of any commission shared with third parties is available upon request.
1 Like
2

Hello @Abacus6923
I was looking at your PDF debugs and have a question about them.
What is the base currency in the documents?
Unfortunately this is not visible. Is this EUR, USD or GBP?

Greetings
Alex

3

Hi Alex - these are all GBP though it is weird it doesn’t say so on the contract PDFs (just checked). I’ve tried to find one where I buy something quoted in USD but it doesn’t look like I have any for Hargreaves, sorry. Either way they’ll convert back to GBP though (you can’t pay Hargreaves in USD/EUR directly).

4

Hello @Abacus6923
I have edited your PDF debug and implemented the new importer.
If everything is ok, this should be included in the next release.

I hope that I have done the calculation of the proportions correctly.

As an example:
5,700.00 FTSE Developed Europe ex-UK UCITS ETF 3022.8001 172,299.61

172299,61 GPB / 3022,8001 = 57 shares
However, the document states the shares as 5700.00, so I think this needs to be divided by 100.
Can you please check this again?

Greeting
Alex

5

Hello @Abacus6923

Is it also possible that the amounts in the documents are in GBX and not in GBP? If so, I would still change this.

Greetings
Alex

6

@Nirus apologies, in looking closer - the price is in GBX and the consideration is in GBP

Screenshot 2022-09-01 at 14.01.57

7

Hello @Abacus6923
Thank you for the information.
I have implemented the changes.

Greetings
Alex

8

Amazing, thank you

1 Like
9

Great, thanks @Nirus! AJ Bell don’t give branded PDF statements for dividend statements, but they offer to print from a webpage a statement with a breakdown. See this example. Happy to dig out more if useful.

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
Corporate action detail
Account XXXXXXXX Mr XXXX XXXX
Account type Dealing account
Investment HSBC OPENFUNDS GLOBAL STRATEGY DYNAMIC PTF C ACC
TrEaxn dsataection h16is/1t0o/2r0y21: Dealing account
MrP aJya dmaetes XXXX1e5y/1(2A/2B0281KHQD)
01H/o0l9di/n2g022 11:31629:60761.84
DGaroteup 1 holdingTransa0ction Description Quantity Amount Reference
Group 1 pay rate GBP 0.0171 (£)
1G7r/o0u3p/ 210 p2a2ymePnturchaGseBP 0 HSBC Global Strategy 13,250.22 30,000.00 44622C3K9R2
Group 1 tax GBP 0 Balanced C Acc
1 4/02/2022 Purchase HSBC Global Strategy 12,603.22 29,001.50 44622C2GTW5
Balanced C Acc
Group 2 holding 169,671.84
3G1r/o0u1p/ 220 p2a2y ratPeurchaGseBP 0.0029 Royal London Sustainable 9,218.9613 30,000.00 44622C1X3KJ
World C Acc
Equalisation rate GBP 0.0142
27/01/2022 Purchase HSBC Global Strategy 17,330.37 40,000.00 44622C1WK1D
Group 2 payment GBP 492.04 Balanced C Acc
Group 2 Tax GBP 0
27/01/2022 Purchase Royal London Sustainable 5,849.4088 18,801.50 44622C1WHN4
Equalisation GBP 2409.34 World C Acc
24/01/2022 Purchase HSBC Global Strategy 12,908.78 30,001.50 44622C1RHW8
Balanced C Acc
24/01/2022 Purchase HSBC Global Strategy 21,513.99 50,000.00 44622C1QRVP
Balanced C Acc
17/01/2022 Purchase Royal London Sustainable 17,683.0239 60,000.00 44622C1HWF2
World C Acc
12/01/2022 Purchase Royal London Sustainable 4,107.1949 14,101.50 44622C1B5N5
World C Acc
12/01/2022 Purchase Royal London Sustainable 7,282.2604 25,001.50 44622C1B3MT
World C Acc
11/01/2022 Purchase Royal London Sustainable 3,500.1459 12,000.00 44622C090V0
World C Acc
11/01/2022 Sale Premier Miton UK Multi Cap Inc 6,100 13,668.60 44622C09X2G
B Inc Ins
11/01/2022 Sale HSBC Global Sustainable MA 18,435.48 25,623.82 44622C090VC
Dyn C Acc
11/01/2022 Sale Gold Bullion Securities GBP 40 4,931.02 44622C09XX2
11/01/2022 Sale UBS(Lux)FS MSCI EM SRI 601 6,860.80 44622C09XT9
USD Adis GBP
31/12/2021 Equalisation Acc Vanguard FTSE Glb All Cp Idx £ 0 805.88 44622##0086
Units Acc
31/12/2021 Accumulation Vanguard FTSE Glb All Cp Idx £ 0 1,694.55 44622##0086
Distribution Acc

Also, I found a buy that was buying denominated in USD, but it doesn’t look like they give any currency conversion info:



PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
XXXXXXX CONTNOTE                      05122019 XXXXXX     000000049992168 44619C5L6BV
Tel: 0845 373 3479
Email: dealingservices@Youinvest.co.uk
Mr XXXX XXXX
XXXX
XXXX
XXXX
UNITED KINGDOM
XXXXXXXX
CONTRACT NOTE
Account No. XXXX AJ Bell Youinvest Dealing account for Mr XXX XXXX
     Deal date           Time Settlement date Bought or Sold          Sedol Reference
05/12/19 10.22 09/12/19 Bought BDGSVH2 C5L6BV
We have bought for you as agent
XTRACKERS (IE) PLC MSCI WLD INFO TECHNOLOGY UCITS ETF 1C
Venue Quantity Price Consideration
XLON                   380 26.23712         9,970.11 GBP
Dealing charge          9.95 GBP
                     _____________    
                                     
Total debit      9,980.06 GBP
Order type: Market order
This transaction is subject to the rules of the London Stock Exchange
Dealing services for AJ Bell Youinvest are provided by AJ Bell Securities Limited (company number 2723420)
whose registered office is: 4 Exchange Quay, Salford Quays, Manchester M5 3EE .
AJ Bell Securities Limited is a member of the London Stock Exchange and is authorised and regulated by the Financial Conduct Authority (number 155593)

Many thanks!

10

Hello @Abacus6923

I have added the purchase as well.

We are not able to process the dividend posting. Reason is that this is not an original PDF document, but as you mentioned it is a web print.
We only process documents created by the bank, because of the different converters to PDF is not possible. Please talk to your bank to provide you with these documents in PDF. They are obliged to do so.

Greetings
Alex

11

@Nirus, understood - I will ask. Hargreaves similarly does not provide any PDF format for dividends.

1 Like