stockDataRetrieval
Class StockFileManipulator

java.lang.Object
  stockDataRetrieval.StockFileManipulator

public class StockFileManipulator

extends java.lang.Object

Class manages the extraction of stock history data from files to an array of stock objects that are able to be passed to the database manager for insertion.

Constructor Summary

StockFileManipulator()

Method Summary

static void	appendToFile(java.util.ArrayList queryList)
private static java.lang.String	convertDateFormat(java.lang.String strDate)
static java.lang.String	convertNewsDate(java.lang.String newsDate)
static java.lang.String	convertNewsTime(java.lang.String newsTime)
static boolean	createDirectory(java.lang.String directory)
static java.lang.String	formNewsInsQry(jqubeObjects.NewsObject nob)
static java.lang.String	formStockInsQry(jqubeObjects.StockDatabaseTuple sdb)
static java.lang.String	formStockTuple(jqubeObjects.StockDatabaseTuple sdb)
private static java.lang.String	getTickerName(java.lang.String fileName) Extracts the ticker name from the file name
static void	insertDataToDB(java.util.ArrayList qryList)
static void	loadNewsData(java.lang.String dirPath)
static void	loadStockData(java.lang.String dirPath)
static void	main(java.lang.String[] args)
static void	renameFile(java.lang.String dirPath, java.lang.String fileName, java.lang.String newName)
static java.util.ArrayList	returnNewsDataFromFile(java.lang.String filename) Extracts the news stories from the file and puts them in to a standard array
static java.util.ArrayList	returnStockDataFromFile(java.lang.String filename) Returns data for a specific Stock ticker in a form suitable for insertion into a database by simply extracting each tuple from the returned ArrayList.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

StockFileManipulator

public StockFileManipulator()

Method Detail

returnStockDataFromFile

public static java.util.ArrayList returnStockDataFromFile(java.lang.String filename)

Returns data for a specific Stock ticker in a form suitable for insertion into a database by simply extracting each tuple from the returned ArrayList.

Every file must have the Yahoo format of "Date | Open | High | Low | Close | Volume | Adj. Close" and the last line of the file begins with "

getTickerName

private static java.lang.String getTickerName(java.lang.String fileName)

Extracts the ticker name from the file name

Parameters:

fileName - The file name that contains the ticker name

Returns:

The actual ticker name who's data resides in the file, null if no ticker name is found

returnNewsDataFromFile

public static java.util.ArrayList returnNewsDataFromFile(java.lang.String filename)

Extracts the news stories from the file and puts them in to a standard array

Parameters:

filename - The filename where the news file is located

Returns:

The news stories embedded in an array of NewsObjects

convertDateFormat

private static java.lang.String convertDateFormat(java.lang.String strDate)

createDirectory

public static boolean createDirectory(java.lang.String directory)

formNewsInsQry

public static java.lang.String formNewsInsQry(jqubeObjects.NewsObject nob)

formStockInsQry

public static java.lang.String formStockInsQry(jqubeObjects.StockDatabaseTuple sdb)

formStockTuple

public static java.lang.String formStockTuple(jqubeObjects.StockDatabaseTuple sdb)

renameFile

public static void renameFile(java.lang.String dirPath,
                              java.lang.String fileName,
                              java.lang.String newName)

appendToFile

public static void appendToFile(java.util.ArrayList queryList)

loadNewsData

public static void loadNewsData(java.lang.String dirPath)

loadStockData

public static void loadStockData(java.lang.String dirPath)

insertDataToDB

public static void insertDataToDB(java.util.ArrayList qryList)

convertNewsDate

public static java.lang.String convertNewsDate(java.lang.String newsDate)

convertNewsTime

public static java.lang.String convertNewsTime(java.lang.String newsTime)

main

public static void main(java.lang.String[] args)