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.
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 - firstname.lastname@example.org 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.
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.
@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
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?
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…
@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.
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.
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, …