VB.net *Easy and Fun!*

Annulé Publié le Apr 10, 2011 Paiement à la livraison
Annulé Paiement à la livraison

This is a fun and exciting project for any seasoned VB programmer.

## Deliverables

Detailed Project Requirements

This is a fun and exciting project for any seasoned VB programmer to convert, modify and add features. Programmer will also convert all features that already exist in the attached copy of [url removed, login to view] to a desktop application as well as create all-new features described by the following.

General Requirements Applicable to All Features

1) All "%" data displayed in this window must have either a "Green" background box if the numbers are positive, a "Red" background box if the numbers are negative, or a "White" background box if the percentage is 0 or there was no change.

2) Make the following rules apply on all search features in the program without exceptions: When a user selects "=," it should display only data equal to the value entered in the associated field. When a user selects "<=," it should display only results of data less than the value entered in the associated field. When a user selects "=>," it should display only results of data that exceed the value entered in the associated field.

Remember that each field throughout the program, must always have the option to double click and it should then sort by sort by ascending and descending.

Additional Requirements

3) On the left side next to the existing Date and Close columns, add the following columns: "Open," "High," "Low," and "Volume." This will enable the programmer to copy and paste data accordingly.

4) Add a button next to the existing buttons named "Search Daily Trends." This feature should perform and function well after the following steps are taken: First, add a pull-down field, which should allow the user to select one of the following options:

Search Options:

1) Previous Day Close and Next Day Open

2) Same Day Open and Low

3) Same Day Open and High

4) Same Day Open and Close

5) Previous Day Close and Today's Close

The program should then display the daily charts in a format similar to that of the existing daily charts with the exception that it should display calculated data based on the option selected earlier from the new pull-down field. The "%" numbers should display according to the search.

The program must display the correct "'%' Calculations" based on the type of calculations selected in "Search Options" such as 1) "Previous Day Close and Next Day Open," 2) "Same Day Open and Low," 3) "Same Day Open and High," 4) "Same Day Open and Close," and 5) "End of Previous to Current Close Price" <-(*See #11) .

The programmer must verify and correct accordingly all discrepancies in the "%" fields and numbers that are not matching for daily, weekly, and/or monthly fields. As well, the programmer must fix all issues so that all of the "'%' Calculations" will display and match correctly, according to each selection. So, for example, if the user searches from "End of Previous to Current Close Price," the program must show the "% Calculations" in all charts and searches based on the appropriate formula.

For example, if the close price for Jan. 2 was $10.00 and Jan. 3 was $5.00, the daily charts would show for Jan. 3 "-50%" because the difference between Jan. 2's close price and Jan. 3's close price was "-50%."

The weekly charts would follow a similar pattern. If the close price for Jan. 1 was $10.00 and Jan. 7 was $5.00, the weekly change was "-50%."

Monthly charts work similarly according to the last day close of the previous month and the last day close of the current month, etc.

The program must also calculate for all other selections according to each individual selection's formula, e.g., "Previous Day Close and Next Day Open," "Same Day Open and Low," "Same Day Open and High," and "Same Day Open and Close." If you do not understand any of these formulas, please feel free to ask questions!

5) Create a feature that will allow a user to click on a monthly chart's "%" box and open the weekly charts to display the "'%' Calculations" for the weeks applicable to the month clicked. When a user clicks on the weekly chart "%" box, the program should then open the daily charts and display the "'%' Calculations" for the days applicable to the week clicked on. It must display the correct "'%' Calculations" based on the type of calculations selected in the "Search Options" such as 1) "Previous Day Close and Next Day Open," 2) "Same Day Open and Low," 3) "Same Day Open and High," 4) "Same Day Open and Close," and 5) "End of Previous to Current Close Price" <-(*See #11) .

Create the same for the weekly charts (when a user clicks on a weekly chart, the program should open daily charts for that week).

6) Create a search feature into which a user can input data in the following fields:

Select Date Range

By Month or By Date

Select Search Details

% Wins =

P/L Ratio =

Days In Trade =

X Consecutive Losing Years =

A sample of the table setup and how search results can be displayed is shown here: SAMPLE-SEARCH.pdf.

Also, make for each search field in this feature an option to search by "=," which indicates "equal to"; "<=," which indicates "less than"; or "=>," which indicates more than, with the only exception that this one is supposed to return search results for the "X Consecutive Losing Years" that the stock lost. The user should have the ability to search by one or more matching fields on a single search.

