Job description
For each currency:
Purchase: increases the amount of currency and decreases the balance of PLN.
Sale: decreases the amount of currency and increases the balance of PLN.
Ending states of currencies:
Based on purchase and sale transactions.
Profit/loss:
We will compare the starting and ending balances of PLN and currencies converted to PLN at the transaction rate.
In addition, it should be possible to calculate profit or loss for the whole month or selected period, individual days on separate sheets in one excel file.
Attached excel file without entered formulas
