OK, anyone interested can try a basic demo version here:
'https://stocklist.ai/investengine/ie_valuation_to_dividends_table.php?pdf= after the ?pdf= put the pdf you generated from IE. It works only with the full_valuation .pdf anything else will just crash out. File format will look something like this :: https://go.investengine.com/client_reports/{number}/Valuation%20Reports/{longstring}/GIA_Full_client_valuation_report_5_Mar_2024_to_5_Mar_2025.pdf after you generate the report and download it.
I’ll monitor the usage and have to kill it off if the OCR API costs I am paying for starts to ramp up.
But for now… go wild
I know “quantity” needs to be there
I know “dividend currency” needs to be there
This was made in 45 minutes.
Any feedback… shoot me a message
This kinda process can work with ANY report from any broker into any required output (cgt, dividends, prices, you name it). Just shoot me a message and I’ll see if I can build it.
1 Like
@stocklist.ai I am very impressed with this but just wanted to confirm that as part of the demo version, whether you have limited the number of funds that you will display.
I have generated 3 reports; last 12 months, last 6 months and last 1 month and with all 3 reports it does not show the complete list of ETF’s. This particular portfolio that I tested consists only of distribution ETF’s. There are no accumulating funds, so I would have understood if accumulation funds were excluded.
Other than that, I think it looks awesome, and it shows most of the important information we would like to see. Currently, it shows the dividend payment date, but it would be preferable to include the ex-date. Personally, I find knowing when the ex-dates are more important compared to the payment dates. Payment dates are nice to know, but with ex-dates you know up to when you can still buy into the fund to be eligible for the dividend payment of the new transaction.
I love it and once again thank you for all the effort you are putting into this.
Good spot @UncleBob … an error completely of my own making!!!
It was the way the PDF to Text OCR works with paragraph breaks as it split certain text string causing it to miss a few ETF ISINs. This (I hope) is now fixed.
I’ve added Ex Date
I’ve added some work around so it costs me less (but still some) in OCR costs.
1 Like
@stocklist.ai Thanks mate, looks awesome! It now shows the complete portfolio and no fund was skipped.
There is one more date to add if possiple and that is the Declare Date. So in total there are three dates that are required. Declaration Date, Ex-Dividend Date and Payment Date
To be honest the two other dates remaining dates nobody really cares about. They are “Last Day to Trade” and Record Date"
Much appreciated for all the time and effort you are putting into this.
However, a man has got to eat and it is not fair to you to carry all the costs you incur with fees and licences, so I do suggest that once you have streamlined this service and ironed out any bugs that you start looking into ways you can charge a nominal fee to cover your costs and to at the very least help you cover your counci tax bill.
I have no idea what monitization model to use, whether it is a per transaction/report upload fee, or a monthly set fee for either unlimited uploads/checks or you can step it up in bundles. I dont know.
By all means, make a profit. The difficult part is to get to an amount that is just right. From me as an end user I am willing to pay a nominal fee for as long as I feel that I get value for money from the service.
This is what it looks like when an institution has not yet declared a dividend.