The following is a brief illustration of how this feature should work. Remember to use the historical data downloaded for each stock. The program must then do the actual calculations based on this data, for each field, and provide the search results accordingly, such as the "P/L Ratio," "%Wins," "Avg Profit," "Avg Lost," "%Avg Profit," "Max Wins," "Max Up Swings," "Max Loss," "Max Draws Down from Date," "Open," "High," "Low," and "Close" with entry and exit dates that match all possibilities selected in the "search options. "

Additionally, ensure that a search and search results can function, calculate, and display data results. For example, a user could enter the date period to search as between Jan. 1 and Jan. 10 for a particular stock and enter a search for 5 Consecutive Losing Years and a Minimum of => 1 Day in the Trade. If on Jan. 2 and Jan. 5 this stock lost for 5 years consecutively on those days, the program would then display 2 results, one for Jan. 2 and one for Jan. 5. It should also automatically calculate and display all data for fields "%Wins," "Avg Profit," "Avg Lost," "%Avg Profit," "Max Wins," "Max Up Swings," "Max Loss," "Max Draws Down from Date," "Open," "High," "Low," and "Close" based on the historical data downloaded and displayed accordingly for each of the possibilities (Jan. 2 and Jan. 5).

All fields in the search results must remain the same, with the exception of an additional field that will display the (e) in accordance with the features below.

7) Create a separate tab named "Earnings Manager" and place all features related to this feature in that tab .

7a) The programmer should implement a feature and button labeled "Upload Earnings." Clicking that button should lead to a prompt for the user to enter the "symbol" to upload data to and then allow an excel sheet to upload with fields similar to those in the "sample [url removed, login to view]" file. Once the data are uploaded, the program should display the data in a tab and ask for the user to confirm that the upload was completed correctly. There should be two buttons, either "Cancel" or "Save." If the user clicks "Cancel," the program should not save this data. And if the user clicks on "Save," the program should prompt one more time with another window: "Are you sure want to save this data?" If the user clicks "Yes," the program should store this data forever under that symbol and always display the (e) marks under that symbol next to the dates that uploaded, except if the dates are modified as stated in section "d" below.

7b) The program should display the (e) marks in all monthly, weekly, and daily charts that contain a date uploaded in the (e) excel sheet.

7c) Make a feature in all daily, weekly, and monthly charts such that when a user double-clicks on an (e) next to a date that was uploaded, the program takes the user to an "Earnings" tab that should display all applicable dates uploaded for that symbol with the option to edit/remove any dates and then "Save" accordingly. Also, if the user clicks on "Save," the program should prompt one more time with a window asking "Are you sure you want to save this data?" If the user clicks "Yes," the program should store this data forever under that symbol and should display the (e) marks under that symbol next to the dates uploaded, regardless of whether the data are current or future entries for this particular symbol.

8a) Remember to use the historical data downloaded for each stock. The program must then conduct the actual calculations based on this data for each field and provide the search results such as the "P/L Ratio, "%Wins," "Avg Profit," "Avg Lost," "%Avg Profit," "Max Wins," "Max Up Swings," "Max Loss," "Max Draws Down from Date," "Open," "High," "Low," and "Close" with entry and exit dates that match all possibilities selected in the "search options."

8b) Another way that the search and search results must function, calculate, and display data results is as follows: If a user enters the date period to search between as Jan. 1 and Jan. 10 for a particular stock, looking for 5 Consecutive Losing Years and a Minimum of => 1 Day In Trade, and on Jan. 2 and Jan. 5 this stock lost for 5 years consecutively, the program would then display 2 results, one for Jan. 2 and one for Jan. 5. It should also automatically calculate and display all data for fields "%Wins," "Avg Profit," "Avg Lost," "%Avg Profit," "Max Wins," "Max Up Swings," "Max Loss," "Max Draws Down from Date," "Open," "High," "Low," and "Close" based on the historical data downloaded and display each of the possibilities, Jan. 2 and Jan. 5 in this case.

8c) In the instance of multiple stocks, section "b" would still apply, with the only exception that it would display search results for multiple stocks requested instead of merely a single stock and it must also display the stock symbol next to each search result, illustrating which stock that trade applies to.

8d) The programmer must make a field in this section that will allow a user to search by "Earnings Dates"-for example, finding results occurring during earning dates stored in the database.

