Find Jobs
Hire Freelancers

Commodity futures seasonality model

$30-250 SGD

Terminado
Publicado hace más de 10 años

$30-250 SGD

Pagado a la entrega
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.
ID del proyecto: 5128310

Información sobre el proyecto

10 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 project. I will use VBA macros to populate the data you need for the associated graphs / tables. I can start working on a FREE SAMPLE. Just send me a message here on Freelancer.com with more details / files. Thanks ABOUT TABLASSUS SOFTWARE: ========================== I've been working on this kind of work on the past 8 years (handling complex data in excel files). In my actual work I deal with complex data structures (using excel) so achieving your goal shouldn't be a problem. I have +20 years of programming experience being highly skilled in Visual Basic (VB or VBA for applications). I have a daily job on a worldwide well know corporation (Bureau Veritas) as programmer / consultant. I also teach Physics, Math and chemistry. I also excel at Math, Statistics and genetic algorithms applied to computation. I have Skype / MSN in case you need to schedule up a meeting. I have excellent communications skills / english language background. Even so, it seems a very nice and challeging project. Feel free to ask for more details / information Looking forward to hear from you and start this interesting project. Best regards Filipe Francisco , VB Expert ============================== Tablassus Software "Simple solutions for complex problems"
$127 SGD en 1 día
5,0 (14 comentarios)
4,8
4,8
10 freelancers están ofertando un promedio de $165 SGD por este trabajo
Avatar del usuario
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 difference
$133 SGD en 1 día
4,9 (249 comentarios)
7,6
7,6
Avatar del usuario
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 response. Thanks.
$155 SGD en 10 días
4,9 (113 comentarios)
6,2
6,2
Avatar del usuario
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 than only I can tell if I can do it or not. Atleast provide me the file. Thanks Shashank Agrawal
$250 SGD en 3 días
5,0 (1 comentario)
1,6
1,6
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 charts you need. Let me know if interested. Thanks, Tim.
$200 SGD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 but I enjoy working in Excel so I'm eager to find new challenges. If you would like to hear more about my education and experience let me know. Good luck with your project!
$111 SGD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Sydney, Australia
5,0
2
Forma de pago verificada
Miembro desde nov 14, 2013

Verificación del cliente

Otros trabajos de este cliente

Commodity Seasonality Model 2
$250-750 SGD
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.