Creation of an Excel that calculates currency balances and profit or loss from currency buying/selling operations

Employer
no avatar
Jakub
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

Published
on 2024-10-25
Category
The job in figures:
Creation of excel description above 100
Skills

Offers sent (5)

no avatar
MikSza
21 deals
on 2024-10-25
adding products
bookkeeping
data analysis
+ 6 more
Budget
Negotiable
Copyright
-
Expires in
30 days

Recent jobs from category