write a macro in Excel (or VB 6 with results in text file) using rules and conditions to simulate a trading system

Completed Posted Jun 3, 2005 Paid on delivery
Completed Paid on delivery

Given: data in Open price, Close price, High price, Low Price, and the date and time, price levels and their labels, the stop and reverse values for each level

1. Document trades in the spreadsheet when a known price level is attained, and to reverse the trade when either a stop is hit or a target is hit.

2. Disable any Price levels for a period of time specified by the user.

3. Determine if trade has been documented and to document a reversal of the trade if in a prior trade had been documented.

4. If trade has been stopped out x number of times at a price level to close the trade and if there is more data to open a trade at either a upper or lower price level from the last level.

5. Close the trade at a specific time during the day (based on the data’s time). Open the trade at a specific time. Also determine what to do when the price closes in one trade level and the price jumps to another price level. Called a Gap open.

6. If data for the next minute is missing, then ignore, but this can produce a gap condition in the middle of a day.

7. Determine new stop levels if the stop level is beyond ½ the distance to the next adjoining level.

8. Add the option for an additional timed stop and amount of additional stop level.

9. Give the user the option to move the stop to breakeven if the price goes y distance in the favor of the trade.

10. Give the user the option to treat the two adjacent levels as 1. See specifics in attached file.

11. Document the date, time, trade, the price level entered, the stop level at that time, the target, the current Breakeven value and the profit or loss as a result of the trade.

12. In a separate sheet keep track of key variables such as: number of times at current price level, top trigger, bottom trigger

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

4) Complete as descirbed in attached files

## Platform

windows XP, Excel 2002

PHP

Project ID: #3748903

About the project

8 proposals Remote project Active Jun 8, 2005

Awarded to:

brsofts

See private message.

$211.64 USD in 44 days
(279 Reviews)
6.6

8 freelancers are bidding on average $188 for this job

khaledsherifvw

See private message.

$255 USD in 44 days
(78 Reviews)
6.1
hawkswayvw

See private message.

$573.75 USD in 44 days
(12 Reviews)
4.5
vw1402137vw

See private message.

$85 USD in 44 days
(11 Reviews)
3.1
awaj

See private message.

$127.5 USD in 44 days
(2 Reviews)
2.2
busybitsvw

See private message.

$85 USD in 44 days
(6 Reviews)
1.4
vallikumaresan

See private message.

$85 USD in 44 days
(1 Review)
0.0
razook

See private message.

$85 USD in 44 days
(0 Reviews)
0.0