Added Quantquote data #4
Open
Conversation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
Added support for free high quality daily S&P500 data from Quantquote to Data.Access.py .
Original Thread at Coursera CI Forums:
https://class.coursera.org/compinvesting1-2012-001/forum/thread?thread_id=4999
copy/paste:
After trying out QSTK and building some indicators etc. i quickly noticed that the Yahoo data is nice to try some features out but not reliable enough to build strategies on it - there are many gaps, unfiltered spikes and simply wrong prices in it.
After some searching on the web I found Quantquote - they provide high quality daily S&P500 data for free! (The only caveat is that it´s only updated quarterly - however for backtesting the data is just fine).
The Quantquote data comes fully adjusted (but with all adjustments fully documented) and additionally includes "earnings days" which is valuable for backtesting reasons, because stocks often behave differently on these days.
How to get the data into QSTK
Get the Quantquote data here ( https://quantquote.com/historical-stock-data - Free Data) and place the .csv files into /QSTK/QUSData/Quantquote .
Change DataAccess.py in /QSTK/qstkutil to the new version (you can just copy+paste the whole file).
Additional remarks
Use via DataAccess('Quantquote')
Available data columns: open, high, low, close, volume, splits, earnings, dividends
Please note: actual_close is available too but identical to close (because the whole data is adjusted already), i kept it in to make switching between Yahoo and Quantquote data easier and consistent.
You can find detailed information on the adjustment and earnings data (and how to deadjust) here ( https://quantquote.com/docs/QuantQuote_Minute.pdf ).