Excel sheet mathematics

$10-30 AUD

已完成

已发布

将近 9 年前

$10-30 AUD

货到付款

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

项目 ID: 8241725

关于此项目

8提案

远程项目

活跃9 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@ImperativeGroup

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 在1天之内

0.0

(0条评论)

0.0

8威客以平均价$33 AUD来参与此工作竞价

@coolwriter30

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 在3天之内

4.7

(20条评论)

5.5

@DominiqueFranc

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 在3天之内

5.0

(4条评论)

3.8

@Abbadwajid

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 在1天之内

4.6

(3条评论)

2.2

@coolomar1998

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 在1天之内