Data Extraction Program for PC

Completado Publicado Feb 16, 2007 Pagado a la entrega
Completado Pagado a la entrega

The Program Extracts data from a web page.

The program shall run by opening the Excel file and clicking on a “Login?? button and then clicking on a “update?? button to run the extraction micros.

The Excel micros enter a stock symbol into a web page field and activates the button “Get Valuation?? The web page returns the “Projected Price?? and "Last Price" for the stock symbol. The “Projected Price?? and "Last Price" is the data that is extracted from the web page. The “Valuation?? web page is not secured. The “Projected Price?? and "Last Price" can be copied from the web page. The list of stock symbols is in the Excel file in the first column. The “Projected Price?? is extracted from the web page and placed in the 2nd column, next to the stock symbol. The "Last Price" is extracted and placed in the 3rd column. The 4th column and beyond is reserved for data or formulas or may be blank.

Website is: [login to view URL]

The URL for the "Valuation Page" is:

<[login to view URL]>?

I will provide user name and password to website to winning bidder for development and testing.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

4) The desktop software program shall run from a PC with XP, or Vista OS.

5) The program shall begin by opening an Excel file.

6) The excel file shall have a "login" button to connect to the investools website. If user is not logged in a Login Pop up box will display.

7) When the program is connected to the investools website a box shall display "connected"

8) The program shall enter the stock symbols from the Excel file into the web page box above the “Get Valuation?? button and activate the “Get Valuation??

9) The results of the “Get Valuation?? is returned in a box titled “Projected Price?? The results of the “Get Valuation?? may be as follows:

A. A number. Example: 367.78 in the “Projected Price?? box

B. The letters N/A in the “Projected Price?? box.

C. A error message (Sorry the Symbol wxyz is not valid)

D. A error message ( The resource is not available try again at a later date)

10) For A above the number shall be entered into the 2nd column of the Excel file next to the stock symbol.

11) For B above the letters N/A shall be placed into the 2nd column of the Excel file next to the stock symbol.

12) For C and D above the letters ERR shall be placed into the 2nd column of the Excel file next to the stock symbol.

13) The "Last Price" shall be extracted and placed in the 3rd column.

14) The program shall display “Extraction Complete?? when a blank entry is found in the 1st column of the Excel file.

15) The program shall have a way to terminate the program during the extraction process.

* * *This broadcast message was sent to all bidders on Saturday Feb 17, 2007 12:00:42 PM:

Thanks for your bids.

I have saved the stock Valuation page in html.

The html page is in the .ZIP file.

I will provied a temporary login password to my account to the winning bidder.

* * *This broadcast message was sent to all bidders on Tuesday Feb 20, 2007 8:40:34 AM:

Several Coders have recommended that this program be run from the Excel spreadsheet. I think this is a good solution. I have modified my bid request to a program that shall runs from Excel.

The program shall run by opening the Excel file and clicking on a “Login?? button and then clicking on a “update?? button to run the extraction micros. I have attached a proposed Excel file for your review.

## Platform

PC Platform running Windows XP and Vista

PHP

Nº del proyecto: #2843768

Sobre el proyecto

14 propuestas Proyecto remoto Activo Feb 22, 2007

Adjudicado a:

juanjimenezdvw

See private message.

$38.25 USD en 20 días
(82 comentarios)
4.9

14 freelancers están ofertando un promedio de $82 por este trabajo

GetReal

See private message.

$148.75 USD en 20 días
(821 comentarios)
8.1
ebluesoft

See private message.

$68 USD en 20 días
(177 comentarios)
7.4
delphiprovw

See private message.

$85 USD en 20 días
(77 comentarios)
6.0
triples

See private message.

$102 USD en 20 días
(79 comentarios)
6.3
omersodai

See private message.

$42.5 USD en 20 días
(108 comentarios)
5.4
vw1427398vw

See private message.

$68 USD en 20 días
(50 comentarios)
5.3
alex13vw

See private message.

$55.25 USD en 20 días
(44 comentarios)
5.1
secretsvw

See private message.

$80.75 USD en 20 días
(11 comentarios)
4.4
hozayen

See private message.

$85 USD en 20 días
(11 comentarios)
3.7
mastermind081

See private message.

$51 USD en 20 días
(8 comentarios)
3.5
brettdj

See private message.

$51 USD en 20 días
(4 comentarios)
2.5
derek192

See private message.

$76.5 USD en 20 días
(5 comentarios)
2.6
vw2235052vw

See private message.

$191.25 USD en 20 días
(0 comentarios)
0.0