Job description
Using the attached CSV file using Postgres, Pentaho and BIRT, generate a report (in pdf. form) containing:
-Title: "PPK Project Task - currency report:" (+first and last names)
-Table containing (in this order):
average value of the exchange rate (according to the price close);
the average value of the price fluctuation in the candle (high-low);
number of candles
average volume
-Percentage chart of falling/rising candles (so-called circular)
-Chart of average closing price of candles (close) for each month
-Chart of average candlestick price fluctuation (high-low) for each month
-Report covers the period from 01.01.2019 to 01.01.2020.
-On the last page include a description of the determination of data for charts (queries in DataSet or postgres, etc.).
The file is quotes of currency pairs in the form of candles:
date - the date of the quote
time - the time of the quote
open - the opening price of the candle
high - the max price in a given candle
low - min price in a given candle
close - the closing price of a candle
volume - volume
