Project Detail

Excel Spreadsheet  

Excel Spreadsheet is project number 88709
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: mohananu

Budget: $30-100

Created: 09/12/2006 at 20:00 EDT

Bid Count: 37

Average Bid:
$ 45

09/15/2006 at 20:00 EDT

Project Creator: dhataway
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (3 reviews)

Bid On This 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 information submitted:

09/12/2006 at 20:20 EDT:
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



Additional files submitted:
PaperTradingQuickStartTemplate.xls

Messages Posted:1 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

40

2 days

09-12-2006 20:28 EDT

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.

help

 

30

2 days

09-12-2006 23:27 EDT

I can do it, See PMB

help

 

30

1 day

09-12-2006 22:39 EDT

im ready to go. thanks

help

 

30

0 days

09-13-2006 02:59 EDT

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 any payment unless u are fully satisfied by our work. Hope to hear positively from u. Thanks

help

 

30

0 days

09-13-2006 10:35 EDT

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 by paypal. I have done many a projects on GAF, i.e. preparing the sample files etc. The project generators have liked my work but somehow, I have never been paid for the samples, sometime half of the project done. I hope you like it. Thanks and regards.

help

 

30

3 days

09-13-2006 02:26 EDT

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 are in the process of bagging another one if ecery thing goes well. If u select us then it would be our third excel project in our kitty. Hope u would not frustrate us. We would do this work for u and are very much interested in it. Looking forward to hear from u. Thnaks

help

 

30

0 days

09-13-2006 04:38 EDT

Consider it done. See PMB

help

 

50

1 day

09-12-2006 23:41 EDT

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

help

 

100

3 days

09-13-2006 02:35 EDT

Hi please check your PM.. Regards..

help

 

60

2 days

09-13-2006 06:07 EDT

Please see my pm.

help

 

50

2 days

09-12-2006 22:44 EDT

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

help

 

70

10 days

09-13-2006 11:00 EDT

look pm box

help

 

30

1 day

09-13-2006 06:40 EDT

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 www.foresteponline.com to know more about us.

help

 

35

1 day

09-12-2006 21:59 EDT

(No Feedback Yet)

