convert excel vba to .net window form application(repost) (for Velocity Information System)(repost)

Ακυρώθηκε Αναρτήθηκε Oct 27, 2011 Πληρώθηκε κατά την παράδοση
Ακυρώθηκε Πληρώθηκε κατά την παράδοση

I would like to upgrade an excel spreadsheet VBA based into protected and better visualized VB.NET application. I am attaching the excel file along with the functions and forms I built (you may use them or replace with .Net forms). It will be important to follow the conditional colours of the file as they have meaning.

Please use password "Hutiv219" to login and remove code protection from VBA code. Note that there are hidden sheets also protected by the same password. You may use the "remove protection" button to reveal them all.

## Deliverables

The windows forms based application should have:

**Login** page that connects to SQL database and validate the user (see UserLoginForm) This will contain also registration form (see RegisterForm)

**Main** screen with a menu bar and compatible buttons similar to the ones appear in the main screen/sheet. The main screen will actually show the excel main screen data grid.

The menu bar should contain functions as follow:

(for most of the items and forms you may utilize the existing forms, subroutines and functions I already built in module 1 and inside the formns and differenty sheets)

**File menu:

save**

**exit** (user is being signed off and database is updated accordingly to avoid multiply use of same user - see LogOut_Click)

**

Edit menu:

**

**copy** (simple copy function of excel)

**paste** (simple paste function of excel)

**redo** (simple redo function of excel)

**undo** (simple undo function of excel)

**Strategy** **menu**:

**new**- creates new spreadsheet within the worksheet - see Sub CreateNewStrategy(Optional x As Boolean)

**delete**- removes spreadsheet, current selected strategy sheet is removed manually - see Sub DeleteStrategy(ByVal SelectedSheet As String)

**move** **to** (drop down list of all strategies popped out and upon selection user will be shifted to selected strategy).

**Launch** - seperate word document with the title "trim algorithm" describes this function.

**Settings** - user defines yield target for the strategy and type of strategy according to which he/she will recieve alert messages.

**Strategy builder -** seperate sheet allows building strategies based on market data paramertes and risk factors.

The excel file send alert messages based on changing market data. This market data is extracted from specific website.

**Data settings menu:

**

**market data refresh**, 2 sheets evoke data import - see OneTimeRefreshButton_Click

**market data autorefresh**, 2 sheets evoke data import by preset time interval - see AutoRefreshOn_Click

**alert settings** for user email Functions to evoke alert and deliver alert are Sub checkValueChange(Optional x As Boolean) and Sub SendChange(ByVal strSheet As String, ByVal orderDetails As String)

****Account**settings menu**:

**Account** **settings** - user defines available cash (margin) in 3 different accounts

**Help menu**:

**Help** (redirects to help form) copyright statement (redirects to CopyRightForm)

Please note the excel file is populated with many hidden formulas that interact with the VB code (currently some of the functions have been removed). All code should be properly documented.

* * *This broadcast message was sent to all bidders on Thursday Jun 30, 2011 3:14:52 AM:

Some points to clarify: Special note: The following project requires some understating of financial derivatives The project is an options simulator which enables building and managing of options strategies along with alert messages for strategy revisions. The project already works based on excel platform (VBA code). You are required to turn it to full protected .NET application software which will be downloaded upon registration and payment from host website. For this purpose you should use the code which is already inside the file and adjust it accordingly. The file has to be fully copy protected and could be downloaded to single IP address only once namely operates only with user, password and verified key. To better understand the methodology of the file please review the word document that describes it. The trading data is extracted from specific website (excel query) and timed by predefined time interval. This data is textually manipulated to adjust to the file simulator. The application based solution should save this trading data on database. The website that holds the application should contain a few basic pages: - Main screen - Registration and Payment method solutions (PayPal) - Contact page special comments: - Suggest trail period that allows downloading the tool to registered IP address. - Payment method will allow also local credit cards. - Optional bonous: Design a logo. - All code should be documented properly with full direct access to the administrator (myself). - You should suggest web host providers with annual hosting costs and make sure it support Hebrew fonts. - Hosting should be sufficient for large volume download data that match a few thousands of users downloading market data on a daily basis each on a non limit basis.

ASP PHP

Ταυτότητα Εργασίας: #3657792

Σχετικά με την εργασία

Απομακρυσμένη εργασία Ενεργό Oct 27, 2011