Skip to content
No description or website provided.
Python Shell JavaScript
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.
Data
Scripts
.gitignore
.gitignore~
BadTickerList.txt.bak
BadTickerList.txt.bak2
BadTickerList.txt~
HowToQuicklyFixWrongTickers.txt
IBDTestDatabase.sqlite
IBDdatabase.sqlite
IBDquickstartguide.pdf
Ideas.txt
MasterScript.sh
Processedeibd.txt
README.md
Resources.txt
ReturnCalcRunner.sh
SVGStock.py
StockSQLiteQueries.txt
StocksScottrade.txt
StocksScottrade.txt~
TODO.txt
UsefulQueries.txt
UsefulQueries.txt~
___oRUN_VERIFY_TICKERS_TO_CHECK_FOR_BAD_TICKERS_AFTER_RUNNING_DUAL_PREP_FOR_DBASE
eibdearnings.txt
eibdearningsreports.txt
eibdpdfTXTs.txt
eibdpdfscompleted.txt
gnuplotBC20RankMatrixTransposed.txt
latestData.tgz
makeSVGpage.py
makeSVGpage.sh
makeSVGpages.sh
sqliteToMySQL.py~
sqlitedump.mysql

README.md

This is a set of data and accompanying bash scripts to organize various stock lists into sqlite3 databases for analysis by programs.

---Data/---------- Data/: Main IBD lists that I follow Data/8585.txt - Friday 85/85 listing: All stocks above $10, within 15% of 12-month high, Earnings Per Share (EPS) Rating and Relative Price Strength (RS) Rating of 85 or more and average daily volume of 10,000 or more are shown in order of Industry Group Relative Strength Rating. Data/BC20.txt Data/IBD50.txt Data/IBDListDefinitions.txt Definitions of the lists from the investors.com website Data/OpenAllIBDListFiles.sh - Script to open my main lists all at once in emacs Data/TODO Data/Top200Composite.txt

Data/ExchangeCompanyListings: - Ticker Lists, mainly used for determining ticker changes AMEXcompanylist.csv ChangeTickerList.txt
NASDAQcompanylist.csv NASDAQ_NYSE_Sources.txt - States where I downloaded the company lists for each exchange NASDAQ.txt NYSEcompanylist.csv NYSE.txt StockTickerChangeList.txt StockTickerSourceInstructions.txt

Data/SecondaryLists: - Other lists which I don't update as frequently and some misc data IBDSubgroups.txt NewAmerica.txt Top15World.txt TopUSDiversifiedETFs.txt

---Scripts/--------

Process for entering new data

Stick the IBD pdf files in a directory.

Run Scripts/touchAndOpenIBDTxtFiles.sh from the directory where the IBD pdf files are located. This will create and open a file named <pdffilename>.txt.

Open the pdf and extract the data and place it into the <pdffilename>.txt. You must manually copy out the relevant chunks and paste them into the appropriate <pdffilename>.txt file. For Top 200, copy out the entire table. For 85-85/Week In Review, copy the side table and not the box data. For IBD50 & BC20 copy the box data.

Run ExtractionAndInsertionRunner.sh /path/to/directory test from the /Scripts/ directory, pointing to the directory where the <pdffilename>.txt files are to test the data before entering. E.g. bash ExtractionAndInsertionRunner.sh /tmp/ test

When you are satisfied that all data has been properly extracted, run ExtractionAndInsertionRunner.sh /path/to/directory. This will copy the extracted data into the appropriate files in /Data/

As of today, Tue Feb 2 12:03:49 EST 2016, the easiest way to insert results when BC20 isn't 20 and 8585 is really short is to find the extracted results in /tmp/{data}_IBDSorted.txt and fix them up and comment out the call to IBDPDFExtractor.sh in ExtractionAndInsertionRunnerh.sh.

Generate SVG Plots of Data

Run MasterScript.sh

Something went wrong with that request. Please try again.