PDF author: ''
PDFBox Version: 1.8.16
-----------------------------------------
SELL
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.
XXX XXXX XXXX
2 XXXXX XXXX
ST XXXXX XXX XXXX
WE HAVE SOLD THE FOLLOWING SECURITIES FOR YOU Ex Dividend
COMPANY WISETECH GLOBAL LIMITED
SECURITY ORDINARY FULLY PAID WTC
DATE: 09/09/20XX
AS AT DATE: 09/09/20XX UNITS AT PRICE
CONFIRMATION NO: XXXXXXX 1,000 28.060000
ORDER NO: NXXXXXX
ACCOUNT NO: XXXXXX AVERAGE PRICE: 28.060000
TOTAL UNITS: 1,000
CONSIDERATION (AUD): $28,060.00 PID XXXX HIN XXXXXXX
BROKERAGE & COSTS INCL GST: $28.06 ORDER COMPLETED
(may include printed confirmation postal fee) CONTRACT COMMENTS:
APPLICATION MONEY: $0.00
XXXXXXXX XXXXXXXXX
NET PROCEEDS: $28,031.94
TOTAL GST: $2.55 105
SETTLEMENT DATE: 11/09/20XX
PAYMENT METHOD - DIRECT CREDIT TO NOMINATED
SETTLEMENT A/C ON SETTLEMENT DAY. FUNDS AVAILABLE
FOLLOWING DAY.
If not already provided, Security Document and/or Holder Information to be provided by 11/09/2020
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.
2. Credits from sales of securities are not available until the settlement date and all documents and security holder information have been delivered to Commonwealth Securities
Limited and verified through CHESS Settlement Facility, if a CHESS Participant Sponsored Holding security has been sold. Subject to the relevant Terms and Conditions, the
proceeds of your sale will be paid to you in accordance with your standing instructions on the settlement date, unless otherwise agreed.
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.
Would be better with dummy data (eg fake names) than X for characters and numbers.
Very good. I’ll get on it and implement the importer in PP. Since this is a new importer, please check the other purchases, sales, income and dividends to see if there are any other fees, taxes, etc. hiding in the documents. Also, it may be that not all PDF documents are working yet. Please post them here.
I have attached BUY and SELL, for dividends will be quite complex, get different PDF from different companies.
Same for SelfWealth - dividend notices come from the companies in different formats.
Then please post these PDF debugs here, analogous to these you have posted so far. The more examples we have, the better the importer will work and recognize and process all documents.
If they are documents from SelfWeath, then post → here ← . If they are documents from CommSec, then post here.
@Nirus, dividend statements are TOTALLY different from each company and it has nothing to do with Commsec or SelfWealth or share registry (Stock transfer agent ), it’s the company.
I think bank statements and cashbook reports are the way to go for Australian dividends. eg https://templatelab.com/bank-statement/
1 Like
Hallo @flywire
Okay, then please open a new post for this analogous to CommSec and SelfWealth. Post the PDF debugs here, then they can be implemented in PP.
@Nirus - anyone looked at this request - ASX feature request · Issue #2351 · buchen/portfolio · GitHub.
I can’t find my post here for the LIFO request.
I am looking for the ISIN or WKN and the name of the security in your PDF debugs. Did you delete these by any chance?
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:
-
I’m likely better placed to test the issue using SelfWealth than @Ismail_Mogal with Commsec.
-
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.
-
Screenshot → Import and automatic create the security
-
Screenshot → Settings from security
-
Screenshot → Historical courses
-
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… 
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.