8e) There must be an option to save the current program settings and results as well as for the user to open any previously saved results, which should then display all data, fields, and tabs exactly as saved.

9) Once the programmer completes all of the above, he or she should create a feature that will download the data such as "Date," "Close," "Open," "Volume," etc. from a mySQL database based on a symbol field that the programmer creates. The user will input the data to download only for that symbol.

This feature is independent of all API features, designed with the purpose of creating a mySQL database and providing an option to download stock data stored in such a database such as "Date," "Close," "Open," "Volume," etc. for each individual symbol. The coder must implement all requirements and set up the mySQL database at the user hosting account so that all features will work properly with the mySQL database and this program via the user's online Web hosting account.

10) Create a feature that will allow the user to easily copy and paste a list of specific dates (sample file attached: [url removed, login to view]). It should display the symbol (e) next to the months, weeks, or days applicable.

Merge the [url removed, login to view] file with [url removed, login to view] and create a button/link and features on [url removed, login to view] just like all other buttons on current-excel-file.xlsm.

11) Convert all existing features as well as this project's features into a Windows-based desktop application for use without Excel.

12) Make a feature that will allow the user to download all historical stock data via Yahoo API.

13) Make a feature that will allow the user to save a list of stock symbols and company names divided by market, e.g., NASDAQ, NYSE, etc. The user should be able to select/highlight those stocks under the search tab after selecting a market, e.g., NASDAQ, NYSE, or ALL. Also, add a stock symbol field on the left of the "Entry Date" field. When a user highlights any or all stock symbols in the list and clicks "search," the program should display the search results for all of those stocks selected.

Also, add a button in the search results next to each stock symbol. When a user clicks on that particular stock, the program should calculate and display all of the weekly, monthly, and daily charts for that stock accordingly.

14) Make a feature (with an option to enable and disable it) that will allow the user to save all historical stock data to local files. The program should load from those files accordingly so that the user does not need to download again and again for each stock.

When this feature is enabled for a particular login and password used by a client, it should allow the client to save the data to local files. When this feature is disabled, it will not allow the user to save the data to local files. The programmer must make this feature able to be enabled and/or disabled in the mySQL online database on the user's hosting account, and the program should determine whether to enable or disable this feature each time the user logs into the program.

15) Ensure that Item #5 from the original list, "Select Search Details," allows the user to choose whether to select more than a single option at once. For example, the user should be able to enter fields ">=," "<=," or "=" for multiple options such as "% Wins" + "P/L Ratio" + "Days In Trade," etc., and it will display only results that match all of the specified requirements.

16) Create a feature that will allow the user to add markers for specific dates. The program should show a marker at the dates for those stocks in all charts, e.g., monthly, weekly, daily, etc., and it should save the marked dates also for future search results from the mySQL or local file searches.

17) Make a feature for product key codes and logins that disallow the user from installing the program without the proper key code (which should be valid for only a single installation). The program should not allow a user to open the program without first providing a login and password each time, and the login and password must match from an online mySQL database that the programmer will create. The programmer will also provide a version of the program as well as the source code of that version in which all login features are disabled.

18) Create a feature that will allow the user to manually select a range of dates by highlighting them from the stock data; then, after the user clicks "search," the program should display the search results for each year during that date range (including the price difference). It should always display the next possible date that offers data. For example, if the user chooses an end date of Feb. 1 and for some years there are no data points for Feb. 1, it should display end date data for Feb. 2 for those years. Also, it should always display the correct dates for the data in the appropriate fields.

Architecture Logicielle

Nº du projet : #3235724

À propos du projet

7 propositions Projet à distance Actif May 17, 2011

7 freelances font une offre moyenne de 470 $ pour ce travail

mobiletech1604

See private message.

$459 USD en 10 jours
(40 Commentaires)
6.2
matsolvw

See private message.

$425 USD en 10 jours
(73 Commentaires)
5.4
techwizzard2012

See private message.

$85 USD en 10 jours
(25 Commentaires)
5.2
solver1983

See private message.

$510 USD en 10 jours
(1 Évaluation)
2.5
kushalsolanki

See private message.

$110.5 USD en 10 jours
(2 Commentaires)
0.8
NovelSoft

See private message.

$425 USD en 10 jours
(0 Commentaires)
0.0
amolwebtech

See private message.

$1275 USD en 10 jours
(0 Commentaires)
0.0