This is the first job of a serie.
I need support in filtering data. I have about 70 million values (tick data) from EURUSD cross. Each row has date, time and price value.
- i need a script, program, formula or anything else that allows me to do what is described below. I'm open for your comments and advices. Possibly, if a program, it should be free or easy to use. I have excel, but i fear 70 mio. values are too much.
- i want to filter data similar to how data are filtered for point and figure or renko charts. Only increases or decreases of x pips (price) should be considered, all other data can be deleted.
- starting from the first price value , the next value greater or equal than first value + n.x pips (resp. the next value lower or equal than first value - n.x pips) should be considered. Values in between should be eliminated. --> see sheet2 of excel attached
- i should be able to change the x value
- to each increase of price (of the filtered data), a +1 should be attributed, while to each decrease of data, a -1 should be attributed.
To better understand the concept, see sheet 2 in eattached excel. Also find some example data in sheet 1 for your tests.
Hello - 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 and have knowledge on ITIL.
If you see I am among niche bidders who have zero failed projects since I do not bid on projects which I am not certain of.
I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you award me the project.
Thanks,
Jay
Hello ,
I have worked in different fields and I use to catch everything as a part of my knowledge not as a lesson . I can do well with all I have worked with . Also before being hired I want to be verified first .
I think these are like common sense of online world . Actually I am doing these tasks as my parts of life everyday. I think I can satisfy you with my performance .
I am waiting for your reply and can start right now .
Just take an interview to be sure about my experiences and also that's my only way to prove myself . Would love to work with you .
Thanks,
Md. Mridha
I am working in stock market research for a sell-side firm. Day in / out i work in excel, vb, macro. I understand your requirements and I can deliver this data as required.
Hi,
this would be my first online job so it would be a new experience for me...
However I've done a lot of data parsing in the past, on millions of entries with each, 10-20 fields,
So don't wory, I can parse your data the way you want in no time!
I've done the migration of datas from excel to SQL or text files several times so If you want I could export the result on an other file format,
and I've also done graphs on excel before so it's something else that I could provide if you're interrested.
Please contact me with more information if you're interrested with my offer.
My typing speed is very fast. My fingers dance on the keyboard. I guarantee
you to complete the project before the time. I am the best suitable candidate
for this work because I am very dedicated to my work. My Work is my
Passion.
I hope you give this project to me.
Thank You.