I understand I`m new on this site. But I make it in about 2-3 hours.

help

 

30

1 day

09-12-2006 22:24 EDT

(No Feedback Yet)

It will be done as soon as you contact me (approx. 2 hours), so I'm waiting on your signal to start!

help

 

30

0 days

09-12-2006 22:57 EDT

(No Feedback Yet)

I can start as soon as got

help

 

75

3 days

09-12-2006 23:08 EDT

(No Feedback Yet)

We have the expertise to deliver as per your requirements. Perfection needs time and we provide multiple iterations until we get at what you have in mind.

help

 

50

4 days

09-12-2006 23:39 EDT

(No Feedback Yet)

I have the expertise to deliver as per your requirements. Qulity Product needs time and I will provide multiple options which will help you to take decisions

help

 

32

5 days

09-13-2006 00:32 EDT

(No Feedback Yet)

I am a cost and management accountant and a programmer since last many years. I can develope such a spreadsheet easily. Looking forward to your reply Sincerely JavedIqbal

help

 

30

2 days

09-13-2006 00:40 EDT

(No Feedback Yet)

Dear sir/mam, Please check PMB. Regards Vinod Arora

help

 

45

2 days

09-13-2006 00:58 EDT

(No Feedback Yet)

hi we can do this ,we are even looking for more business with you.

help

 

90

3 days

09-13-2006 01:13 EDT

(No Feedback Yet)

Hi I am Nikhil a software professional.I have created the formula spreadheet for ur project,i can create the actual macros also just need ur approval.this need to be done in VBA formula's are Bounce Pattern (High+)(Low+)(Close-) then yesterday B (High-)(Low-)(Close+) then yesterday S Escalator Pattern CloseYesterday's Hig S Opening Pattern openYesterday's Hig S Wider Range Pattern (High+)(Low-)(Close-) then yesterday B (High+)(Low-)(Close+) then yesterday S Modified Escalator Pattern (High+)(Low+)(Close+)then yesterday and TD close<TD Open or in lower third in 4 range B (High+)(Low+)(Close+)then yesterday and TD close<TD Open or in lower third in 4 range C So maximum part is done i can do this before mid day tomarrow.Only thing need to be clarified is that u have to insert data in datewise order also (data u gonne enter will be unique from date or not)

help

 

30

2 days

09-13-2006 01:38 EDT

(No Feedback Yet)

Seva Infotech is software development Organization, located at Ahmedabad, India. We are very much interested in your project. Our rate is US$ 30 for your this project. Please give the full description of the project so that we can give you exact quote and time frame. We have a well experienced team of programmers and designers to work to your satisfaction. We will certainly provide our best service to you. We are ready to initiate this work right now.We assure to you that you will not be disappointed with the quality of our work if you award us the project. We are open to suggestions and concerns for best results. Please feel free to contact us anytime and we are always here for your assistance. Please open PChat for further discussion on the project.Please let us know your feedback. We hope to work with you on this project

help

 

50

1 day

09-13-2006 01:39 EDT

(No Feedback Yet)

Dear Sir/Madam, With reference to attached Excel Sheet, we will provide you the solution as per requirement as detailed in the above project within few hrs. Awaiting for your response. Technoheim

help

 

30

2 days

09-13-2006 05:53 EDT

(No Feedback Yet)

We can do this we can give you macros so this is done automatically. we have done big projects with Excelk macros which will run similar to nor am programs

help

 

30

1 day

09-13-2006 04:11 EDT

(No Feedback Yet)

Hi, Interested to do as i am also in trading line it will be useful to me also. Once u think i can do for u we can discuss in detail, thanks

help

 

30

1 day

09-13-2006 05:23 EDT

(No Feedback Yet)

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.

help

 

75

3 days

09-13-2006 05:33 EDT

(No Feedback Yet)

We can do this project successfully.If u select us. We have the excellant team.i assure for output.

help

 

35

10 days

09-13-2006 06:11 EDT

(No Feedback Yet)

We are keen on taking up this assignment.

help

 

60

2 days

09-13-2006 06:39 EDT

(No Feedback Yet)

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

help

 

60

5 days

09-13-2006 07:29 EDT

(No Feedback Yet)

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, C#.Net,JSP,J2EE, XML and PHP. Databases : MS-SQL Server, Oracle, My SQL.

help

 

50

1 day

09-13-2006 08:01 EDT

(No Feedback Yet)

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 years for my own company but am just now beginning to market it to others. I would accomplish this as a mixture of formulas and VBA so that it is a fully automated and extendable tool for your day to day needs. I look forward to working with you!

help

 

30

1 day

09-13-2006 08:06 EDT

(No Feedback Yet)

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

help

 

40

1 day

09-13-2006 09:18 EDT

(No Feedback Yet)

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

help

 

50

3 days

09-13-2006 09:41 EDT

(No Feedback Yet)

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

help

 

40

2 days

09-13-2006 10:02 EDT

(No Feedback Yet)

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

help

 

75

10 days

09-13-2006 10:12 EDT

(No Feedback Yet)

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 is renowned for its Data Entry, Data Conversion, Back Office Operations, E-publishing (Doc to HTML), Form filling, Application Designing, Typing projects, Medical Billing forms, Copy and paste projects, Numeric projects, Online Projects, Bank projects, IPO forms, All kind of Ms-Word, Ms- Excel Projects, Scanning, Image Processing and QC Work. Its clients include banks, insurance companies, Publishing firms, law firms and securities firms. We have experience in doing similar projects. We can do this project with required accuracy and within the specified time. BR Manoj bbcorpn.com

help


    Bid on this Project