Suljettu

3D-renderointi, CAD/CAM, Karttatiede ja kartat, Kuvitus, Koulutus Job by drakebauer

you previous did this already in project Project ID: 88709

Project Description:

Please see the attached spreadsheet. It will help as you read the description below. You need a current version of Excel to view the file.

This is a trading decision spreadsheet. Based on inputs (open, high, low, close, range) the spreadsheet should place a green "B" for buy or a red "S" for sell in the appropriate "Decision Strategy" box. A comparison is made between the latest date (today) and the day preceding it (yesterday). If you look at the spreadsheet, the green "B" or red "S" would be placed in the 9/12/2006 row (today).

The decision strategies are outlined as follows:

#1. Bounce Pattern:

Buy signal: If today has a higher high, a higher low, and a lower close than yesterday, BUY.

Sell signal: If today has a lower high, a lower low, and a higher close than yesterday SELL.

#2 Escalator Pattern:

Buy signal: If today closed below yesterday's low, BUY

Sell signal: If today closed above yesterday's high, SELL

#3 Opening Pattern:

Buy signal: If today opens below yesterday's low, BUY.

Sell signal: If today opens above yesterday's high, SELL.

#4 Wider Range Pattern

Buy signal: If today is an outside day (higher high and lower low) and closed below yesterday's close, BUY

Sell signal: If an outside day (higher high and lower low) and closed above yesterday's close, SELL

#5 Modified Escalator Pattern

Buy signal: If today has a higher high, a higher low, and a higher close than yesterday, and today's close is lower than today's open or in the lower third of today's range, BUY

Sell signal: If today has a lower high, a lower low, and a lower close than yesterday, and today's close is higher than today's open or in the upper third of today's range, SELL

Ideally, I should be able to add another date and all the data that goes along with it and do the calculation again.

You can use VB or you can use nested formulas, either way is fine with me. It doesn't need to be elaborate, it just needs to work.

Let me know if you have any questions! Thanks.

Additional Project Description:

09/13/2006 at 8:20 HKT

Additional Info -- Please Read!!!

I also need to app to highlight the buy or sell price in BLUE as described below:

#1. Bounce Pattern:

Buy price: Yesterday's high

Sell price: Yesterday's low

#2 Escalator Pattern:

Buy price: Today's high

Sell price: Today's low

#3 Opening Pattern:

Buy price: Yesterday's low

Sell price: Yesterday's high

#4 Wider Range Pattern

Buy price: n/a

Sell price: n/a

#5 Modified Escalator Pattern

Buy price: Today's high

Sell price: Today's low

Skills required:

Visual Basic, Windows DesktopAdditional Files:

[url removed, login to view]

Taidot: 3D-renderointi, CAD/CAM, Karttatiede ja kartat, Kuvitus, Koulutus

Näytä lisää: strategy pattern, pattern strategy, look cam, file cam, custom formulas excel, trading app, project id, price comparison app, lower third, cad project, excel 2013 version, app basic excel, strategy work project, day trading spreadsheet, xls visual basic, 2013 excel visual basic, bounce project, day trading excel spreadsheet, cad pattern, excel 2013 visual, open buy sell, cad custom, buy sell app, cad excel, sell project app

About the Employer:
( 0 reviews ) United States

Projektin tunnus: #4287378

6 freelanceria on tarjonnut keskimäärin 232 $ tähän työhön

cgtouch

Please check my exammples

500 $ USD 7 päivässä
(20 arvostelua)
5.5
emilianojn

Hello, if you need any help let me know.

200 $ USD 30 päivässä
(4 arvostelua)
4.1
anomanpk

I would like to offer my services for this job.

100 $ USD 5 päivässä
(0 arvostelua)
0.0
Luxdecore

We are team of experienced Architects and Designers with 10+ years of working experience, we shell deliver very effective, high quality design for affordable price

40 $ USD 2 päivässä
(0 arvostelua)
0.0
pacoperez

Hi, I work quickly and professionally, and de liver on time.

500 $ USD 10 päivässä
(0 arvostelua)
0.0
cahbou

Hi. I've read your description and those strategies can easily be implemented in excel.

50 $ USD 2 päivässä
(0 arvostelua)
0.0