Commodity Seasonality model in excel

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.

Habilidades: Processamento de Dados, Processamento de dados, Excel

Veja mais: excel sheet formula, Vlookup, excel vlookup, excel model, Excel Formatting, excel sheet formatting, excel row column, excel framework, vba vlookup, vba conditional formatting formula, excel column row, formula sheet, column row excel, bloomberg historical prices, vba bloomberg, model excel, ticker using, excel combination, excel vba vlookup, excel slow, vlookup excel, model present, excel vlookup formula, price file excel, daily excel sheet

Acerca do Empregador:
( 2 comentários ) Sydney, Australia

ID do Projeto: #5128382

1 freelancer está ofertando em mádia $8 para esse projeto


Hired by the Employer

$8 USD / hora
(45 Comentários)