Generally speaking, I need a .net/C# programmer to write one trigger of excel, and one timer-controlled program of excel and web scrapping.
A). there are following elements involved in the trading process.
10). Stock trading software which is win app (no work needed)
20). Excel spreadsheet with one trigger and one program called status and two buttons. these programs are what you need to create. I will take care of structure and format of those spreadsheets.
30). Online [url removed, login to view] web site (no work needed)
B). The process flow is as followings:
10). I open stock trading software at 6:30 am
20). Stock trading software will write first buy list at 6:40am to excel. List has stocks I want to buy.
30). An excel trigger should go to broker order page and fill an order and send it out,and then works on next order.
40). After 2 minutes , another excel program called status program (it should be separated from trigger) check order status on online broker, get order status, buying power, profit and etc, and update these columns of
spreadsheet. This program should send an email when finished one run. Other purpose of this action is to keep web site alive.
42). status program will check a command sheet at same time as step 40). if read "close all", status program should close all positions by sending order one by one to broker web page.
50). 6:50am, stock trading software write two lists to excel this time, one for buy and one for sell.
60). repeat step 30).
70). add a button on sheet called "close all" using the same code as 42).
80). add a button on sheet called "send order". Program check the checkboxes of a column called "send" to send order to broker.
C). The followings are optional
10). excel 2007 above
20). trigger of excel could be written in vb.net 3.5 or C# 3.5
30). status program could be written in C# 3.5
40). .net 3.5
50). logging block 3.5 for logging to access db
70). exception block 3.5 for excepion handling.
Additional information submitted:
We add function specs as an attachment which is almost like a pseudo code.