HYPTUSS dividend suggestion
Posted: August 6th, 2021, 1:27 pm
Hi kiloran and installaguess
Just wanted to float an idea for the Dividends section. I don't know enough about the programming capabilities available in Libre Office (or indeed Excel) to know if this is possible but it seems worth asking.
The suggestion relates to the Update Dividends facility and is to have a check on the dates currently showing in the ex-dividend date and payable date columns where if the date being written in is older than the existing one that the update doesn't take place for that share for eithe the dates or the amount.
The reason for this is that some of the data sources have gaps in their data for certain shares - for instance SDRC Shroders non-voting, and PAF Pan African Resources - and in addition are often slow to update their data. As a result if you happen to update the sheet manually (users here often pounce on divi announcements very quickly) you often find that it is overwritten the next time you run the Update Dividends. (The same thing can happen if you change the data source for some reason.)
I currently get round this by adding additional columns - one to duplicate the payable date and one to duplicate the amount, but it would be nice to be able to protect newer information automatically.
Thaks as always for your continued work on this invaluable tool.
cheers
Spiderbill
Just wanted to float an idea for the Dividends section. I don't know enough about the programming capabilities available in Libre Office (or indeed Excel) to know if this is possible but it seems worth asking.
The suggestion relates to the Update Dividends facility and is to have a check on the dates currently showing in the ex-dividend date and payable date columns where if the date being written in is older than the existing one that the update doesn't take place for that share for eithe the dates or the amount.
The reason for this is that some of the data sources have gaps in their data for certain shares - for instance SDRC Shroders non-voting, and PAF Pan African Resources - and in addition are often slow to update their data. As a result if you happen to update the sheet manually (users here often pounce on divi announcements very quickly) you often find that it is overwritten the next time you run the Update Dividends. (The same thing can happen if you change the data source for some reason.)
I currently get round this by adding additional columns - one to duplicate the payable date and one to duplicate the amount, but it would be nice to be able to protect newer information automatically.
Thaks as always for your continued work on this invaluable tool.
cheers
Spiderbill