Devam Ediyor

Excel Spreadsheet

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 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

Beceriler: Visual Basic, Windows Masaüstü

Daha fazlasını görün: modified escalator pattern, higher higher low trading excel spreadsheet, trading decision spreadsheet, buy sell signal excel, strategy pattern, pattern strategy, me excel, excel &, buy spreadsheet, wider range pattern, excel formula upper third, comparing today yesterday excel, buy sell signal excel formula, escalator pattern, bounce patternesclator pattern, vb in excel, n excel, need excel help, above & higher, vb excel, trading strategy, STRATEGIES, spreadsheet 2, row spreadsheet, row b

İşveren Hakkında:
( 3 değerlendirme ) montgomery, United States

Proje NO: #88709

Seçilen:

mohananu

Well, I have already done the functional part of the Excel sheet, the embellishments like the red or other colors, I haven't added. I will send you the final file in a few minutes. If it serves you fine, just pay me Daha fazlası

0 gün içinde 30$ USD
(1 Değerlendirme)
1.0

37 freelancers are bidding on average $45 for this job

rajanlengde

I can do it, See PMB

in 2 gün içinde30$ USD
(24 Değerlendirme)
4.9
KellogITSolution

Hello This is just an hour work for us. We would just do it and deliver u the file. We would also make any necessary changes u want without any extra cost. Give us the job. Sit back and enjoy our work. Don't make an Daha fazlası

in 0 gün içinde30$ USD
(15 Değerlendirme)
4.4
ramvinod

I can do this assignment for you. I have time and experiance to do this assignment. why dont you try out with me.

in 2 gün içinde50$ USD
(1 Değerlendirme)
3.3
stormarch

Hello. Do you want additional formating to page? Greetings.

1 gün içinde 50$ USD
(1 Değerlendirme)
3.0
abhijitcari

Hello R u looking for a serious bidder. Well then ur search stops here. We would not overquote time and price. Price once set is final. We have already completed a complex Excel project using VBA for programming and Daha fazlası

in 3 gün içinde30$ USD
(4 Değerlendirme)
3.1
Progmatics

Consider it done. See PMB

in 0 gün içinde30$ USD
(2 Değerlendirme)
2.8
kmohan1962

Hello; I've a customized spreadsheet created for my own need exactly suiting your requirement. Awaiting your confirmation to post that one. Regards.

1 gün içinde 40$ USD
(2 Değerlendirme)
0.7
saurabhmn

Kindly check out the beta version of the program written in VB.NET

in 2 gün içinde40$ USD
(0 Değerlendirme)
1.8
jjsundar

Hi, I have a team of expertise in Excel and the team can deliver the product as specified in the requirement and even more.

in 3 gün içinde50$ USD
(0 Değerlendirme)
0.0
bbcorpn

Broadband Business Corporation (BBC) is one of the fastest growing IT Enabled service provider. BBC provides Document Life-Cycle and Business Intelligence Solutions to Corporations and Legal Professionals. The company Daha fazlası

in 10 gün içinde75$ USD
(0 Değerlendirme)
0.0
saikiran79

I am very much interested in this job. Request you to please check ur PM now. Thanks Sai Kiran

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
donviar

I am an Excel guru very versed in Excel, VBA, and Visual Basic development. I also happen to be a Certified Public Accountant and fully understand financial terminologies. I've been doing this development work for ye Daha fazlası

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
Prakshal

We are Prakshal Info Solutions(a Unit of Prakshal Infotech Pvt. Ltd.) having expertise on CRM,Pharma, Manufacturing and Service Industry. We have expert team on Windows/Web/Web services development using ASP.net,VB.Net Daha fazlası

in 5 gün içinde60$ USD
(0 Değerlendirme)
0.0
ForestepTech

We are a team of elite professionals who can cater your requirements and needs to your satisfaction. We have read through your requirements and are sure we will be able to fulfill your requirements Please visit [url removed, login to view] Daha fazlası

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
malviyaashish84

I have done this type of project many times. We can bargain with rate. I can do also with lower rate also. Contact 091-2752-230009 or 0-919898142836

in 2 gün içinde60$ USD
(0 Değerlendirme)
0.0
ABSOFT

We are keen on taking up this assignment.

in 10 gün içinde35$ USD
(0 Değerlendirme)
0.0
otesanya

Please see my pm.

in 2 gün içinde60$ USD
(0 Değerlendirme)
0.0
Ranawins

We can do this project [url removed, login to view] u select us. We have the excellant team.i assure for output.

in 3 gün içinde75$ USD
(0 Değerlendirme)
0.0
idealsoftware

We are really capable of doing this projects, and the quality will be ensured by our QA team too. The logic you have stated will be done exactly as we have mastered on excel.

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
PatrickDev

Hi, I would be happy to make this spreadsheet for you. I should be able to deliver it tomorrow evening. Please contact me via PMB if you have any questions, thanks for your consideration.

in 2 gün içinde40$ USD
(0 Değerlendirme)
0.0