How Software Gets Done  


Login

Software Buyers
Request bids
Search coders
My Buyer Account
Buyer help
Buyer articles
Buyer FAQ
Latest news
 
Software Coders
Newest open work
Browse all work
Search all work
My Coder Account
Coder help
Coder articles
Coder FAQ
Latest news
 
Affiliates
My Affiliate Account
Affiliate help
Affiliate FAQ
Latest news
 
Newest Bid Requests.
(See all)
Create Robot.txt file
By franjavier on Sep 25
Max Bid: Open to fair suggestions


Heads or Tails(Coin Toss)
By bsshoomez on Sep 25
Max Bid: $25


CanUHelpMe - Redesign Logo and Home Page
By Webpak on Sep 25
Max Bid: Open to fair suggestions


Splash Screen Graphic
By Byoni on Sep 25
Max Bid: Open to fair suggestions


Better Property Grid/Form (c#)
By QUIET on Sep 25
Max Bid: Open to fair suggestions


Add recurring billing to Paypal IPN script
By linny on Sep 25
Max Bid: $20


Click here to put this ticker on your own site and/or get live RSS newsfeeds

Open Work Categories.
Database 
(187 open)
   Access 
(62 open)
   MySQL 
(122 open)
   Oracle 
(11 open)
   SQL Server 
(69 open)
   Other DB 
(24 open)
Documentation / Tech Writing 
(25 open)
   Language (Human) Translations 
(11 open)
Data Entry 
(37 open)
Game Development 
(22 open)
Graphics / Art / Music 
(56 open)
   Graphics 
(57 open)
     Adobe AfterEffects 
(12 open)
     Adobe Photoshop 
(33 open)
     Adobe Premiere 
(9 open)
     3d Animation 
(18 open)
   Art (Misc.) 
(17 open)
   Music 
(8 open)
   Photography 
(5 open)
   3d Modeling 
(11 open)
Language Specific 
(117 open)
   Assembly / Machine language 
(18 open)
   ASP 
(67 open)
   ASP .NET 
(73 open)
   C# 
(68 open)
   C++ / C 
(170 open)
   Carbon (Mac OS) 
(3 open)
   Cocoa / Obj-C 
(5 open)
   Cold Fusion 
(9 open)
   Delphi 
(56 open)
   Java 
(98 open)
   JSP 
(14 open)
   Perl 
(51 open)
   Python 
(6 open)
   PHP 
(124 open)
   XML/XSL 
(35 open)
   Visual Basic 
(171 open)
   Visual Basic .Net 
(111 open)
   Other 
(73 open)
Misc 
(39 open)
   Middleware 
(1 open)
   CAD 
(5 open)
MultiMedia 
(27 open)
   Video Editing 
(5 open)
Network 
(40 open)
   Network Design 
(7 open)
   Network Implementation 
(7 open)
Platforms 
(72 open)
   Windows 
(185 open)
     MS Exchange 
(11 open)
     MS Office 
(27 open)
     Other 
(16 open)
   Darwin 
(3 open)
   Embedded Systems 
(13 open)
   Hand Held/PDA Programming 
(18 open)
   Internet Browser 
(54 open)
   Linux 
(72 open)
   Lotus Notes / Domino 
(2 open)
   UNIX 
(43 open)
Requirements 
(11 open)
Security 
(41 open)
Testing / Quality Assurance 
(16 open)
Web 
(160 open)
   Page Design 
(81 open)
   Flash 
(48 open)
   Marketing 
(15 open)
     Search Engine Optimization 
(11 open)
     Marketing (Other) 
(14 open)
   Web Services 
(84 open)
   Web (Other) 
(94 open)
Training 
(12 open)
   Computer Based 
(11 open)
Other
 
Other Sites

Download the free Rent A Coder IE toolbar!
 
Show Bid Request

search Gann levels
Bid Request Id: 8429
Bookmark in my 'To Do' list
Posted by: toddao (2 ratings)
(Software buyer rating 10)
Non-action Ratio: Above Average - 33.33%
Buyer Security Verifications: Good
Approved on: Feb 5, 2002
11:43:23 AM EDT
Bidding Closes: Feb 19, 2002
11:43:23 AM EDT
Viewed (by coders): 713 times
Phase:
100% of work completed and accepted. Coder has been paid.
Max Accepted Bid: Bidding is closed
Project Type: Very Small Business Project: under $100 (USD)
Bidding Type: Open Auction
Categories: Windows, Database, Other
Enter chat room for this bid request
(0 active users at Sep 25, 2003 9:08:10 AM EDT)

Description:
roject: to use microsoft excel to calculate price levels from an existing database of stock prices then compare todays closing price to those levels and create a sorted output based to proximity to a key level.


Deliverables:
Detail:
Read stock price data csv files from a subdirectory
(date, open, high, low, close, volume)
(contents of subdirectory varies)
(name of issue include underline in name ie: IBM_D.csv ; extensions are all the same )

Find highest high and lowest low in most current last X bars (with default of 64)
plug the numbers into my existing spreadsheet which creates 13 results (labeled -2/8 thru 2/8 with 0/8 the most important)


compute todays volume relative to yesterdays
calculate (todays open + todays close) / 2

Put results that are at or between levels 0/8 and 1/8 in another spread sheet.
Sort from 0 down to 1. Secondary sort on percent volume change from yesterday with largest increased volumes first
Put calculation in third column. (not involved with sort).

Repeat with another spreadsheet for results between 1 and 2 , Third time for 2-3

Take results and output stock name only to a txt file. (drop off any character in stock name after the underline mark.) Text file output should be named level0.txt, level1.txt, level2.txt with no labels or headers in file.

This should all be done in one excel book.
Each run should be fresh (I have no use for yesterdays results but dont delete or overwrite sheets you create until I do a new run)

I have the most current excel

You be available for any modifications, additions.

thank you

Special Conditions / Other:
You be available for any modifications, additions.



Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.



Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.
 
Bidding/Comments:
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests.

See all rejected bids (and all comments)
Name   Bid Amount 
 
Date   Coder Rating  
This bid was accepted by the buyer!
PYESoft
(18 ratings)
in Monterrey, Nuevo Leon
Mexico
Bid id: 98,627
 
$50 (USD) Feb 5, 2002
2:03:06 PM EDT
 10
(Excellent)
   
Hello sir...

I am not used to the stock terminology, but it seems to be that what you want to do, can be easily accomplished with Excel macros, which are repetitive routines programmed through the Visual basic for applications interface the MS Excel has.

I've worked with Excel macros for 4 years, so I think what you want to achieve will be no problem. But you will have to be a little more specific on every step that should be followed to get the final result you want.

Your project can be done in two days, depending on how I get to understand the whole characteristics you define it should have.

Thanks for your attention and best regards.
 




Bid Request Search
 Advanced Search
Newest Open Work
Latest News  
Credentials


 

 
Rent A Coder upholds the rigorous business practices required to be both a BBB member and Square Trade vendor.
  • All customer issues addressed within 2 days
  • Openly disclosed pricing and return policies
  • Participation in mediation at buyer request
  • Superior selling track record
This site is verified through its parent company, Exhedra Solutions, Inc.
 
Top Coders.

Securenext
Rated a 9.97 on 124 jobs 
Buddies
Rated a 9.85 on 94 jobs 
Codman
Rated a 9.97 on 158 jobs 
hernest
Rated a 10 on 122 jobs 
Andrei Remenchuk
Rated a 10 on 14 jobs 
D-N-S
Rated a 9.93 on 39 jobs 
markesh
Rated a 10 on 23 jobs 
GribFritz
Rated a 9.89 on 152 jobs 
ASP.NET
Rated a 9.86 on 62 jobs 
PSergei
Rated a 9.77 on 108 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers

 
Other
Rent A Coder is PayPal verified through its parent company, Exhedra Solutions, Inc.

Created in partnership with:

 

Affiliate Sites
Latest News | About Us | Kudos | Feedback/Contact    Affiliates | Advertise    Privacy | Legal

Copyright 2001, Exhedra Solutions, Inc. All rights reserved.
By using this site you agree to its Terms and Conditions.
"Rent A Coder" (tm), "Safe Project Escrow" (tm) and "How Software Gets Done" (tm)
are trademarks of Exhedra Solutions, Inc.