We have 4 large csv files that need to be converted from the following format
Symbol, Date, Open, High, Low, Close, Volume
To
Date, Percentage Change (but with Symbol as the heading)
Where Dates will be normalised from 1st of January 1999 to end of December 2018 for all, missing values will be zero and where Percentage Change is equal to ( ( Close / Open ) - 1 ).
CSV files are too large for excel and contain more than 1million rows.
Should be a relatively easy scripting job. There is an example input table and output table.
I am a trader too and have developed different bots for trading Forex and Cryptocurrencies. I can help you.
MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.
£20 GBP en 1 día
5,0 (41 comentarios)
5,1
5,1
22 freelancers están ofertando un promedio de £120 GBP por este trabajo
Dear Employer,
I understand you need to change the format and apply percentage But as the size is too big, I would probably need to upload data in Db first, change everything there and then download it. So its more work that ways.
Do try me once :)
Thanks and Regards,
Ash
Hello Sir
Im excel VBA macro and formula Expert :)
i can do running your large CSV and make it output file like u need like in your example file
please ping me for discuss more
Thank you
Galih
Hello there,
This looks feasible and I can do this quickly.
I have developed more than 500 VBA macros for Windows/MAC
I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience.
Ping me to discuss project , timeline and budget.
Thanks
A
Hi there,
I’ve checked the project details and I can do this perfectly. I have huge experience in working with these projects. Waiting for your quick reply.
Look forward to hearing from you soon.
Best Regards
Hello,
I am Excel and VBA expert.
I have seen the file. I understand the requirements.
I can do it in VBA (Excel VBA macros) without opening the file in the Excel.
If you have any questions, I will be happy to answer.
Please note that I have 100% completion rate and 5-star feedback on over 80 projects.
Jan
hello sir. i am a python expert. i have good skills and experiences as you requested. i am going to use Pandas library for your project. if you award me, i can perfectly complete your project in time. please contact me. thanks
Hello,
Based on your description, I am sure that this is related to stock marketing.
As a senior Python and CSV/xlsx developer, I have developed stock marketing and analyzing projects.
So I can do my best for you.
Regards,
Hi
I do a lot of CSV and Excel processing using Python. I think i can help
Some of my Python (includes tkinter & PyQt5 GUI) projects and got good reviews:
https://www.freelancer.com/projects/software-architecture/tcp-client-application-using-python/
https://www.freelancer.com/projects/software-architecture/write-gui-python-program-that/
https://www.freelancer.com/projects/javascript/add-upload-onedrive-via-api/
https://www.freelancer.com/projects/software-architecture/python-project-18200200/
I assure you of clean and well commented code.
I would love to take up this project and definitely finish up in quick time with your satisfaction. Looking forward to working on this one. Please send me a message
Background:
Software developer by profession having 7+ years of experience in C, C++, Python and other scripting languages for automation. I have worked on RESTful APIs as well.
Hi
I have Read Your Requirements
I am Excel VBA Expert
Experianced in VBA Macros & Web Scraping Script...
I can finish any kind of vba task in 1 day only
pls see my previous projects for my vba experiance
Thanks
Hey there!!
How are you?
I'm a system Engineer with coding skills.
I'm downloading the attached example file to check.
I will code the script in Python.
Regards.
Hi
I am an engineering undergraduate with exceptional skills in mathematics. I am well experienced in processing large csv and excel files with python, java and PHP, I can process the available large csv file and format data to the required format. Please message to discuss further on this
Thanks
Note-please check my profile for past projects and reviews.
Hello there,
Myself Prakhar, i am working in python for last 3 years.
I have read your description thoroughly and i am confident that i can do this easily.
i have done ton of CSV manipulation and can easily do your job in less than day with 100% customer satisfaction.
Let's discuss further in personal chat.
Regards Prakhar.
Hello Sir,
I am an expert with CSV manipulation and I would be using .net Script to read and re-write that. I can also generate some report if needed with this data.
Thanks
Aanvik
I would like to take this opportunity, i have good experience in Perl data conversion and i did similar project to handle large volume data.
Please let me know if you are good to award this project to me
Hello,
Greetings!!!
I have review your requirements and I will manipulate the CSV file as per your requirements.
Please let me know if we can start.
Thanks
Supriya