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.
11 freelancers are bidding on average $143 for this job
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.