Reference no: EM13936097
Market information on the internet. Use your own institution's currency database or visit https:// www.oanda.com/convert/fxhistory, to obtain exchange rate data covering at least one year, copy and paste the results into Excel and answer the following questions:
a. Determine the cross exchange rate between the Japanese yen and the Australian dollar. Compare the cross exchange rate with the direct rate. Are there any differences? Evaluate the significance of your results.
b. Select a pattern, for example two days of consecutive falls, then select and check the move- ments on the following day (the third day in this case). Are the following day movements unusual in any way? Evaluate the significance of your results.
It is helpful to use nested ‘if' instructions in Excel. In this example two days of consecutive falls is the criteria for selecting the third day's price movement. An instruction placed in C4 and copied and pasted to C365 with exchange rates from B1 to B365 would be: ¼IF(B3>B2, IF(B2>B1, B4,‘‘ ''),‘‘ '') a run of three days would be: ¼IF(B4>B3,IF(B3>B2,IF(B2>B1,B5,‘‘ ''),‘‘ ''),‘‘ '') note that ‘‘ ''; is simply a double inverted comma, Excel ignores gaps so ‘‘ '' will also work. Once applied, choose ‘Data' and ‘sort' from the toolbar to get rid of the blanks.
Note that the Excel formula can be varied so that for instance < may="" be="" used="" and="" other="" operands="">¼, þ, - and so on. Formulas may also be incorporated so that if only large movements were of interest one could write:
¼IF(B4>B3*1.1,IF(B3>B2*1.1,IF(B2>B1*1.1,- B5,‘‘''),‘‘ ''),‘‘ '')
Experiment with the formula to obtain the desired pattern.
|
What are some of the characteristics that you observe
: Observe someone with a chronic illness in their natural environment. What are some of the characteristics that you observe? Are they comfortable or in pain
|
|
Why do interest rates vary among countries
: Why do interest rates vary among countries? Why are interest rates normally similar for those European countries that use the euro as their currency?
|
|
Dilemma or ethically questionable situation relating
: Identify a recent (within the last six (6) months) ethical dilemma or ethically questionable situation relating to ICT that you are familiar with. This situation can be either in the media (for example one you have sourced from a newspaper, or onl..
|
|
What are the total contributions of the charter flight
: What are the net income losses for this two-day period if the airline refuses the90-seat charter, stays in business, but temporarily shuts down? What are the netincome losses if it decides to operate and fly the charter that has been proposed?
|
|
Compare the cross exchange rate with the direct rate
: Determine the cross exchange rate between the Japanese yen and the Australian dollar. Compare the cross exchange rate with the direct rate. Are there any differences? Evaluate the significance of your results.
|
|
Microsoft dynamics introduction
: Topics: navigation, role center, productivity enhancement, decision support, workflow, industries supported, etc. Please write 1 FULL page report on what you have learned from this video (double space, font size 12) When watching videos, please ta..
|
|
Create a catch block that catches the exception
: Write a C# console application in which you declare an array of five integers and store five values in the array.
|
|
Review of e-learning materials
: Assignment 1 - Review of e-Learning materials This is a mandatory assessment For weeks 3, 4 and 5 e-Learning materials will be placed on Blackboard for review and application.
|
|
What in your opinion happened to the equilibrium price
: In the world of electronics overtime people realized the immense use of having a personal laptop. And at the same time the technology has improved significantly in last decade. In fact the technological improvement has surpassed the increase in willi..
|