yfMongo

yfMongo is a simple command line app to store and manage Yahoo Finance stock data in a MongoDb database.
It allows you to build a local corpus of stock data that can be reused and updated easily wihout having to be constantly online.
The API access is handled by means of YahooFetcher .

Features

• Retrieve stock data from Yahoo Finance using Yahoo tickers
• Store tickers locally in MongoDb
• Retrieve some indexes constituent data
• Update tickers data daily
• Fetch by date range
• Export the data to JSON and CSV

Requirements

• Python v2.6 at least
• Pymongo python module
• a running MongoDb instance

Database structure

By default yfMongo creates a database called yfmongo in your local MongoDb setup. Inside this database, two collections contain all the data:

• symbols : tickers list
• timeline : tickers data (opening price, closing, max, min, volumen and date)

Usage

Usage:
 yfm clear                      -- clear all content from the db
 yfm clear data                 -- clear only data, keep tickers
 yfm add <ticker>               -- add a ticker to the db
     add <ticker> <start> <end> -- add a ticker and fetch the period
     add index <index>          -- add underlying index components
 yfm load-symbols <file>        -- load the tickers from a file
 yfm remove <ticker>            -- remove a ticker from the db
 yfm fetch <start> <end>        -- fetch data between both dates
 yfm update                     -- retrieve data since last update until today
 yfm info                       -- print out admin info
 yfm show <ticker>              -- shows the data for a ticker

Some examples

yfm add goog                        # add the 'goog' ticker to the database
yfm add mse  06/05/2013 12/05/2013  # add mse and fetch the data between 6th May 2013 and 12th May 2013.
yfm add index ftse                  # add the tickers for the index FTSE
yfm remove goog                     # removes GOOG from the db, ticker and timeline info
yfm update                          # for each ticker retrieve data since last day until today
yfm show mse                        # displays mse content

Openshift integration

In order to use yfm in OpenShift, edit yfm file and override the following parameters: hostname = os.environ.get("OPENSHIFT_MONGODB_DB_HOST") port = os.environ.get("OPENSHIFT_MONGODB_DB_PORT") user = os.environ.get("OPENSHIFT_MONGODB_DB_USERNAME") password = os.environ.get("OPENSHIFT_MONGODB_DB_PASSWORD")