Commodity futures seasonality model

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.

Habilidades: Excel, Finanças, Mercado Financeiro, Pesquisa financeira

Veja mais: daily finance, excel sheet formula, excel 2013 vba, Vlookup, excel vlookup, excel model, c bloomberg, excel sheet formatting, excel framework, excel 2013 formula, vba vlookup, vba conditional formatting formula, formula sheet, dec 2013, bloomberg historical prices, vba bloomberg, model excel, ticker using, excel combination, excel vba vlookup, excel slow, vlookup excel, model present, excel vlookup formula, price model

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

ID do Projeto: #5128310

Concedido a:


Dear Sir This project seems interesting and doable based on my past experience with this type of problem. THE SOLUTION: ============ I have done in the past +50 dinamyc dashboards so I can easily do this proje Mais

$127 SGD em 1 dia
(14 Comentários)

10 freelancers are bidding on average $165 for this job


Hi, I will try to help you with creating this macro rather quickly but I need to see the file before making any commitment. Could you please send me the file and I'll get back to you asap subject to time zone differenc Mais

$133 SGD em 1 dia
(249 Comentários)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive Mais

$155 SGD in 10 dias
(113 Comentários)

My name is Paul Donnelly and I am a business analyst with 7 years experience building custom VBA applications and databases for one of Ireland's largest trading firms. I came across your project on Freelancer, and Mais

$240 SGD in 5 dias
(3 Comentários)

I have a 2 years of experience in trading German, U.K, U.S markets and good knowledge of excel. I can try and improve on your strategy but I can do it in excel only. I don't know VBA. If you can provide me the file tha Mais

$250 SGD in 3 dias
(1 Comentário)

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.

$250 SGD in 7 dias
(0 Comentários)

Hi Sam! If you want speed I could recode your VBA framework using Python and C libraries, this would make the program execute lightning fast. The program could the automatically export to Excel or create the pdf chart Mais

$200 SGD in 3 dias
(0 Comentários)

Hi there. I can help you making your spreadsheet faster without losing functionality. I have proficiency in excel, macros and VBA Good luck.

$125 SGD in 3 dias
(0 Comentários)

Hallo there! As you see my work will be super cheap, as I try to establish my credibility on freelancer. I m currently a Ph. D. in Finance candidate and I used VBA extensively during my training. Do not miss out Mais

$56 SGD in 5 dias
(0 Comentários)

I am an equity research associate at a reputable investment firm in Chicago, IL. Every day I develop simplified tools in Excel to assist in our valuation, scans, or portfolio management needs. I'm new to this site bu Mais

$111 SGD in 2 dias
(0 Comentários)