A Forex data provider supplies data in a CSV file format that includes the HIGH, OPEN, CLOSE and LOW values for any chosen time interval.
Unfortunately, when the markets are closed the data shows the same price in the for every interval that passes until the markets open again.
Essentially resulting in a straight line for 2 days.
I need a small program that will accept a CSV file and remove any data lines that feature identical values for OPEN, CLOSE, HIGH and LOW
in more than 2 data lines that follow each other.
I.e. if OPEN, CLOSE, HIGH and LOW are identical in one line as well as one of the following lines then both as well as any of the following lines with identical OPEN, CLOSE, HIGH and LOW are removed and saved under filname that has "F" added to it.
23 freelancers are bidding on average $60 for this job
Hi qtrader, I'm a .net professional and a data analyst and miner of more than 20 years. This csv crunching task is no problem and I can do it in a few hours exactly to your specifications. Please check PM
Hello, I am a professional programmer with over 5 years experience, I would Love to build you a functional and beautiful application, perfectly hand crafted for your needs.
Dear Project Manager, I just did it, using your sample file. If you can clarify a couple of things in your inbox, this solution can be yours in 48 hours! Regards, Mitchell Allen
Dear Recruiter, I've written similar software in my past project, which actually fetches data from text file and process. I can write similar program for your need. BR-