Completed

Excel Sheet Formula

Dear Freelancer

I require an excel sheet and mathematician to create a formula for me. I can provide a base sheet for you to work from (attached). Quick and simple project if you have the skills.

The formula is based on the actual AUD/NZD exchange rate for the year period 2000 to today's date, using the weekly charts. The formula is to model an investor's outcome if they applied the following rules:

1. Start with one lot $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.

6. Duplicate the formula 5 times so we can monitor the results at different starting rates.

7. Create a master sheet that shows the profit/loss balance of all 5 investments combined into one.

Please create the formula then model it against the historical exchange rates. We may need to communicate to work together to find a practicable solution.

Before applying please check the attached and be sure that you can complete the task as required.

Many thanks

Skills: Algorithm, Excel, Mathematics, Matlab and Mathematica

See more: starting up as a freelancer, master of excel freelancer, i need an excel freelancer, i need a mathematician, freelancer project fee from balance, freelancer in fees, freelancer fees rate, freelancer exchange rate, freelancer duplicate project, freelancer base rate, freelancer at 0 fees, formula it, find a freelancer today, applied bank, excel electronics formula sheet, apply formula sheet vb excel, formula sheet excel, buyers net sheet excel, microsoft excel formula sheet, excel formula sheet

About the Employer:
( 24 reviews ) Bangkok, Thailand

Project ID: #8292874

Awarded to:

someka

You dont need to recruit me to finish this. Give me an hour and i can complete it. If you are happy, we can finish the process. (as i need some good references im my profile, i provide this service) I have a 5,5 yea More

$15 AUD in 1 day
(142 Reviews)
7.1

26 freelancers are bidding on average $35 for this job

cgullapalli

Hi, I am good at excel. I have done quite good number of projects in finance section. I would like to work on this project.

$30 AUD in 1 day
(763 Reviews)
7.8
cugamelover

I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel project More

$40 AUD in 1 day
(345 Reviews)
7.6
zExcel

A proposal has not yet been provided

$45 AUD in 1 day
(250 Reviews)
7.6
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regard More

$45 AUD in 3 days
(203 Reviews)
6.8
tawakalgeek

I again, your sheet is already having -1 as Buy AUD, and 1 as Sell AUD. Its on the basis of the limit you set in your cell (i.e. 300). I don't find balance/sheet though. So, I'm assuming the formula is correct while we More

$45 AUD in 0 days
(27 Reviews)
6.1
dviruki

Dear Sir/Madam, I have financial background and 12 years of experience in data processing and analysis using Excel. I'm immediately available and can complete the task within several hours. Please contact me to discuss More

$25 AUD in 0 days
(65 Reviews)
5.4
kevivu

Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineerin More

$34 AUD in 2 days
(70 Reviews)
5.7
SharjeelSohail

A proposal has not yet been provided

$25 AUD in 1 day
(62 Reviews)
5.2
citijayamala

expert in excel and excel functions and have created a BI analysis tool for forex market as well and experienced MBA finance and bank manager

$100 AUD in 3 days
(58 Reviews)
5.4
charleslimnet

I am an accurate and reliable business/Accounting/finance Analyst. I am a proficient business expert with over eight years writing experience. I have experience in Business plan writing, payroll, bank reconciliation, j More

$50 AUD in 1 day
(34 Reviews)
5.1
zubairkhan80

Hi, I have a formula and function for fulfill your requirement. Hope you like my work. Thanks Zubair

$45 AUD in 1 day
(6 Reviews)
3.2
hiteshbbakutra

Professional Data Scientist. Expert in Excel and VBA. More than 5 years of experience in automating complex excel. Can finish this job in hours time.

$25 AUD in 1 day
(8 Reviews)
3.3
Opeyemi856

I understand that you require a spreadsheet prepared to advise based on AUD/NZD exchange rates from the year 2000 to date. I have worked for over 11 years with Microsoft Excel. In the past 7 years, I have used exce More

$30 AUD in 1 day
(8 Reviews)
3.2
fb55504d0e01bfc

I can help you in this simulation project on EXCEL for $25 (=2,5 hours net). Looking forward to our collaboration Sincerely yours Panagiotis

$30 AUD in 3 days
(1 Review)
2.2
achilies

Good Day Sir, I am an IT Professional with 6 yrs of VBA/Macros Experience. I will be able to assist you in creating VBA/Macros for the below request. I have verified the formulas in each cells that you have already More

$10 AUD in 1 day
(4 Reviews)
2.5
shrutic66

I know I am in 19th place but I am sure I can complete this work easily and efficiently. I have always scored above 95 out of 100 without preparation. Thank you. Regards, Shruti.C

$25 AUD in 1 day
(1 Review)
1.8
wfhin2015

Hi, I am interested to work. I have completed 2 projects on this portal successfully. Looking forward for your response. Thanks.

$24 AUD in 1 day
(1 Review)
1.1
mukrrambajwa11

A proposal has not yet been provided

$12 AUD in 1 day
(1 Review)
0.8
antic9

A proposal has not yet been provided

$25 AUD in 1 day
(1 Review)
0.6
kurbyaustin6

I am an Electrical/Computer Engineering major at Mississippi State University and I have advanced experience in Windows Programs and Microsoft (Excel, Office, ect., ). I have completed various work related tasks that i More

$25 AUD in 1 day
(1 Review)
0.6