Program: completes web form to get data and appends to XLS


I need an application that would create and update records of stock quotes in an excel file (xls).

Here are the steps to what the program should do:

STEP 1. Interacts with a web form to receive data.

The web form can be found via the following link:

[url removed, login to view]

The web form provides stock quotes for a specified period for a specified stock in .csv format.

The app should use a list of stocks for which I need quotes. I would like to have the ability to update this list.

I need the application to automatically fill in the form and receive a .csv file for each stock in the list.

The application will be executed from time to time; it should know when was the last time it was executed, how many days have passed, and it should get stock data for each day it was off and the current day. It should not attempt to get data for the current day if the local time is earlier than 20:00 (time when the stock exchange closes), in such case it should get that data next time it is on after 20:00 of that day.

Below is a translation of input fields in the web form and the values it should be filled with:

a) Input field: 1 (transl: Market section) = Filled in with: 1st option in dropdown list (transl: MICEX stocks)

b) 2 (transl: Stock) = Name of stock from the list

c) 3 (transl: from) = 1st: Day of month, 2nd: Month (in Roman numbers), 3rd: Year

d) 4 (transl: to) = 1st: Day of month, 2nd: Month (in Roman numbers), 3rd: Year

e) 5 (transl: frequency) = 9th option in dropdown list (transl: one day)

f) 6 (transl: name of output file) = 1st: up to you 2nd: ".csv"

g) 7 (transl: name of stock) = up to you (doesn't affect anything)

h) 8 (transl: date format) = 1st: 1st option in dropdown list (transl: yyyymmdd) 2nd: 1st option in dropdown list (transl: hhmmss)

i) 9 = 1st radio button

j) 10 (transl: separator) = 3rd option in dropdown list (transl: semicolon)

k) 11 = 1st option in dropdown list (transl: no)

l) 12 (transl: format) = 5th option in dropdown list "DATE,TIME,OPEN,HIGH,LOW,CLOSE,VOL"

m) 13 (transl: add headings) = ticked

n) 14 (transl: provide data for days without transactions) = not ticked

The submit button is gray with white letters.

STEP 2. Using the .csv files appends data entries to [url removed, login to view]

The [url removed, login to view] file consists of a series of worksheets (one for each stock).

The worksheets are named according to the list of stocks mentioned earlier.

Columns A,B, and C have the following headings (in row 1) <DATE>,<CLOSE>,<VOL>.

The headings are followed by stock data.

In column A - date of quote, column b - quote, column c - volume of operations.

This data can be found in .csv files under the same headings.

After the application downloads all the relevant .csv files (STEP 1), i want it to update the [url removed, login to view] file.

In other words, append the date of quote, quote, and volume of operations into the worksheet of each stock.

IMPORTANT: During the first run or when a new stock is added to the list the program should obtain stock information for all days from 01.01.1990.

Compétences : Traitement de Données, Excel, PHP, Architecture Logicielle, Web Scraping

en voir plus : white & case, white and case, what to program, what program do i use to open a php file, what is data input, web application quote, web anything, use case how to, translation stock, to get translation, series 7 application, php to excel export, m.d. web, k to the i, how to format quotes, how many days after, how do you get a translation, how do i get translation, how create form in php, get on to translation, roman m, important steps, how to do data analysis, data and analysis, can you ru it

Concernant l'employeur :
( 1 commentaire ) Moscow, Russian Federation

Nº du projet : #1078817

Décerné à:


I have done a similar work before. Please see your messages

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 4 jours
(87 Commentaires)

11 freelance font une offre moyenne de $143 pour ce travail


We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(268 Commentaires)

I am ready to deliver the project asap

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(141 Commentaires)

sir plz check pm !

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(155 Commentaires)

Please check PM. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(76 Commentaires)

Excel VBA web scraping expert.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(31 Commentaires)

Please check PMB...................................................

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(29 Commentaires)

Please, check PM

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(6 Commentaires)

Hi, i have 3 years experience in Excel VBA (my day job), and i am very interested in this project. Let me know please if you want to go ahead, and we take it from there. Many thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(2 Commentaires)

Hi, I'm expert at web mining. Please check your inbox.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)

Hi, I am working in this business from last 10years, sir, if you let me chance, I assure you that my hard working, experiences & sincerity will help to enable your company faster after completion of this project and fu Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)