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
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
