Find Jobs
Hire Freelancers

Commodity futures seasonality model

$30-250 SGD

Completed
Posted over 10 years ago

$30-250 SGD

Paid on delivery
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.
Project ID: 5128310

About the project

10 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 1 day
5.0 (14 reviews)
4.8
4.8
10 freelancers are bidding on average $165 SGD for this job
User Avatar
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 in 1 day
4.9 (249 reviews)
7.6
7.6
User Avatar
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 in 10 days
4.9 (113 reviews)
6.2
6.2
User Avatar
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 in 3 days
5.0 (1 review)
1.6
1.6
User Avatar
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 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
2
Payment method verified
Member since Nov 14, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.