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.