Foreign Exchange (forex or FX) is the trading of one currency for another. For example, one can swap the VND for U.S. dollar. Foreign exchange transactions can take place on the foreign exchange market, also known as the Forex Market.

business

Description

FPT University

Subject: Excel Programming

Practical Assignment

 

 

Foreign Exchange

(VND/USD)

 

 

Background Context

Foreign Exchange (forex or FX) is the trading of one currency for another. For example, one can swap the VND for U.S. dollar. Foreign exchange transactions can take place on the foreign exchange market, also known as the Forex Market.

 

The market determines the value, also known as an exchange rate, of the majority of currencies. Foreign exchange can be as simple as changing one currency for another at a local bank. It can also involve trading currency on the foreign exchange market.

 

(more detail please read investopedia.com)

 

 

Program Specifications

Using VBA in Excel implement an algorithm to trade the forex market with the VND/USD pair in 5 years with assuming your account is funded in VND with 100 standard lots of your base currency - 10,000,000 VND.

 

Requiments:

o   The trading process bases on the historical data of the USD/VND pair (finding in the website https://www.investing.com/).

o   Your trading volume in 5 years must be larger than 2000 standard lots.

o   The starting point of the five-year period is any point in 2000 to the present.

o   Your VND fund must be larger than zero and  USD fund must be not smaller zero at any point

o   A VBA Form to show your fund information.

 

Function details:

o   Trading transaction with sell/buy USD in each day

o   Write VND Fund, USD Fund, USD Trading, Volume information into Excel Sheet.

o   Next function (Button Next in VBA Form) to go to the next day

o   Run function (Button Run in VBA Form) to go to the end of trading transaction in five-year period


Related Questions in business category