Đã hoàn thành

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.

Kĩ năng: Xử lí dữ liệu, Excel, PHP, Kiến trúc phần mềm, Web Scraping

Xem nhiều hơn: 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

Về Bên Thuê:
( 1 Nhận xét ) Moscow, Russian Federation

ID dự án: #1078817

Được trao cho:


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

$150 USD trong 4 ngày
(87 Đánh Giá)

11 freelancer đang chào giá trung bình $143 cho công việc này


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

$225 USD trong 7 ngày
(268 Nhận xét)

I am ready to deliver the project asap

$150 USD trong 2 ngày
(141 Nhận xét)

sir plz check pm !

$120 USD trong 3 ngày
(155 Nhận xét)

Please check PM. Thanks

$200 USD trong 4 ngày
(76 Nhận xét)

Excel VBA web scraping expert.

$140 USD trong 2 ngày
(31 Nhận xét)

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

$90 USD trong 5 ngày
(29 Nhận xét)

Please, check PM

$120 USD trong 3 ngày
(6 Nhận xét)

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.

$200 USD trong 4 ngày
(2 Nhận xét)

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

$100 USD trong 4 ngày
(0 Nhận xét)

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 Thêm

$80 USD trong 5 ngày
(0 Nhận xét)