[Solved]Forex Strength Spreadsheet Project Useful Rank Foreign Exchange Currencies Time Identify M Q37204255
Forex Strength Spreadsheet Project
It is useful to rank foreign exchange currencies over time toidentify market trends between these currencies. One way to helpidentify those trends is to create a table like the one shown belowwere a unique color has been placed in every cell for each currencycode. This assignment is to create a macro that will perform thistask. Duplicate the spreadsheet shown below and construct a macroto place a unique color for each of the eight different currencycodes (JPY, AUD, CHF, NZE, EUR, USD, CAD, and GBP) for cells A2through F9. The Excel spreadsheet is to be named Forex Strength.Two different independent control programs are to be written toaccomplish this task. Main Program #1 will use nested FORstatements to select each cell one at a time and Main Program #2will use nested DO loops. Both Main programs will select each cellone at a time and interrogate that cell to identify the currencycode. That Main program will pass control and the currency code toa subroutine named Forexcolors. The Forexcolors subroutine willlink a unique color code number to each foreign exchange and passcontrol that number back to the control program. The controlprogram will then use that number to fill that cell with thatunique color. Remember to dimension all variables and place a runbutton on the spreadsheet.
You must use call statements.
such as:
call forexcolors(cur,num)
subforexcolors(cur,num)
1 1-yr JPY AUD 4 CHF 5 NZD 6 EUR USD CAD GBP 6-mo3-mo 1-mo 10-day NZD AUD CAD JPY CHF GBP EUR USD 9-mo AUD NZD CAD Bp EUR CHF JPY USD JPY NZD AUD USD CHF EUR CAD GBP NZD AUD CAD JPY CHF EUR USD GBP NZD AUD JPY EUR CAD CHF USD GBP 3 RUN 3 10 Show transcribed image text 1 1-yr JPY AUD 4 CHF 5 NZD 6 EUR USD CAD GBP 6-mo3-mo 1-mo 10-day NZD AUD CAD JPY CHF GBP EUR USD 9-mo AUD NZD CAD Bp EUR CHF JPY USD JPY NZD AUD USD CHF EUR CAD GBP NZD AUD CAD JPY CHF EUR USD GBP NZD AUD JPY EUR CAD CHF USD GBP 3 RUN 3 10
Expert Answer
Answer to Forex Strength Spreadsheet Project It is useful to rank foreign exchange currencies over time to identify market trends … . . .
OR
