Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Historical quotes and handling of stock splits
Hi,
Perhaps this questions has already been asked but I couldn't find it back easily.
When retrieving quote data (thanks btw for that nifty script Maxim T), those that had a stock split in the past are causing me headaches to get fixed within the portfolio slicer report. Let me perhaps explain through an example:
Apple did a stock split in June 2014 of 7:1. I had Apple in position before that date but not anymore after the stock split.
When getting the quotes from Yahoo source (until they stopped the service) it delivered the correct historical evolution and not a restated one taking into account the stock split. Thus no adjustments needed to be done to my positions (as the split was done at a later date) and the historical quotes corresponded to my quantity held which i can easily reconcille with actual position statements from my broker.
When switching to the Google source it gives me the restated quotes which causes my historical reporting to be wrong and make weird jumps.
Now i see several ways to fix this:
- Restate the quantity to correspond again correctly with historical quotes
- Manipulate the quotes (e.g. by making a before split dummy and feed it with manual data that doesn't need to update)
However both solutions I do not really like and I usually only detect a problem when my historical performance overview is making strange shifts.
Is there a better way to deal with this? Is there a possibility to controle better which historical quotes are retrieved (actual ones or the restated ones)?
Thanks for your feedback
Perhaps this questions has already been asked but I couldn't find it back easily.
When retrieving quote data (thanks btw for that nifty script Maxim T), those that had a stock split in the past are causing me headaches to get fixed within the portfolio slicer report. Let me perhaps explain through an example:
Apple did a stock split in June 2014 of 7:1. I had Apple in position before that date but not anymore after the stock split.
When getting the quotes from Yahoo source (until they stopped the service) it delivered the correct historical evolution and not a restated one taking into account the stock split. Thus no adjustments needed to be done to my positions (as the split was done at a later date) and the historical quotes corresponded to my quantity held which i can easily reconcille with actual position statements from my broker.
When switching to the Google source it gives me the restated quotes which causes my historical reporting to be wrong and make weird jumps.
Now i see several ways to fix this:
- Restate the quantity to correspond again correctly with historical quotes
- Manipulate the quotes (e.g. by making a before split dummy and feed it with manual data that doesn't need to update)
However both solutions I do not really like and I usually only detect a problem when my historical performance overview is making strange shifts.
Is there a better way to deal with this? Is there a possibility to controle better which historical quotes are retrieved (actual ones or the restated ones)?
Thanks for your feedback
Comments
If you deleted that old file, then you have to manually adjust quotes before split. I would open and edit that file in Excel, just make sure that format after saving edited file is exactly the same.
And thanks for pointing to this problem with Google quotes - their historical prices reflect current shares, so if there was a split, then you will need to adjust these prices manually.