How to Adjust Historical Prints for Splits & Dividends?

Discussion in 'Data Sets and Feeds' started by bellman, Feb 6, 2016.

  1. bellman

    bellman

    I have historical quotes and prints (stocks) going back 5 years, but the data is not split or dividend adjusted.

    1. Is there a tool (preferably a c# or c++ library) for adjusting historical equity prints?

    2. In case I have to build this myself, where is a good source of recorded historical splits and dividends for NYSE, NASDAQ, etc. listed equities?
     
  2. d08

    d08

    Not ideal but I use Yahoo as their format is consistent.
     
  3. bellman

    bellman

  4. d08

    d08

    I wrote it for my own use in perl and it's too custom to share but it shouldn't take more than an hour using HTML TableExtract and LWP UserAgent modules.
     
  5. Unlike their data. They often miss dividends. I would absolutely not rely on this without hand checking it per ticker.
     
    jharmon likes this.
  6. Why roll your own? There are many vendors who offer total-return series.
     
  7. bellman

    bellman

    Edit: I am not looking for the total return, rather, I am looking for the daily price adjustment data. I am not buying a total-return series--unless that can be used to calculate the daily adjustments.


    I have access to several years of historical prints and quote data. This is not cheap data, so even if there is a vendor that offers both adjusted and non-adjusted historical prints, I couldn't drop 10s of thousands of dollars to buy it. I will roll my own adjustments, because it won't take me too long to implement, and I don't have an adjusted source for this data.
     
    Last edited: Feb 8, 2016
  8. kalmar

    kalmar

  9. MarcG

    MarcG

    My favourite free source:
    http://ichart.finance.yahoo.com/x?s=" + symbol + "&a=00&b=2&c=2000&d=01&e=25&f=2018&g=v&y=0&z=30000
    Yahoo`s historical prices are often inconsistent with this data. But as already said: This is not "perfect or absolutely reliable" data.
    But I heard somewhere that this is very easy to scrape.
     
  10. bellman

    bellman

    Yes, thank you. That is what I am doing. I am scraping the data with a c# app, and have created a map which computes the adjustment ratio between any 2 dates (also have a c++ app to scrape it). Kalmar, above you, is using R to do something similar. Yahoo is the easiest source I've heard mentioned, so I am using it. Also nice that they include dividends.
     
    #10     Apr 8, 2016