Find Jobs
Hire Freelancers

Commodity futures seasonality model

$30-250 SGD

Opravljeno
Objavljeno pred več kot 10 leti

$30-250 SGD

Plačilo ob dostavi
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 projekta: 5128310

Več o projektu

10 ponudb
Projekt na daljavo
Aktivno pred 10 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
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 v 1 dnevu
5,0 (14 ocen)
4,8
4,8
10 freelancerjev je oddalo ponudbo s povprečno vrednostjo $165 SGD za to delo
Avatar uporabnika
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 v 1 dnevu
4,9 (249 ocen)
7,6
7,6
Avatar uporabnika
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 v 10 dneh
4,9 (113 ocen)
6,2
6,2
Avatar uporabnika
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 v 3 dneh
5,0 (1 ocena)
1,6
1,6
Avatar uporabnika
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 v 7 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 2 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava AUSTRALIA
Sydney, Australia
5,0
2
Plačilna metoda je verificirana
Član(ica) od nov. 14, 2013

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.