Find Jobs
Hire Freelancers

Excel sheet mathematics

$10-30 AUD

Completed
Posted over 8 years ago

$10-30 AUD

Paid on delivery
Dear Freelancer I require an excel sheet and mathematician to create a formula for me. The formula is based on the actual AUD/NZD exchange rate for the year period 2000 to today's date, using the weekly charts. You can find this easily online. The formula is to model an investors outcome if they applied the following rules: 1. Start with 10 lots of $1,000 AUD. 2. Each time the exchange rate moves down 300 points the investor buys $1,000 AUD worth of NZD. 3. Each transaction cost is 100 points (bank fee). 4. Each time the exchange rate moves up 300 points the investor sells $1000 worth of AUD. 5. Again, each transaction costs 100 points in fees. Please create the formula then model it against the historical exchange rates. Create a master variable area on the excel sheet so that the variables can be changed. We may need to communicate to work together to find a practicable solution. Many thanks
Project ID: 8241725

About the project

8 proposals
Remote project
Active 9 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
I have looked through your assumptions and thought of ways to complete your work. If the diversion of 300 points is referring to just plain weekly exchange rate changes, it is relatively easy to model your strategy using few "=if formula" on a spreadsheet. Alternatively, if you are referring to cumulative changes from transaction to transaction, i.e. buy/sell if 300 points change after the last transaction is made, the formula gets a bit more complicated. At first, I thought that I must use a macro to model this, but after playing around few minutes with excel, it seems that it is still doable without using macros. I can definitely separate the master variables for you to revise it from time to time. What I also think would be useful is separating historical exchange rate data tab from calculation area, in case you want to revise it. This way, you will be able to revise the data more easily and even use it to forecast estimated return by entering your forecasted datasets. After modelling is done, the work would be nearly finished as finding weekly historical exchange rate is just a few minutes of work. I am readily available by email in case you have more instructions. I expect to finish the model in an hour or two.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
8 freelancers are bidding on average $33 AUD for this job
User Avatar
12+ years of experience in: investment banking, financial research and analysis, accounting. CFA and ACCA candidate. Extensive experience with VBA, Excel, Word, Access, PowerPoint. Professional expert in financial accounting assignments. Professional expert in cost accounting assignments. Expertise in management accounting assignments. Professional expert in assignments of auditing. Expertise in solution writing assignments of financial,cost and management accounting. Vast experience in preparing financial statements. Audit related assignments expert.
$50 AUD in 3 days
4.7 (20 reviews)
5.5
5.5
User Avatar
Hello! I am a highly qualified business professional, currently doing my doctorate in economics and have tons of writing experience, I am very much excited and deeply interested in bringing laurels to your assignment, please assign me this task without any hassle and you will experience quality work on time. I am 100% Sure, you will award me all your writing tasks once you witness the quality of this task. Thanks!
$50 AUD in 3 days
5.0 (4 reviews)
3.8
3.8
User Avatar
I am a CAT (Certified Accounting Technician) and ACCA (Association of Chartered Certified Accountant) qualified, pursuing CFA (Chartered Financial Analyst). Hence, I have extensive knowledge of finance, accounts, audit, marketing, HR and business related matters. Though these subjects are my forte, being an academic writer, I have written reports, essays, dissertations & thesis on various other subjects as well.
$30 AUD in 1 day
4.6 (3 reviews)
2.2
2.2
User Avatar
Feel free to contact me to make work in excel . Budget is not any issue as well.I have team for quick and quality results. We can manage each and everything via private messages. Take a look on my 5 start feedback work.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
This is one of the job, i do on a regular basis; and i really wish to work with exchange rates and investments.
$30 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$24 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$21 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$31 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of THAILAND
Bangkok, Thailand
5.0
18
Payment method verified
Member since Jul 7, 2015

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.