Find Jobs
Hire Freelancers

Commodity futures seasonality model

$30-250 SGD

Ukończony
Opublikowano ponad 10 lat temu

$30-250 SGD

Płatne przy odbiorze
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.
Identyfikator projektu: 5128310

Informację o projekcie

10 ofert
Zdalny projekt
Aktywny 10 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
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 w 1 dzień
5,0 (14 opinii)
4,8
4,8
10 freelancers are bidding on average $165 SGD for this job
Awatar Użytkownika
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 w 1 dzień
4,9 (249 opinii)
7,6
7,6
Awatar Użytkownika
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 w 10 dni
4,9 (113 opinii)
6,2
6,2
Awatar Użytkownika
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 w 3 dni
5,0 (1 opinia)
1,6
1,6
Awatar Użytkownika
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 w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 2 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga AUSTRALIA
Sydney, Australia
5,0
2
Zweryfikowana metoda płatności
Członek od lis 14, 2013

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.