StepOne wrote:Gengulphus wrote:How tedious... It creates a load of scattered updates I need to make in my records, especially to tickers, and if I miss some simply by not immediately remembering that they're there, I'll encounter problems later when I eventually spot that a spreadsheet isn't updating correctly, or that it's complaining that I've tried to match a sale of one share to a purchase of another, or other similar problems. Nothing major, but there will be a load of scattered bits of unexpected admin work triggered by noticing that something isn't right, or rather worse, errors caused by failing to notice something that isn't right... And while I accept that sometimes, shareholders have to accept such extra admin work for the benefit of the company, and that name changes can be to the company's benefit if they alter its image in some significant way or (very rarely, but I've encountered it once) are legally required, but I cannot see that a change from "BHP Billiton" to "BHP Group" does anything like that...
You could always create your own key for identifying companies and use that in all your spreadsheets and then just create one lookup table to map your key to the genuine ticker. (That's if you need the ticker at all - I'm guessing you use it to pull prices using a macro?). I'm not sure I need to post this as I'm pretty sure it's an option you will have considered anyway, but posting anyway just on the off-chance and in case anyone else might be interested.
Thanks. Agreed that it's an option, but it would involve quite a bit of work on my existing spreadsheets (*) - a good deal more than the changes required to them to deal with the change on a more
ad hoc basis. It would of course be a solution to this ticker / name change
and all future ones, whereas the
ad hoc solution is only one to this ticker / name change, so it would eventually be less work overall - but ticker / name changes aren't all that frequent. So in terms of the use of my time, your solution requires a fairly large 'capital' outlay to obtain irregular and not-very-frequent 'income' type returns in the form of future 'cost' reductions. So far, I haven't found that bargain compelling and so have stuck with the
ad hoc solution. And while the
ad hoc solution is always a bit tedious, I'll generally accept that tedium reasonably happily if it's part of a bigger corporate action (e.g. Six Continents (SXC) changing its name & ticker to Intercontinental Hotels (IHG) as part of its demerger of Mitchells & Butlers) or I can see a reasonably concrete reason for the change. And even in cases like this one, I'll still accept it - but I do get a bit irritated in the process!
(*) I will totally agree with OZYU that my spreadsheets could have originally been designed much better! Basically, they, their purposes and my spreadsheet expertise have all grown over the many years since I started keeping my records in spreadsheets, and since I've acquired the required spreadsheet expertise, the job of redesigning and rewriting them from scratch (and testing the results thoroughly!) has always been too daunting in the light of other things I need or want to do...
Those many years are incidentally also a major part of the reason I don't use HYPTUS - I already had my spreadsheets going and working pretty well before HYPTUS first appeared. The other major part is that my spreadsheets deal with CGT calculations - not entirely automatically, but enough to greatly speed them up and make them less error-prone.
Gengulphus