PDF import from Hargreaves Landsdown

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

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

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).

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

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

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

Screenshot 2022-09-01 at 14.01.57

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

Greetings
Alex

Amazing, thank you