CC Futures - 1hr Candlestick Info

Overview\r\nCurrently working on an excel sheet that contains 106,025 rows of intraday Cocoa futures prices, and need the Open|High|Low|Close for the following time blocks of each trading day. \r\n\r\n345-359\r\n400-459\r\n500-559\r\n600-659\r\n700-759\r\n800-859\r\n900-959\r\n1000-1059\r\n1100-1159\r\n1200-1229\r\n\r\nThe range of dates is 11/03/14 - 10/30/15. \r\n\r\nI have uploaded an excel workbook with two tabs: Intraday Prices & 1hr - Candlestick Info\r\n - The futures prices can be found on the \"Intraday Prices\" tab of the uploaded excel workbook. This is where you can locate the Open|High|Low|Close information. \r\n - The 1hr - Candlestick Info tab, is where I\'d like the Open|High|Low|Close data to be placed. I have already setup columns for each of the time blocks, and have input all the dates. \r\n\r\n **Specifications**\r\n\r\n1.) Definition of Open|High|Low|Close: \r\n\r\nOpen\r\nPrice under the open column for the first minute of trading of that time block.\r\n\r\nHigh\r\nHighest or maximum price under the High column for that time block. \r\n\r\nLow\r\nLowest or minimum price under the Low column for that time block. \r\n\r\nClose\r\nPrice under the Close column for the last minute of trading of that time block.\r\n\r\n2.) Time Blocks\r\n\r\nThere are a total of 10 time blocks, which are outlined above. \r\n\r\nEach of these blocks may not contain every minute for that period. For example, the time block 345-359, of any given day, may only have price data for the following minutes 347,351,354,355, 357. Per the definition of Open|High|Low|Close, the first minute of this period is 347, and the last minute is 357. As long as the range of minutes fall within the specified time period, the Open|High|Low|Close data will be accurate. \r\n\r\nThis scenario applies to every time block listed. \r\n\r\nThere should NEVER be data of one time period merged with another. Meaning the Open|High|Low|Close data for 345-359, should never contain price information from any other time block. \r\n\r\n3.) Dates\r\n\r\nThe date range is 11/03/14 - 10/30/15. \r\n\r\nThe trading session for certain dates begins at 445, instead of 345. For those dates, pulling the Open|High|Low|Close data for the 345-359 period is unnecessary and can be skipped. And any price data between 445-459 can be placed in the 400-459 time block.\r\n\r\nOne other item to be mindful of, is that the dates on the Intraday Prices tab are listed in an ascending order, while the dates on the 1hr - Candlestick Info tab are listed in descending order.

Freelancer is presenting the description of my project a bit messy. Please see attached PDF for clearer specifications. I've also attached the project workbook.

Skills: Data Entry, Data Processing, Excel

See more: definition of data entry, data entry definition, linux audio card info cc, cc info leads, trading candles low, day trading french speaking, info sheet sheet excel, options trading correlation arbitrage time series, empty client info sheet excel, day count b2b europe free trading site, futures trading system, best entry point day trading, will degree finance help day trading, info building web studios adult webcam performers, vbulletin user share login info, tabbed info window example google, card making business info, minimum business insurance, login user info displayed php mysql, add fields product info oscommerce, sample janitorial info flyers

About the Employer:
( 0 reviews ) United States

Project ID: #8864476

15 freelancers are bidding on average $17/hour for this job


Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among More

$16 USD / hour
(179 Reviews)

Hello, Sir I am from vSol CORP. We are 19 people team, worked on more than 500 completed projects. We provide round the clock service. Kindly interview us to review our competencies & hire us for best desired results. More

$15 USD / hour
(166 Reviews)

Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel please give me a chance for doing your job and im able to start doing your job right now :) Thank You SIncerely Prameswara

$15 USD / hour
(169 Reviews)

Hello Sir, I have checked your job details and I m highly interested in this [login to view URL] me a chance please.Thanks.

$20 USD / hour
(107 Reviews)

Hello, I am Excel and VBA expert. I have read carefully the specification. I can do this project today. P.S. I invest in the stock market. It is clear to me as this one: Open|High| More

$18 USD / hour
(15 Reviews)

Please provide the attachment and the your requirements in readable format. The description right now on Freelancer is full of special tabs.

$22 USD / hour
(25 Reviews)

PRIMARY DETAILS This is my primary Bid details Hello, hope you are well.I have just seen your project and understood what you [login to view URL] doubt your thought is good.I want to gratify you by doing your work can . i AM R More

$16 USD / hour
(19 Reviews)

ZERO ERROR GUARANTEED!! Please read my reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied wit More

$15 USD / hour
(14 Reviews)

*** Do You Like Getting the Results You Want? *** Need to Stay on Budget?*** Hi, I think you just found the right candidate here! I will make sure to deliver the best as per your requirements. I am an experienced co More

$22 USD / hour
(13 Reviews)

A proposal has not yet been provided

$15 USD / hour
(11 Reviews)

A proposal has not yet been provided

$22 USD / hour
(1 Review)

This seems relatively straightforward and should be able to be achieved with the correct application of some pivot tables and well written formulas.

$20 USD / hour
(0 Reviews)

A proposal has not yet been provided

$16 USD / hour
(0 Reviews)

I have downloaded the attached files, and have completely understood the task. If opportunity is given i will complete the task easily. Regards

$15 USD / hour
(0 Reviews)

I can certainly perform and complete the data entry as described for the hourly rate I bid. However, I can also automate your second spreadsheet, such that, you can add (copy-paste) raw data into your first sprea More

$15 USD / hour
(0 Reviews)