In Progress

Automate Crypto Data

About a month ago I had a program made for me that finds data in an excel sheet I download daily that meets certain requirements I was interested in. Now I am looking for a coder who can automate the process of extracting further data from the excel sheets based on criteria I am interested in and paste the results into another excel sheet. I am currently doing this by hand but it would take forever to complete it daily. The coder could automate the process I am currently using or start anew with an easier more productive way of doing it, whatever is easiest to accomplish the task. The first excel file I uploaded, (Crypto Ranking Chart), is the file I had made for me that ranks crypto assets by variables I use. It is a memory hog and takes a great deal of time to load so be warned. The coder who made it for me said he could fix that but I am unable to get hold of him. If you could fix that problem I would like that done also.

The code I am looking for and the ultimate goal is to fill in the data in all the "Day" sheets, columns M:EG of the Rank Change Results file. (1 Day - 20 Days). To accomplish this for July 30th I am currently copying the crypto symbols in column E of the PeriodAnalysis sheet of the Crypto Ranking Chart file and pasting that data in cell B7 of the Future sheet. Then based on the variables entered in cells C2:C3 of the Futures sheet I get the data I am looking for in column C for each crypto asset listed in column B. I then copy the prices in column C of the Futures sheet and paste the data in column G of the 1 Day sheet of the Rank Change results file. Formulas give me the results I am looking for in cells B2:G2 which I copy and paste in AH7:AM7 which corresponds to a Rank Change of 250 in 1 day 90 days later. As you can see i have done a rank change of 250 in 1 day for July 30th for 1 day later, 7 days later, 30 days later, and the 90 days later. You can see it would be an impossible tedious process to do all this by hand and why I am looking to get this automated. You can also see why I mentioned that if you as a coder had a better way of doing all this I would be all for it. I'm sure there will be questions so please ask if you are interested. Thank you.

Skills: Data Entry

See more: excel macro data cell, excel macro move data existing cell, macro move data cell, automate web data extraction, automate web data, acc data entry results, display vb6 access data search results, web service send xml data modify original xml data send results, script automate website data entry, automate website data entry, automate downloading data paypal, automate drupal data, i am a learner in grade 11 i need help i am worried about my future i want to become a lawyer how can i get a bursary in kzn, i need example of how to write a speech about my future and some point, speech about my future by a student that want to be a graphic design, you re a well organized person write a short paragraph to tell about your future expectation, data entry, excel word , ms office word work, translation from tamil to english and english to tamil, compose a detailed c++ source code to some elementary specifications and when i run the code it produces desired results, Rewrite a project on Data Hacking: The future of online storage, data entry, photo edit, list building, research leads generation, PDF conversion to word or excel format, Excel or spreadsheet t

About the Employer:
( 0 reviews ) Mesquite, United States

Project ID: #18114729

Awarded to:


Hi there,I am Miljan,Excel automating expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it wi More

$177 USD in 2 days
(83 Reviews)

2 freelancers are bidding on average $144 for this job


I define myself as a perfectionist. Who competes to beat his very own performance and then celebrates. This is something that brings me immense pleasure in the , I used to say, "I am a business student and intend to ho More

$111 USD in 3 days
(12 Reviews)