Daily historical data SP500 total return (with dividends)

Check out "Quandl", they have the data (for free).
Below is a code snip for my extraction of dividend data:
" $url = 'https://www.quandl.com/api/v1/datasets/SEC/DIV_' .$sym_mod.'.csv?auth_token='.$quandlAuthToken;"
Line above is dynamically producing an URL, which is subsequently used to pull out the data. Note: I am using their api interface, and tacking on the symbol, then an authorization token. (in this line "$sym_mod" is the portion related to the symbol name.) The Quandl interface also provides access to the yahoo data you reference.
Example for spy: "https://www.quandl.com/api/v1/datasets/SEC/DIV_SPY.csv?"
 
stepandfetchit said:
Check out "Quandl", they have the data (for free).
Below is a code snip for my extraction of dividend data:
" $url = 'https://www.quandl.com/api/v1/datasets/SEC/DIV_' .$sym_mod.'.csv?auth_token='.$quandlAuthToken;"
Line above is dynamically producing an URL, which is subsequently used to pull out the data. Note: I am using their api interface, and tacking on the symbol, then an authorization token. (in this line "$sym_mod" is the portion related to the symbol name.) The Quandl interface also provides access to the yahoo data you reference.
Example for spy: "https://www.quandl.com/api/v1/datasets/SEC/DIV_SPY.csv?"
More...

Thank you. I'm not familiarized with Quandl, so it's a bit confusing, it seems like I have to download an add-in for excel or something like that. From which years does it provide the kind of information that I'm looking for?
 
Timetwister:
This mechanism accesses the complete history (available to quandl). In the example link earliest dividend data is "1993-03-19,0.213"
I pull the data down (via a Perl program) and store locally as .csv files, which I then process with my backtest tool. The .csv files can be opened with Excel if you like.
The link above is for Dividends. Different references are needed to access the daily price data.
Please note that the original link you provide from yahoo can be used to extract the dividend information from the price and adjusted price columns, but seem to recall not having identical format for all security symbols I was interested in, so handle the Dividend and the daily pricing separately.
 
stepandfetchit said:
Timetwister:
This mechanism accesses the complete history (available to quandl). In the example link earliest dividend data is "1993-03-19,0.213"
I pull the data down (via a Perl program) and store locally as .csv files, which I then process with my backtest tool. The .csv files can be opened with Excel if you like.
The link above is for Dividends. Different references are needed to access the daily price data.
Please note that the original link you provide from yahoo can be used to extract the dividend information from the price and adjusted price columns, but seem to recall not having identical format for all security symbols I was interested in, so handle the Dividend and the daily pricing separately.
More...

I see, thanks. But I'm looking for older data. As you say, if I wanted information from 1993 I could just download it from Yahoo.
 
hs.png
 
You must log in or register to reply here.
Back
Top