Excel sheet mathematics

$10-30 AUD

Dokončeno

Zveřejněno

před více než 8 roky

$10-30 AUD

Zaplaceno při doručení

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

IČ projektu: 8241725

O projektu

8 nabídky

Vzdálený projekt

Aktivní před 9 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@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 v 1 dni

0,0

(0 recenze)

0,0

8 freelanceři nabízejí v průměru $33 AUD za tuto práci

@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 v 3 dnech

4,7

(20 recenze)

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 v 3 dnech

5,0

(4 recenze)

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 v 1 dni

4,6

(3 recenze)

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 v 1 dni