PDF import from Commonwealth

Just to reiterate that. In Australia, we normally use three (or four)-character security codes and registry codes (eg WTC and ASX respectively), not ISIN or WKN. Often we don’t even recognise the security name! Hence my posts re nonsense ticker codes that are unique to each quote feed provider (eg yahoo) and mean nothing to us.

1 Like

Should be:

PDF author: ''
PDFBox Version: 1.8.16
-----------------------------------------
BUY
Address - Locked Bag 22 Australia Square NSW 1215
  Telephone - 13 15 19 TAX INVOICE
  Facsimile - 1300 131 519
  Email - shares@commsec.com.au CONFIRMATION
  Internet - commsec.com.au
  Please retain for taxation purposes
  Trading, Clearing and Settlement of this transaction is undertaken by
  Commonwealth Securities Limited.
MR JOHN DOE
1 LONG ROAD
SYNDEY NSW 2000
WE HAVE BOUGHT THE FOLLOWING SECURITIES FOR YOU
COMPANY: QANTAS AIRWAYS LIMITED
QAN
SECURITY: ORDINARY FULLY PAID
DATE: 20/04/2020 UNITS AT PRICE
AS AT DATE: 20/04/2020 277 3.610000
CONFIRMATION NO: 98505191
AVERAGE PRICE: 3.610000
ORDER NO: N118818020
ACCOUNT NO: 3448833 PID 1402 HIN 88494687
ORDER COMPLETED
TOTAL UNITS: 277
CONSIDERATION (AUD): $999.00 CONTRACT COMMENTS:
BROKERAGE & COSTS INCL GST: $29.95 55685147 0404181685
(may include printed confirmation postal fee) 158
APPLICATION MONEY: $0.00
TOTAL COST: $1,029.92
TOTAL GST: $2.72
SETTLEMENT DATE: 22/04/2020
PAYMENT METHOD - DIRECT DEBIT OF CLEARED 
FUNDS FROM NOMINATED BANK A/C ON 
SETTLEMENT DATE.
1. This Confirmation Contract Note is issued by Commonwealth Securities Limited and is issued subject to:
  
  (a) The current General Conditions of Trade of Commonwealth Securities Limited ("CommSec");
  
  (b) Directions, decisions and requirements of the Market Operators, the ASIC Market Integrity Rules, the Market Operating Rules, the Clearing Rules and where relevant, the 
Settlement Rules, the customs and usages of the Market Operators, and the correction of any errors and/or omissions. Under the Rules of ASIC and the Market Operators, 
CommSec is required to act consistently with a fair and orderly market. CommSec or the Market Operators are entitled to cancel a trade without further reference to you as 
permitted by the current General Conditions of Trade and the Market Operating Rules. 
  
  If you request a Confirmation Contract Note to be sent to you by post, a $1.95 fee will be charged in addition to brokerage.
  
  Commonwealth Securities Limited ABN 60 067 254 399, AFSL 238814 is a wholly owned, but non-guaranteed subsidiary of the Commonwealth Bank of Australia ABN 48 123 
123 124 and a Participant of the ASX Group and Chi-X Australia. 
  
  Your order may have been executed as multiple market transactions across multiple trade execution venues in accordance with our Best Execution policy. This Confirmation 
specifies the volume weighted average price for those market transactions.
1 Like

Hello @Ismail_Mogal and @flywire
the PDF importer is done with your PDF debugs. If everything is ok, then this should be included in the next release.
Since this is a new importer, please check your other purchases and sales to see if there are any other fees, taxes, etc. hidden in the documents. Also, it may be that not all PDF documents are working yet. Please post them here.
If there is time, you can still implement the clearing account (cash account). Also here… just post the PDF debugs.

Greets
Alex

@Nirus thank you for your fast and efficient effort. Unfortunately, it will fail on the security code (which it seems you put in WKN). I explained the cultural reason but my communication hasn’t been effective:

As a way forward:

  1. I’m likely better placed to test the issue using SelfWealth than @Ismail_Mogal with Commsec.

  2. Resolve Create SelfWealthPDFExtractor.java by flywire · Pull Request #2340 · portfolio-performance/portfolio · GitHub.

  3. Resolve: Security code changes with data provider.

Hello @flywire ,
I have changed a few lines in the source and there should be no problems now.

  1. Screenshot → Import and automatic create the security
    grafik

  2. Screenshot → Settings from security
    grafik

  3. Screenshot → Historical courses
    grafik

  4. Screenshot → Historical courses graph

Okay?
Greetings
Alex

Looks perfect!

I don’t know how to do Step 3 without changing symbol in Step 2 to QAN.AX. Can you explain at Import CSV file - #5 by flywire?

Hello @flywire

This is not a problem. In screenshot 1, I am not changing the tickersymbol in the security settings.
It stays the way it is. As you can see in screenshot 3, you can see that I have selected yahoo finance and then the stock exchange. That’s all… :slight_smile:

Alex

1 Like

@Nirus - So Yahoo is the only default Historical Quotes Quote Feed Provider. After selecting Yahoo and XXX (Australian Stock Exchange (ASX)) the security code has a “.AX” appended to the symbol shown in Screen 2. This is the nonsense ticker code I referred to. It is not recognised when the dividends just have the three (or four)-character security code (symbol). (That’s why I’ve suggested “.AX” should be a different field.)

In Reporting Across Multiple Security Accounts - #6 by flywire the Yahoo exchange code had to be added to import DemoDistributionsMultiAcc.csv distributions. This issue wouldn’t be apparent with ISIN or WKN codes which I suspect Germans normally use.

I wouldn’t expect future buy/sell notices of the same security (with three (or four)-character security code) would work either.

@flywire
Please create me an actual PDF debug in the correct pdf importer topic. Then I can take a close look at this and work out a solution.

Alex

See PDF import from SelfWealth - #5 by flywire

Thanks for quick turn around is there a way to test it before release or you guys are happy with given PDFs.

Copy your *.xml file to test.xml, delete a test transaction. Open dummy file, File, import, PDF Blank Documents, …