I have started a dynamic file that on selecting the futures ticker it pulls in 10 years historical futures prices from Bloomberg and then computes every combination of price change over the period. The model then allocates a % up and down over the respective period isolating all periods that are up or down more than 7 out of the last 10 years ie 70% The idea is to then present the outcomes either graphically or through conditional formatting where by all the periods are aligned against a Jan-Dec daily date row or column showing the sessional tendency of price to appreciate/decline. I have been using a lot of IF and VLOOKUP which has made the sheet extremely heavy and slow - The framework is there but I need someone to improve the formula logic possibly through VBA to make it more robust and efficient.
Just to be clear this is just an excel file. I just need someone to take the framework in the excel file I have started and improve the formula logic.
10 freelancers are bidding on average $165 for this job
I made a very conservative bid as the workload really depends on your file. It won't be difficult to improve a file with plenty of vlookup or so. I can use VBA or build an external library for critical parts.