Find Jobs
Hire Freelancers

Automate Crypto Data

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 18114729

About the project

2 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$177 USD in 2 days
4.9 (87 reviews)
6.9
6.9
2 freelancers are bidding on average $144 USD for this job
User Avatar
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 hold a degree in finance" but now I introduce myself as a blogger or as a writer because writing is something I find myself at ease where and love doing and aim to achieve folks, this is just the beginning and there is a lot more to come!
$111 USD in 3 days
5.0 (12 reviews)
4.1
4.1

About the client

Flag of UNITED STATES
Mesquite, United States
0.0
0
Payment method verified
Member since Aug 25, 2018

Client Verification

Other jobs from this client

Ranking System
$30-250 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.