Freelancer

Description

I am looking for a program to do several simple calculations for me with a large amount of stock data. The end result will be an output screen that provides me with several peices of numeric data for many stocks in a list, and which provides me the ability to download the output to a text document. Also, I need the ability to click on any one of the stock symbols in the output screen and for that to generate a line graph with an area that shows volume for the day. The stock should look like this:

http://finance.yahoo.com/q/bc?s=BA&t=1y&l=on&z=m&q=l&c=

The graph will also contain two upsloping lines, which is what I need your help in generating. The lines will be between two points each. Line one will be between points A & B, and one line between points A & C.

I will provide you with the means of locating points A, B, and C. The calculations used to locate these points include finding the lowest prices within a set of days that I specify in an input screen, and then limiting these lowest prices until A, B, & C are located specifically.

The data that both of these lines create is the basis of the data I am seeking in for my output screen. The output will include the slope of these lines (rise/run), total time the line lasted, as well as several other pieces of information.

Some stocks won't contain these points, but the ones that do are the ones that I am interested in. I will be working with a variety of different time periods, so the program must adjust based on the data provided. If the data runs out, I don't want to get errors.

I want an input screen to start with that provides the following:
1. A place for me to upload the text file (see below on format).
2. The number of days to locate data points (to get A,B,C). (For example: Search for lowest price every (X) days....these points will be fed into a formula to locate my A,B,C points.)
3. The number of days after the lines end in which to provide the over-run data. (For Example: The line ends Aug 1....I want to specific for the program to provide me the data for the next (X) days after that...Aug 2= $30, Aug 3= $31, etc.)



Data is in text Notebook format. The file for a single stock contains one record per line of text corresponding to the data for that date. **I WILL ONLY BE WORKING WITH THE “CLOSE” DATA. The record is arranged into fields representing respectively the Date, Ticker, Open, High, Low, Close, Volume for that day. The fields are delimited by commas, and the records are delimited by"". For example:

20041231,BA,51.77,52.09,51.69,51.77,16757
20050705,BA,64.3,65.44,64.17,65.42,33224
20050706,BA,65.5,66.11,64.2,64.29,39545
20050707,BA,63.98,65.18,63.45,65.18,55839
20050708,BA,65.07,65.24,64.51,65.07,37153
20050711,BA,65.25,65.49,64.78,64.97,20371
20050712,BA,64.96,64.97,64.15,64.3,29221
.....
20060524,EL,40.65,41.1,40.54,40.75,15585
20060525,EL,41.1,41.12,40.77,40.85,10286
20060526,EL,40.77,41.41,40.71,41.35,9205

(Each stock symbol has between 250-3000 rows.) I have between 500-10,000 symbols and need the program to handle this much data. However, at this point my data is limited to about 275 rows each and 500 stock symbols.

I must be able to see the lines on the graph to ensure my data is correct. I expect to contact you 3 times to correct errors after you provide the program. Please price this into your bid.