tlf67482 wrote:If the Google Finance site is anything to go by it looks like they also adjusted the figures so historical data is meaningless. I am happy to be proven wrong though - I guess the data provided in Sheets may be different.ReformedCharacter wrote:If you have a gmail account, it's pretty easy to generate historic prices in a Google sheet, using the google finance functions. I have one that covers the FTAS and a few indices, it was pretty easy to make. A drop down box to pick the share or index from a list, another to choose daily or weekly prices and 2 cells for the start and end dates. The data can the be easily copied into another spreadsheet such as Excel if required
Lloyds Bank has certainly been £8 and £7 in the past and also have recollections of it peaking at over £10/share but if the graphs on Google Finance are anything to go by Lloyds Bank has barely hit £5/share at the peak.
I understand they do this to get the graphs to work but unless they provide details on what they have done to the figures the data is useless.
If you can't get figures out that "match" contract notes I do not see how it can be trusted.
No, it's neither meaningless nor useless, it's the prices adjusted for the subsequent corporate actions, which is, in effect, the real price paid per share.
As noted above, Lloyds themselves adjust their figures also, and if you want a reliable source for LLOY historical prices, at least back to the beginning of 2007, their website would almost certainly be the best.
Methinks you are looking at this the wrong way round. It is your contract notes that (now) cannot be trusted, as they have unadjusted info in them.
You asked earlier how you go from the price in your contract note to the adjusted price shown on Yahoo/Google/etc, and the best source for that is the company's regulatory announcements. For the LLOY rights issue see "Rights Issue Factor" in their 27-Nov-2009 RNS.
However, I think I've found a source that might make you happy, at least for looking up prices on a particular day, albeit not for downloading them over a period. It's the London Stock Exchange. Go to the LLOY page there:
https://www.londonstockexchange.com/stock/LLOY/lloyds-banking-group-plc/company-page
And then choose "Max" for the period for the chart to cover. You'll note, as you roll the mouse over the chart, that it gives you monthly figures, and that it peaks at just over a fiver in April 1999. So, that's obviously also adjusted figures. Even the London Stock Exchange does it...
However, if you change that "Max" to "Custom" and stick in the popup From 1999-01-01 To 1999-12-31 and click Submit Query you'll find that the whole chart is between 600p and 800p and that if you roll the mouse over it you get daily figures, and that it peaks at 809.44 on 13-Apr-99. So that's obviously unadjusted figures.
Indeed, on a quick play it appears that as long as you set the To date to before 2009 it will show unadjusted figures. Further playing with it is left as an exercise for the reader....